Skip to content
Make maps

County map from your data

Paste a spreadsheet with one number per US county, by FIPS code or by name and state, and see it as a color-coded map right away, with a legend. Rows that can’t be matched are listed so you can fix them.

Example: population on July 1, 2025 and change since 2020 (Census Bureau). Replace it with your data.

Getting the names ready…

Breaks

Loading the map…

How to use it

Choose what your data is by: US counties or states (or Spanish provinces, regions and municipalities). Copy the cells from Excel or Google Sheets and paste them into the box, or upload a CSV. Two columns are enough, the place and a value; if there are more, you pick which is which. The first row can be a header or not.

The map updates as you type. Under your data you’ll see how many rows were matched, the ones matched despite a typo (with the name they were matched to, so you can check) and the ones that couldn’t be matched, with their line number and the reason.

FIPS codes and county names

The safest way is the 5-digit county FIPS code (2 digits for the state and 3 for the county) for all 3,144 counties and county equivalents. It still works when a spreadsheet dropped the leading zero (“1001” for Autauga County, Alabama, 01001), or with the state and county codes in separate columns.

With names, add the state: in the same cell (“Cook County, IL”, “Cook, Illinois”) or in a column of its own, by name, postal abbreviation or FIPS code. “County”, “Parish” or “Borough” are optional, capitals and accents don’t matter, “Saint” and “St.” are the same, and a typo or two is fine. Names that exist in more than one state, like Washington County, need their state; names shared by a county and an independent city, like Baltimore, need “County” or “city”.

How the colors work

By default, the breaks are rounded quantiles: each color holds about the same number of counties, and the break values are easy-to-read round numbers. You can also use equal intervals or type your own breaks. Colors go from light to dark, so the map still reads in grayscale or printed in black and white.

If your data has both negative and positive values (a change, a balance), the map is centered on 0: browns below and greens above. Counties with no data stay white, and the legend counts how many fall in each color.

Download and share

County maps sit on a base map you can zoom into, with a PNG image, the top and bottom 10 and a CSV of your data with the official FIPS codes and names. State maps (and Spanish provinces and regions) are drawn as print-ready maps you can download as PNG, SVG or an A4 or A3 PDF, with your title, the legend and the source.

“Copy link” stores your data and settings in the page address (after the #, so it never leaves your browser), unless there’s too much of it.

Frequently asked questions

Is my data uploaded anywhere?

No. Everything runs in your browser and your data is never sent to a server. If you copy the link, the data travels inside the address itself.

Can I upload an Excel file?

Upload a CSV or, quicker, select the cells in Excel, copy them and paste them into the box. .xlsx files can’t be read directly.

What do I do with rows that aren’t matched?

They’re listed with their line number and the reason: a name that doesn’t exist, a code that isn’t a county, or a name used in several states. Fix them in the box, or use the FIPS code, and the map updates on its own.

Do I need FIPS codes?

No. County names with their state work too, like “Miami-Dade County, FL” or “Orleans Parish, Louisiana”. FIPS codes are just the most reliable option.

What if a county appears twice?

Its values are added up, which is usually what a list of sales or cases means. You can choose to keep the last one or take the average instead.

Can I map data by state instead?

Yes: choose “US states” and paste one row per state, by name, postal abbreviation (TX) or FIPS code (48).

Can I use the map in a report or on a website?

Yes. The county and state boundaries come from the U.S. Census Bureau and are in the public domain. The image carries the source and “Data: your own” at the bottom.

Related tools

All tools
US county map Explore every US county on an interactive map colored by Census data such as population or income. County map with cities Pick a US county and see it on the map with all its cities and towns, ready to print or download. Printable map worksheets Print blank-map worksheets with questions and an answer key, ready as a PDF for class or home. Map quiz Learn states, countries and capitals by finding them on a blank map. No sign-up, with a class challenge link.

Sources