How the lookup works
An address is text; a county is an area. To connect them we first turn the address into coordinates with the US Census Geocoder, which matches it against the Census Bureau's national street database. Then we find which county polygon contains that point. The result is the county where the address actually sits, not the county most associated with its city or ZIP code.
Batch CSV: up to 1,000 rows
For a spreadsheet of addresses, upload a CSV. Put the street, city, state and ZIP in separate columns, or in one full-address column. Each run takes up to 1,000 rows; split larger files into chunks. The spreadsheet guide shows the whole round trip for Excel and Google Sheets. The download keeps your original columns and adds:
| Column | What it holds |
|---|---|
| Matched address | The address as the geocoder standardized it |
| Match quality | Exact, non-exact, or no match |
| Latitude, longitude | The matched point |
| County name | The county or county-equivalent containing the point |
| County FIPS | The five-digit state-plus-county code |
Uploads pass through our server to the Census batch geocoder and are not stored. See the privacy page for details.
Reading match quality
An exact match means the address was found as written. A non-exact match means the geocoder corrected something, such as a street suffix or house number, and placed the point along the matched street segment. House positions are interpolated along each block, so a point can land tens of meters from the actual house. That rarely changes the county, except for addresses on a road that forms the county line. No match rows are left blank for you to fix and resubmit.
Why ZIP-to-county is ambiguous
ZIP codes are postal delivery routes. They were drawn for mail trucks, not for governments, and about 30% of them cross county lines. A ZIP-to-county table can only give you the county where most of a ZIP's addresses fall, which is wrong for everyone else in that ZIP. For sales tax, insurance rating, jurisdiction or reporting, use the full address. What ZIP code am I in explains how ZIP areas are drawn.
FIPS codes in spreadsheets
A county FIPS code is five digits: two for the state, three for the county. Excel and Google Sheets drop leading zeros if they treat the column as a number, turning 06037 (Los Angeles County) into 6037. Import the column as text, or pad it back to five digits, before joining it to other data. For the details of independent cities, parishes and boroughs that appear in the county column, see what county am I in.
Add this county lookup to your website
Free for title companies, real-estate sites, clerks and libraries. Paste this code where you want the lookup to appear. It needs no account and stores nothing.
<iframe src="https://whatamiin.com/embed/county-lookup/" title="County lookup" width="100%" height="460" style="border:1px solid #e2e0d8;border-radius:12px" loading="lazy"></iframe>
See a live demo and setup notes on the county lookup widget page.