Download a free list of ZIP codes in Excel/CSV/spreadsheet format including state, city, county, area code, latitude, longitude, and more.
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 ...
The main Excel sheet contains 12 columns with example in parenthesis.The Zip codes are in ZIP+4 format:: AREA NAME(WESTPAC ) AREA CODE(4E) DISTRICT NAME(AZ-NM) DISTRICT NO(852) DELIVERY ZIPCODE(85001) LOCALE NAME(DOWNTOWN PHOENIX ) PHYSICAL DELV ADDR(522 N CENTRAL AVE LBBY ) PHYSICAL CITY(PHOENIX) PHYSICAL STATE(AZ) PHYSICAL ZIP(85004) PHYSICAL ...
ZIP Code Software v3. Look up any US ZIP code easily; Wildcard search on all filter criteria; Find all ZIP codes within a radius; Calculate the distance between two ZIP codes; Export your data (.csv, .xml, .xls) Easy to use interface; Includes the latest US 5-Digit ZIP code database - Gold Edition; Instant Download (2.4 MB)
The most cost-effective and comprehensive database of all 41,850 US zip codes – with linked cities, counties, states, coordinates, populations and more.It is ideal for location lookups, website localization, marketing and data verification. Download a free sample
Zip-Codes-to-City-County-State-2020 (xlsx) – Updated April 2020. Zip Codes to City State 2019 Leading Zeros (xlsx) – Updated December 2019. Zip Codes to City State (xlsx) – Updated January 2019. Zip Codes to City State with Acceptable Cities (xlsx) – Updated January 2019. BETA Download. City-State-to-ZipCode-2020 (xlsx) – Updated May 2020
The complete list and database of 5-digit US zip codes is available for download in CSV, SQL, XML, YAML, HTML, PDF, and MS Excel formats. Number of Zip Codes: 41,705. List Updated On: December 2022. Source: US Postal Service. The list is sorted by zip code or alphabetically by state then city.
Our Free ZIP Code Database is set of all U.S. ZIP code data put into row and column format for easy use and manipulation. The free version comes with 7 data fields for every ZIP code in the United States. It has all the basic information you need to validate ZIP Code entry and basic mapping. The Free ZIP Code database is for personal use only ...
Explore comprehensive ZIP code demographic data in a spreadsheet. This dataset provides a list of all U.S. ZIP codes with their state, town, county, and metro area. It also has population by ZIP code and detailed U.S. Census data by ZIP code for age, gender, and race. Explore for free in Row Zero, a next-gen spreadsheet built for big data.
Free Zip Code list and database download in formats - csv, xls, sql, mdb. Updated in April 2025.
Note that not all ZIP codes, cities, or counties will be included in this data file. Only the ZIPs that are studied by the Census Bureau that are geographically based (approximately 33,000) are included. Greater than 99% of counties and 99% of cities overlap with a ZIP code and are included.
The complete list and database of 5-digit US zip codes is available for download in MS Excel spreadsheet format. See other formats. Number of Zip Codes: 41,705. List Updated On: December 2022. Source: US Postal Service. The list is sorted by zip code or alphabetically by state then city.
For spreadsheets, enter the list of zip codes in column A. For csv text files, use one zip code per line. Zip Codes can be in either 5 digit or Zip+4 9 digit format. You can use our CDXZipStream or CDXGeoData products to generate lists of zip codes for a particular state/county/city combination or in a radius. Up to 20,000 zip codes can be ...
Download a list of ZIP codes in Excel/CSV/spreadsheet format including state, city, county, area code, latitude, longitude, and more. Share: ... All 42,735 ZIP codes are included in every edition (Free, Small Business, or Enterprise) of the ZIP code database.
The complete list and database of 5-digit US zip codes is available for download in MS Excel spreadsheet format. See other formats. Number of Zip Codes: 41,689. List Updated On: May 2021. Source: US Postal Service. The list is sorted by zip code or alphabetically by state then city.
All ZIP Codes: zip: ZIP Code: Overlapping City Info Learn more; state_name: State name (ex. Mississippi) state_abbr: State abbreviation (ex. MS) state_fips: FIPS identifier for the state (ex. 28) state_ansi: ANSI identifier for the state (ex. 01779790) place_geoid: Concatenated FIPS codes (ex. 2876720 or 2899999) place_name: Name of the city
The complete list and database of 5-digit US zip codes is available for download in CSV format. See other formats. Number of Zip Codes: 41,705. List Updated On: December 2022. Source: US Postal Service. The list is sorted by zip code or alphabetically by state then city.
The complete list and database of 5-digit US zip codes is available for download in SQL, CSV, YAML, XML, MS Excel, HTML, and PDF formats; sorted by zip code, or alphabetically by state then city. The complete list of 5-digit US zip codes is available for download in PDF format.
![Video thumbnail for Look up City, County, and State from ZIP Codes in Excel with XLOOKUP! 💻 [TEMPLATE]](https://images.mavii.com/th?id=OVP.11Otub1WEin1uWVQTdce0gHgFo&pid=Api&w=215&p=0)
![Video thumbnail for How to Analyze ZIP Codes in Excel with VLOOKUP 💻 [Lesson: 4 of 11]](https://images.mavii.com/th?id=OVP.32WgWS5iOsp7nAowfn7fsQEsDh&pid=Api&w=215&p=0)
