Blank Census sheet, field instructions and separate fictional examples.
Download Excel templateDownload blank CSVStart with the people.
Get the census right here.
Download a ready-to-use template, check your completed file, or enter a small group manually. We highlight missing fields and help confirm each home county before you move to quoting.
One employee at a time. Add a spouse or children to the same household.
Start manual entryUpload CSV or Excel for an on-screen review. Correct the fields below.
Your census stays in this tab until you download it. Only the five-digit ZIP is sent to the existing CMS county lookup. Use household IDs rather than names. Never include SSNs, diagnoses, claims, banking information or medical histories. This tool does not store or submit your census.
What you need before a quote.
Household ID, relationship, date of birth, home ZIP, actual home county and state, intended coverage tier, enrollment choice, CMS rating sex and confirmed tobacco history.
Why does county matter?
A ZIP can span several counties. We look up the available counties from the existing CMS integration. A single clear match can be filled from the lookup; if there is more than one, choose the person’s actual home county. Existing conflicting information is flagged for review.
How do family members work?
Use one row per person. Spouses and children share their employee’s household ID. Include every person intended for coverage, with their own birth date and rating details. Confirm any copied residence or enrollment information. Actual different household residences need agency review.
What if I’m missing a birth date or payroll information?
A missing birth date remains pending; an age is not converted into a guessed birth date. Payroll and current employee premium fields are optional here and may be needed for additional analysis. Do not infer hourly or salaried status from full-time or part-time employment.
Build your census.
Review, download, then quote.
Format readiness is not a verified premium or an affordability result. Plan availability, rating and employer requirements are reviewed separately in the quote workflow.
There is no automatic saving. Download a draft if you need to finish later. Importing another file replaces this tab’s working rows.
More than 100 people, different residences within a household, or a field you cannot confirm? Use the blank template and request help through the Quote Center. Missing inputs stay pending.