Image

Free ZIP Code Database

What is a Free ZIP Code Database?

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 and may not be used commercially or redistributed in any manner.

  • Use our ZIP Code data on your website for easy lookups and data filling
  • Multiple data formats - Excel, Access, CSV, and SQL for easy use
  • Immediately download the data
  • 2020 Census Population
  • Updated Monthly
$FREE
Free Version
Download Now
Download Sample
Terms of Service

All ZIP Code Databases come with:

  • Immediate Download
  • Lifetime Updates
  • Free Phone & Email Support
  • Free FTP Access
  • Free Radius Finder Application
  • Microsoft® Access (.MDB)
  • Microsoft® Excel (.XLS)
  • Comma-Delimited (.CSV)
  • SQL Data File (.SQL)
7 Data Fields
ZIP Code 1
Primary City 1
State 1
Classification Code 1
** Latitude & Longitude 2
Population 5
 
Free
Lifetime Updates
Download Sample Standard U.S. ZIP Code Database
Download Now

Receive over 100 data fields in our professional ZIP Code Database

Download the Free ZIP Code Database


Passwords must be between 8 to 16 characters. Passwords must also contain 1 upper case character, 1 lower case character, and 1 number or special character.

An email will be sent to the address entered above for valid email address confirmation before download permission are assigned.

Need More Detailed Data?


Try our professional ZIP Code Databases

  • Immediate Download after purchase
  • 1 Year Subscription with Monthly Updates
  • Multi-Year Licenses available
  • All subscriptions are not automatically renewed.
  • Visa, Mastercard, American Express, or Mail In Check/Purchase Order accepted
  • Download all file formats if needed (Access, Excel, Comma Delimited, and SQL)
  • Learn more about our Professional ZIP Code Databases.

Database Technical Specifications


Free Version

Field Name Data Type Description
ZipCodeChar(5)00000-99999 Five digit numeric ZIP Code of the area.
StateChar(2)2 letter state name abbreviation.
CityVarChar(35)Name of the city as designated by the USPS.
LatitudeDecimal(12, 4)Geographic coordinate as a point measured in degrees north or south of the equator.
LongitudeDecimal(12, 4)Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian.
ClassificationCodeChar(1)The classification type of this ZIP Code.
PopulationIntegerThe population of the ZIP Code based on 2020 Census data.

ZIP Code Database FAQs

  1. What format does the database come in?
  2. How do I get the monthly database updates?
  3. Will a CD be mailed to me? How do I get the database?
  4. Do you include ZIP Codes for the entire United States?
  5. Why do some ZIP codes only have 3 or 4 digits in Excel?
  6. How often do you update the database?
  7. How current is the data?
  8. What are the sources of the data?
  9. How accurate is the data?
  10. Do you have any other countries besides the U.S.?
  11. How long does it take to get the data?
  12. Can I automate the database delivery?
  13. Do ZIP Codes change often?
  14. Do you support Military APO/FPO/DPO ZIP Codes?
  15. Do you have DMA information?
  16. How long have you been in business?
  17. What separates you from your competitors?
  18. How can I use the Free ZIP Code Database?

Q. What format does the database come in?

A. Our US ZIP Code Database is provided in three (3) formats: Microsoft® Access [MDB], Microsoft® Excel [XLS], and ASCII Comma Delimited [CSV].

Back to Top

Q. How do I get the monthly database updates?

A. When you purchase, you setup a username and password. Each month, we will notify you via email that an updated database is available. Visit our site and login using your username and password. The updated databases will be available for download in any format we provide as well as a transactional log file with just the changes only.

Back to Top

Q. Will a CD be mailed to me? How do I get the database?

A. No, our US ZIP Code Database is not mailed to you on CD. Once your order is completed, you will be able to download immediately. All monthly updates are also provided for online download. This ensures fastest delivery as the database is updated each month.

Back to Top

 

 

Q. Do you include ZIP Codes for the entire United States?

A. Yes. ZIP Code data is provided for all 50 U.S. States, Washington DC, Puerto Rico, Virgin Islands, Guam, and APO/FPO Military ZIP Codes.

Back to Top

Q. Why do some ZIP codes only have 3 or 4 digits in Excel?

A. Several ZIP Codes start 0 or 00. Excel interprets the column as numeric data, therefore it removes all preceding zeros. The data is good, it is simply Excel formatting the output. To correct this, open the spreadsheet. Highlight the column by clicking on "A" above the ZIP Code Label. From the menu at the top of the application, choose "Format" and then "Cells". On the popup window, choose "Special" from the "Number Tab" section, and then choose "ZIP Code" to the right. Click "OK". The ZIP Codes should now be formatted properly.

Back to Top

Q. How often do you update the database?

A. Our ZIP Code Database is updated every month.

Back to Top

Q. How current is the data?

A. Our ZIP Code Database is updated every month. the data is current as of August, 2025

Back to Top

Q. What are the sources of the data?

A. Our ZIP Code Database is licensed and compiled from various sources. Postal and Delivery data comes from the USPS, Demographic data from the US Census, Statistical Areas from the OMB (Office of Management & Budget), private data sources, and some are computed by Zip-Codes.com.

Back to Top

Q. How accurate is the data?

A. Accurate data is critical to the success of your business and ours. Zip-Codes.com implements a very rigorous set of data integrity checks to ensure our database is as accurate as possible. In the unlikely event that a portion of data is confirmed as inaccurate, we will correct it within 2 business days.

Back to Top

Q. Do you have any other countries besides the U.S.?

A. Yes. We also have the Canadian Postal Code Database.

Back to Top

Q. How long does it take to get the data?

A. Instantly. As soon as your order is confirmed and payment is received, you can download the database.

Back to Top

Q. Can I automate the database delivery?

A. Yes! Please email us requesting an FTP Account be setup for you to use in automating your processes. Please include your username or order number for reference. We will have it up and running within 1 hour.

Back to Top

Q. Do ZIP Codes change often?

A. ZIP code data changes frequently. Every year there are thousands of changes to the USPS ZIP Code records. Cities are added and removed. ZIP codes are created or discontinued. Corrections are made. Boundaries change. Streets are added and street names change. Within a short time period, the database will be outdated if you do not download it every month.

Back to Top

Q. Do you sport Military APO/FPO/DPO ZIP Codes??

A. Yes! Overseas military post offices operated or supported by the Army or Air Force use the city abbreviation APO [Army Post Office / Air (Force) Post Office], while overseas military post offices operated or supported by the Navy, Marine Corps or U.S. Coast Guard use the city abbreviation FPO (Fleet Post Office). Recently, the Department of State has begun establishing a semi-independent overseas postal system. Their city abbreviation is DPO. As of March 2009, less than 10 U.S. Embassy locations are known as DPOs. The other approximately 90 overseas U.S. embassy post offices fall under the management oversight of the military services and so are known as either as APOs or FPOs. Three quasi-state codes have been assigned depending on the (approximate) geographic location of the military mail recipient and also the carrier route to be taken. They are:



Back to Top

Q. Do you have DMA information?

A. No, Nielsen is the provider of that data and they do not allow others to redistribute it. If you need it, you need to go directly to them to get it at Nielsen.com

Back to Top

Q. How long have you been in business?

A. We have been selling our databases online since 2003 and have become the most trusted source of ZIP code data.

Back to Top

Q. What separates you from your competitors?

A. What separates us from our competitors is our level of customer service. We are here every day and we answer the phones during business hours. If you have a question or problem, we are here to help you. Additionally, we provide the most comprehensive database at the most competitive price. Our competition doesn't even come close. Try calling them! Also, our rigorous data integrity checks make our data the most accurate you can purchase.

Back to Top

Q. How can I use the Free ZIP Code Database?

A. The Free ZIP Code database is for personal use only and may not be used commercially or redistributed in any manner.

Back to Top

ZIP Code Tools & Resources


Zip-Codes.com offers our customers several free applications, tools, and sample code. We hope these tools make your life a little easier with regards to manipulating our databases.

Tutorials

These tutorials will walk you through the process of performing different functions that can be achieved by using our ZIP Code Database.

Database Scripts

These scripts work on your SQL Server or MySQL Server establishing the table, columns, and column definitions before importing the data. To use them, execute the full file contents in Enterprise Manager, SQL Server Management Studio, phpMyAdmin, or other SQL Command Interface.

SQL Server 2000 & 2005

• Standard Database [ Download ]
• Deluxe Database [ Download ]
• Business Database [ Download ]

MySQL

• Standard Database [ Download ]
• Deluxe Database [ Download ]
• Business Database [ Download ]

Sample Code

The sample code provided here is meant as an example of how some functions can be performed.

Distance Functions:

Calculate the distance between two latitude/longitude coordinates.

• VBScript [ View ]
• PHP [ View ]
• VB.Net [ View ]
• C# [ View ]
• Visual Basic (VB6) [ View ]
• Coldfusion [ View ]
• Perl [ View ]
• MS SQL Server [User defined scalar function] [ View ]

Sample Radius Finder Code:

Written in VBScript, this working code sample finds ZIP Codes within a given radius of a central ZIP Code just like our free online ZIP Code Radius Finder.

• ASP/VBScript - Business Database [ Download ]
• ASP/VBScript - Deluxe Database [ Download ]
• ASP/VBScript - Standard Database [ Download ]
• PHP Versions [ Download ]

Helpful Abbreviations

The U.S. Postal system uses many abbreviations.

Why Choose Us?

It's really quite simple...
1

100% Money Back

30 day 100% Money Back Guarantee. We are a licensed distributor of the U.S. Postal Service ZIP Code data.

2

Lower Price

We offer more data fields than our competitors at a lower price.

3

Multiple Data Formats

Multiple data formats and FREE radius finder application.

Premium features with every license at no extra cost


Our 100% Money Back Guarantee!
  1. Our customer support is the best on the web - call us and then try calling our competitors
  2. We are a licensed distributor of the U.S. Postal Service ZIP Code data
  3. We are a licensed distributor of the Canada Post Postal Code data
  4. 30 day, 100% Unconditional Money Back Guarantee
  5. We offer more data fields than our competitors at a lower price
  6. Tools & Resources to help you achieve your goals more efficiently
  7. 12 months of updates, updated every month
  8. Immediate download upon purchase, no waiting
  9. Multiple data formats and FREE radius finder application
  10. Free FTP Access for all of our customers
  11. We are a U.S. Company

Need Us?


1-800-425-1169

info@zip-codes.com


Who Else Uses Our Products?


  • ADP
  • Aetna
  • Aim.com
  • Aon Corporation
  • Armstrong
  • AutoTrader.com
  • Bank of America
  • Bank of New York
  • Bayer
  • Benjamin Moore
  • Best Buy
  • Bosch
  • Brigham Young University
  • Campbell Soup
  • Capital One
  • Cendant
  • Chase
  • Chubb
  • CIGNA
  • Cingular
  • Cisco
  • CitiGroup
  • CNN
  • Coleman
  • Colorado State University
  • Columbia University
  • Con-Way
  • Cornell University
  • Dartmouth University
  • Deloitte
  • Dun & Bradstreet
  • Dupont
  • Emory University
  • Ethan Allen
  • ESPN
  • etoys.com
  • etrade.com
  • Fannie Mae
  • Farmers Insurance
  • Ford Motor
  • GE
  • Geico
  • GMAC Insurance
  • Harvard Medical School
  • Hess
  • Home Depot
  • HP
  • HSBC
  • IBM
  • IKON
  • ING Direct
  • Intuit
  • JP Morgan
  • Liberty Mutual
  • Macromedia
  • Mastercard
  • Mavis Tire
  • McAfee
  • Merrill Lynch
  • Met Life
  • Microsoft
  • MIT
  • Morgan Stanley
  • Morton Salt
  • Neiman Marcus
  • Nestle
  • NJ Motor Vehicles
  • Nortel
  • Nutrisystem
  • Ohio State University
  • Pampered Chef
  • Paychex
  • Pepperdine University
  • Pfizer
  • Princess Cruises
  • Remax
  • Reunion.com
  • Ryder
  • Sears
  • Social Security Administration
  • Sothebys
  • Sprint
  • Stanford University
  • Staples
  • Stork.com
  • Sun Microsystems
  • SUNY University
  • Terminix
  • The Homestore
  • Thomson
  • TIAA-CREF
  • U.S. Army
  • U.S. Department of Energy
  • U.S. Marines
  • U.S. Navy
  • UC Berkeley
  • UMass Boston
  • Unisys
  • UPS
  • U.S. Postal Service
  • Vonage
  • Walmart
  • Washington Mutual
  • Wells Fargo
  • Whitepages.com
  • Yellowbook.com
  • YES Network
  • Yum! Brands
Actual Customer Emails

Our Customers say it best!

Portions of data are provided by the United States Postal Service and are © 2025. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.