A whole list of ZIPs, matched to counties
Paste ZIP codes or drop in a spreadsheet. Every row comes back with its county, city, state and FIPS code, ready to copy or download.
Messy lists are fine
Spreadsheet damage, fixed
Excel turns 02134 into 2134. We put the zeros back, trim ZIP+4 codes to five digits, and say which rows we tidied.
ZIPs that cross county lines
9,806 ZIP codes sit in more than one county. Each is matched to the county holding most of its land, with the others listed. Or get a row for every county.
Your columns stay put
Upload a CSV with names, sales or anything else. The download keeps every column and adds the county data on the right, in the same row order.
ZIP to county questions
How do I convert a list of ZIP codes to counties?
Paste the ZIP codes into the box above, one per line or separated by commas, or upload a CSV file. Each ZIP is matched to its county right away. Copy the results or download them as a CSV.
What happens with ZIP codes that are in more than one county?
A ZIP code is a mail route, not a county area, so many cross county lines. We match each ZIP to the county that holds the largest share of its land and list the other counties with their shares. Choose Every county to get one row per ZIP and county instead.
Can I add a county column to my spreadsheet?
Yes. Upload the sheet as a CSV and download the result, which keeps your columns and adds county, state and FIPS. Or paste just the ZIP column, press Copy county column, and paste it into the next column of your sheet. The rows line up.
Is my data uploaded anywhere?
No. The ZIP to county list loads into your browser once, and the matching happens on your device. The file you pick is never sent to us.
Where does the ZIP to county data come from?
It comes from the U.S. Census Bureau’s 2020 ZIP Code Tabulation Areas and its ZIP to county relationship file, which measures how much of each ZIP’s land falls in each county. PO box ZIPs, which have no area, are placed in the county where their post office is. The list covers 41,154 ZIP codes.
Why does a ZIP say “Not a ZIP in use”?
It isn’t in the current ZIP code list. It may be a typo, a ZIP the Postal Service retired, or a number from another column. Check the row, fix it and the match updates right away.
Need one ZIP? Every ZIP code page shows its county on a map. To see where your list falls, paste it into the ZIP code map maker.