This spreadsheet includes a lists all U.S. counties with their county FIPS codes and state FIPS codes, as well as the county population. You can easily filter and sort to see the largest counties by state. The spreadsheet also maps county FIPS to ZIP codes. Explore the County FIPS code spreadsheet for free in Row Zero, a powerful spreadsheet built for big data.
Open County FIPS Code Spreadsheet
County FIPS Dataset Summary
This free county FIPS code spreadsheet includes multiple sheets of FIPS state and county codes as well as ZIP codes by county. The data and FIPS code crosswalks are sourced from the U.S. Census Bureau and U.S. Office of Housing and Urban Development. You can use these crosswalks to easily map county FIPS codes to state FIPS codes, filter to a list of all counties by state, or as a bulk FIPS county code lookup.
Here are the sheets included in the dataset:
If you want to additional county data, view the county demographic data set.
County FIPS code list
The County FIPS code sheet includes a list of all U.S. counties with their state. The sheet includes county and state FIPS codes, so you can easily crosswalk county FIPS codes to state FIPS codes. Note that the first two digits of the county FIPS code is the state FIPS code. The sheet also includes County Population, State Population, and County % of State Population, so you can easily look up largest counties by state. 
What is a county FIPS code?
A county FIPS code is a unique five-digit code assigned to each county in the U.S. The first two digits of a county FIPS code represent the state FIPS code, and the last three digits represent the specific county within that state. FIPS codes (Federal Information Processing Standards) are unique codes used to identify U.S. geographic locations including counties, states, and places. View place FIPS codes here.
County FIPS to ZIP code
The County FIPS to ZIP sheet maps county FIPS codes to ZIP codes with one row for each combination of county and ZIP code. Note that some ZIP codes map to multiple counties. The sheet includes a column for '% of County Residents in ZIP' so you can sort to see the largest ZIP codes by county in terms of the ZIP code's contribution to the county's population. 
You can use this sheet to filter to a list of ZIP codes in each county. If you want to go in the reverse direction and map ZIP codes to county FIPS codes, use the ZIP code to county FIPS codes dataset.
State FIPS codes
The State FIPS codes sheet includes a list of all U.S. states with their full state name, state abbreviation, state FIPS code, and population. 
Use Cases for this Dataset
Row Zero is a spreadsheet for big data, so you can easily import your data into this county FIPS code spreadsheet (or vice versa) to map your data or just start exploring the data with filter, sort, functions, pivot tables, charts, etc. Here are a few common use cases:
- Enrich your current datasets with county or state data. FIPS codes give you a common unique identifier to connect location datasets. You can use XLOOKUP to map FIPS county and state codes across multiple datasets.
- Import the list of county FIPS codes and the county to state FIPS codes crosswalk data directly to your database or data warehouse, so that you can normalize county and state data in your data warehouse. Row Zero supports write-back to Snowflake, Databricks, Redshift, Postgres, and more.
- Use filter, sort, and search to lookup county FIPS codes, sort largest counties by state, or filter to a list of ZIP codes by county.
Data Sources
Data sources for this county FIPS code dataset include the U.S. Census Bureau 5-year estimate tables from the American Community Survey, as well as the U.S. Office of Housing and Urban Development. ZIP code population is included for ZIP Code Tabulated Areas (ZCTAs) which are ZIP codes of populated areas. Data has been updated as of September 2025 with the most recent data available.