How many ZIP Codes are there in the U.S.?

There are 39,493 ZIP codes according the most recent data available from the U.S. Census.

Can ZIP codes map to multiple states?

Yes, more than 100 ZIP codes cross state boundaries and map to multiple states.

Can ZIP codes map to multiple counties?

Yes, hundreds of ZIP codes cross county boundaries and map to multiple counties.

Can you use the ZIP Code to State lookup in Excel or Google Sheets?

Yes, you can download as a CSV file and open the ZIP code list in Excel or Google Sheets. However, once you add your data to the file, the file may be too big for Excel or Google to handle, which may slow down your spreadsheet.

What is a metropolitan statistical area?

A metropolitan statistical area (or metro area) is a geographic location with at least one urbanized area with a population of 50,000 or more and includes the surrounding counties that have strong economic and social ties to the urban core as measured by commuting patterns. Metro Areas are defined by the U.S. Office of Management and Budget (OMB).

What is the difference between a metropolitan statistical area and a micropolitan statistical area?

The main difference between metropolitan statistical areas vs micropolitan statistical areas is population size. Metro areas have a population of 50,000 or more and micro areas have a population between 10,000 and 49,999.

ZIP Code to State, County, Metro in a Spreadsheet

Q: What is a ZIP Code?

A ZIP code is a postal code used by the United States Postal Service (USPS) to identify specific geographic locations and routes within the United States.

Q: What does ZIP stand for?

ZIP stands for 'Zone Improvement Plan'.

View the ZIP Code Spreadsheet

Need an easy way to map your list of ZIP codes to state, county, town, metro, or congressional district? Row Zero is the best spreadsheet for big data and we've built a free ZIP code lookup in a spreadsheet.

Row Zero is 1000x more powerful than traditional spreadsheets and connects live to your data warehouse. Click the links below for the ZIP code mapping you need or explore the full spreadsheet of ZIP Code data.

ZIP Code to State, Town, Metro
ZIP Code to County
ZIP Code to Congressional District
County to ZIP Codes
Metro Area to ZIP Codes
Congressional District to ZIP Codes
ZIP Code Demographics
How to map ZIP to state using XLOOKUP
Connect ZIP Code lookup to your data warehouse
Zip Codes in Excel or Google Sheets
What is a ZIP Code?
Data sources

ZIP Code to State, Town, Metro

View Spreadsheet
This spreadsheet includes the full list of U.S. ZIP codes by state, town and metro area. There is one row for each of the 39,493 US ZIP codes. Columns include ZIP Code, State, City, Metro, ZIP Code Population. You can use this ZIP to state lookup to enrich your existing data or do a simple lookup. zip code spreadsheet

NOTE: This United States Postal Service ZIP code lookup uses the "preferred" City and State for each USPS ZIP code as defined by the U.S. Postal Service. However, there are a few dozen ZIP codes that cross state boundaries and map to more than one state. This spreadsheet limits each ZIP code to one row and the "preferred" mapping for ease of use resulting in 39,493 ZIP codes.

Need help mapping this in your sheet? View how to map ZIP to state using XLOOKUP

ZIP Code to County

View Spreadsheet
This spreadsheet maps all U.S. ZIP codes to their county or counties. There is one row for each unique ZIP to county mapping. Note that ZIP codes can map to multiple counties, so there is more than one row for any of these ZIP codes. To help with this, the spreadsheet also includes the percentage of the ZIP code population that is located in a given county. For example, ZIP Code 35006 in Alabama maps to Jefferson County (93% of ZIP Code residents), Walker County (5%), and Tuscaloosa County (2%).

Columns in this ZIP to County lookup include ZIP Code, State, City, County, State Abbreviation, County FIPs Code, ZIP Code Population, % of ZIP Residents in County, # of Counties.

ZIP Code to Congressional District

View Spreadsheet
This spreadsheet maps all U.S. ZIP codes to Congressional Districts in the U.S. House of Representatives. There is one row for each unique ZIP to Congressional District mapping. Note that ZIP codes can map to multiple Congressional Districts, so there is more than one row for these ZIP codes. The spreadsheet includes the percentage of the ZIP code population that is located in a given Congressional District to help with this. For example, ZIP Code 35087 in Alabama maps to Alabama's 4th District (62% of ZIP Code residents) and Alabama's 5th District (38% of ZIP code residents).

Columns in the sheet include ZIP Code, City, State, Congressional District, Congressional District State, Congressional District Number, Congressional District Code, ZIP population, % of ZIP Residents in CD, and # of Congressional Districts ZIP maps to.

County to ZIP Codes

View Spreadsheet
This spreadsheet provides a list of ZIP codes by county. There is one row for each unique county to ZIP code mapping. Note that each county maps to multiple ZIP codes so there is more than one row for each county. To help with this, the spreadsheet includes the percentage of the county population that is located in a given ZIP Code. Finally, note that ZIP codes can cross county boundaries so some ZIP codes are mapped to multiple counties and ZIP codes are not necessarily fully contained within the county boundary.

Columns in this County to ZIP lookup include County, State, County FIPs Code, ZIP, USPS Default City for ZIP, USPS Default State for ZIP, % of County Residents in ZIP, County Population.

Note: You can also click on the County to State sheet in the workbook to see county to state mappings and county population so you can sort the largest counties in each state.

Metro Area to ZIP Codes

View Spreadsheet
This spreadsheet provides a list of ZIP codes by metro area. There is one row for each unique metropolitan statistical area to ZIP code mapping and one for each micropolitan statistical area to ZIP code mapping. Note that each metro maps to multiple ZIP codes so there is more than one row for each metro and micro area. To make this easier to understand, the spreadsheet includes the percentage of the metro area population that is located in a given ZIP Code. You can easily filter and sort to see the largest ZIP codes by metro.

Columns include Area Name, CBSA Code, Metropolitan/Micropolitan Statistical Area, ZIP Code, City, State, % of Metro Residents in ZIP, Total Metro Residents.

Congressional District to ZIP Codes

View Spreadsheet
This spreadsheet provides a list of ZIP codes by Congressional District. There is one row for each unique Congressional District to ZIP code mapping. Note that each district maps to multiple ZIP codes so there is more than one row for each Congressional District. The spreadsheet includes the percentage of the Congressional District population that is located in a given ZIP Code to make this easier to work with.

Columns include Congressional District, Congressional District State, Congressional District Number, Congressional District Code, ZIP Code, USPS Default City for ZIP, USPS Default State for ZIP, % of CD Residents in ZIP.

ZIP Code Demographics

View Spreadsheet
This spreadsheet provides comprehensive ZIP code demographic data from the U.S. Census using the most recently available data from the annual American Community Survey. The dataset includes ZIP code population by age, gender, and race for every U.S. ZIP Code.

Since Row Zero is 1000x more powerful than traditional spreadsheets, you can easily explore massive files and the latest U.S. Census Data by ZIP Code (or any other location level). These spreadsheets contain a small sampling of the available data at Census.gov, which you can download and open in Row Zero for free.

How to map ZIP to State in your data using XLOOKUP

You can easily import your data into the spreadsheets above to map your data (or vice versa). Row Zero can open and edit big CSV files, parquet files, and other large file formats. You can also connect the spreadsheet directly to your data warehouse.

Once all of the data is in the sheet, you can use a simple XLOOKUP or VLOOKUP function to map your data. Here's how to use XLOOKUP if you need help.

Here is an example using XLOOKUP to map ZIP code to state in your data:

Get your data in one sheet and the ZIP lookup data in another sheet. Make sure your ZIP code data is in plain text format and not a number.
In the sheet with your data, in a new column type "=XLOOKUP(". For key, select the cell with the ZIP code you'd like to map.
Then navigate to the ZIP lookup data sheet and select the ZIP code column as the lookup range, and then State column as the return range. Then add a comma and "" so that it returns blank if not found. Hit enter.
Your new column will now fill in with the State that maps to the ZIP code. Pull the formula down and your done!

Connect ZIP Code Lookup to your data warehouse

Need to enrich data in your data warehouse with ZIP code mappings to state, county, etc.? Row Zero free plans allow you to connect your data warehouse to the ZIP code lookup (or any spreadsheet) to dynamically import your data. Row Zero Business plans support write-back to your data warehouse. Row Zero can connect live to several data sources including Snowflake, Databricks, Postgres, S3, and Redshift.

Challenges with ZIP codes in Excel or Google Sheets

Given the large number of ZIP codes, it can be a challenge to work with your data plus a big list of ZIP codes in Excel or Google Sheets. Excel has data limits and will slow down with a lot of data. Google Sheets limits are similar. To get around the limits of Excel and Google Sheets, you can use Row Zero. Row Zero has an experience similar to Google Sheets but was built for big data sets. It's free to try. Try Row Zero ZIP Code Lookup

What is a ZIP Code and what does it represent?

A US ZIP code is a postal code used by the United States Postal Service (USPS) to identify specific geographic regions, locations, or routes within the United States. ZIP stands for "Zone Improvement Plan," and the system was introduced in 1963 to improve the efficiency of mail delivery.

A standard ZIP code is five digits long. In addition to the basic five-digit code, there is an extended version called ZIP+4, which includes four additional digits after a hyphen. The ZIP+4 code provides more precise information about a location, such as a specific block or building.

The first digit of a ZIP code generally represents a group of U.S. states, the next two digits represent a region in that group (or sometimes a large city), and the final two digits identify a specific post office or delivery area.

Data Sources

Data sources for this United States Postal Service ZIP code lookup include the U.S. Census Bureau and the U.S. Office of Housing and Urban Development. ZIP Code demographic data comes from the American Community Survey, which is an annual dataset released by the U.S. Census Bureau. Data has been updated as of February 2025 with the most recent data available.