Free ZIP Code Database - U.S.
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
- 2010 Census Population
- Updated Monthly
FREE
Free Version
|
|
---|---|
Download Now | |
Terms of Service | |
Download Sample | |
Only the Best For You: | |
Immediate Download | |
Monthly Updates | |
Microsoft® Access (.MDB) | |
Microsoft® Excel (.XLS) | |
Comma-Delimited (.CSV) | |
SQL Data File (.SQL) | |
Free FTP Access | |
100% Money Back Guarantee | |
Free Technical Support | |
Data Fields & Columns: | |
Zip Code | |
Primary City | |
State | |
**Latitude | |
**Longitude | |
Classification Code | |
Population | |
Free
Lifetime Subscription
|
|
Download Sample FREE U.S. ZIP Code Database |
|
Download Now |
Download the Free ZIP Code Database
- You must create an account to access the monthly database.
- A valid email address is required.
- Download all file formats (Access, Excel, CSV, and SQL).
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.
Standard Database
1 YEAR SUBSCRIPTION
Download Sample Data
AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)
SQL DATA FILE (.SQL)
IMMEDIATE DOWNLOAD
Buy Now $39.95
Deluxe Database
1 YEAR SUBSCRIPTION
Download Sample Data
AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)
SQL DATA FILE (.SQL)
IMMEDIATE DOWNLOAD
Buy Now $79.95
Business Database
1 YEAR SUBSCRIPTION
Download Sample Data
AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)
SQL DATA FILE (.SQL)
IMMEDIATE DOWNLOAD
Buy Now $139.95
Database Technical Specifications
Downloads
- Free Database: [Documentation | Sample Data]
- Standard Database: [Documentation | Sample Data] (Paid Product)
- Deluxe Database: [Documentation | Sample Data] (Paid Product)
- Business Database: [Documentation | Sample Data] (Paid Product)
Field Name | Data Type | Description |
ZipCode | Char(5) | 00000-99999 Five digit numeric ZIP Code of the area. |
State | Char(2) | 2 letter state name abbreviation. |
City | VarChar(35) | Name of the city as designated by the USPS. |
Latitude | Decimal(12, 4) | Geographic coordinate as a point measured in degrees north or south of the equator. |
Longitude | Decimal(12, 4) | Geographic coordinate as a point measured in degrees east or west of the Greenwich Meridian. |
Classification Code | Char(1) | The classification type of this ZIP Code. |
Population | Integer | The population of the ZIP Code based on 2010 Census data. |
ZIP Code Database FAQs
- What format does the database come in?
- How do I get the monthly database updates?
- Will a CD be mailed to me? How do I get the database?
- Do you include ZIP Codes for the entire United States?
- Why do some ZIP codes only have 3 or 4 digits in Excel?
- How often do you update the database?
- How current is the data?
- What are the sources of the data?
- How accurate is the data?
- Do you have any other countries besides the U.S.?
- How long does it take to get the data?
- Can I automate the database delivery?
- Do ZIP Codes change often?
- Do you support Military APO/FPO/DPO ZIP Codes?
- Do you have DMA information?
- How long have you been in business?
- What separates you from your competitors?
- 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 November, 2024
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:
- AE (Armed Forces Europe / Canada / Middle East / Africa) - 09XXX
- AP (Armed Forces Pacific) - 962XX through 966XX
- AA (Armed Forces Americas [excluding domestic and Canada]) - 340XX
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 2005-2019
MySQL
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
- PHP
- VB.Net
- C#
- Visual Basic (VB6)
- Coldfusion
- Perl
- MS SQL Server [User defined scalar function]
Helpful Abbreviations
The U.S. Postal system uses many abbreviations.
Why Choose Us?
- We are a licensed distributor of the U.S. Postal Service ZIP code data
- 30 day 100% Money Back Guarantee
- We offer more data fields than our competitors at a lower price
- Tools & Resources to help you achieve your goals more efficiently
- 12 months of updates, updated every month
- Immediate download upon purchase.
- Multiple data formats and FREE radius finder application
- Free FTP Access for all of our customers
- We are a U.S. company
- Our customer support is the best on the web - call us and then try calling our competitors
Need Us?
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
These are actual emails from some of our customers:
5/19/2020
This sounds great! We will take a look at the pricing and get back if we have any questions.
Thanks once again for your prompt help today.
Regards,
Ankush Xxxxx
2/20/2020
Ms. Newsam -
Thank you so much – this is pretty close to what I expected and EXACTLY what I need for both my internal customer and my Tech partner. I apologize for asking you to lap the same block several times.
Please let me know if ever I can return the favor –
Bob Sxxxx
Enterprise Reference Data Team
Data Management & Insights
Wells Fargo Company
1/28/2020
Hi Jennifer,
Thank you for checking on this for me! You’ve been SO helpful each and every time (year) we’ve had issues.
Honestly, I’m not sure what the next step is with this. I’ll need to chat with my team lead and Manager.
Thank you again
Steve Pxxxxx
Application Programmer Analyst
Enterprise Risk Management Technology
Wells Fargo
1/17/2020
Thanks for the quick delivery!
Justin Mxxxx
GIS Specialist II
City of Gaithersburg
11/25/2019
Jennifer,
Thanks for your quick response to this inquiry. Can you provide a W9. I forgot to ask first time around. Thanks again for your help with this.
Thanks,
Denny Mxxxx
Senior Technical Product Owner
U.S. Bank
5/14/2019
Thanks very much Jennifer for getting back to me so quickly –
Nancy
Nancy E. Bxxxx, Ph.D.
Sr. Director,
Data Acquisition & Data Analytics
Equifax Inc.
2/28/20185
Jennifer, Thanks for the link! I am about to be home and I will try it out and I will let you know. I want you to know that you were really helpful and for some reason that is so hard to come by these days when you call companies to ask about their services and for quotes. If your management were standing right next to you, I would tell them to give you a raise and make sure that they keep you happy haha. Thanks again.
Respectfully,
Zachary Wxxxx
President & (COO)
AARACO Energy Services, Inc.
9/12/2017
Thank you Jennifer! You guys have been great to work with.
Deonte Gxxxx | IT Strategic Sourcing & Procurement AnalystFarmers Insurance
1/17/2017
Thanks for the fantastic support!
Tim Cxxxx
App Dev Manager, IT
Cetera Financial Group
1/4/2017
Thank you Jennifer for doing the research and got back to me w/ all the answers so quickly…. Now that’s what I called support!!
Thx,
Alan
11/6/2015
Thanks for this. And I wanted to say thank you to the very kind representative that I spoke with on the phone today - very helpful.
Denise xxxxxxxxx
Invisible Fence
5/22/15
Hi,
Thanks, that answers my question.
Also, thanks for the very quick reply ... small things like that do make a difference when it comes to deciding to do business.
Regards,
Glenn
6/12/15
Wow Jennifer, that is truly fantastic customer service. I've been able to log in so everything seems to be working.
Thank you very much.
Hugh xxxxxxx
Mediacorp.ca
7/28/15
Hi Jennifer,
Thanks, you have been very helpful and I appreciate it.
It is now working great. It was nice talking to you.
On a scale of 10, I give you 20 for Customer Satisfaction.
Have a nice day.
Thanks,
Arman L. xxxxxxxx
9/11/15
Jim;
Thanks for your very quick response. Very surprised.
After living in Piedmont for over 41 years, I've never heard of 94620 (no post office in Piedmont, so not sure how it got a PO Box zip), or any others you list other than 94610 or 94611.
I've always used usps.com and gotten the appropriate zip code - by using the address.
Guess that's the difference.
Anyway, thanks for this new information.......
Barbara
9/25/15
Thank you so much. I appreciate your prompt help with this matter. I have been a customer of yours at almost every company I work at, and I am always pleased with your products and service.
Thanx,
Robert
12/11/15
Hi Jim,
I really appreciate you guys adding that feature. We already added it to our site and selected the best number of pages for us.
Thank you for the great customer service.
Fábio xxxxxxxx
LaQ Blocks
9/2/14
Excellent – Thank you Jennifer.
I appreciate your quick response and the consistency of your data and its delivery.
Have a great week!
Richard xxxxxxx
Senior Manager
www.urbanscience.com
5/7/14
Zip-Codes.com Team
The project we have been working on is over and as of now we do not require
ZIP updates.
Just a note to say you product and your support has been exceptional.
Thank You.
John E xxxxxxx, Ph.D.
3/26/14
Good Morning,
Thank you very much for the response.
We have successfully implemented the radius distance using the suggested method of the SQL function.
Thank you to your team for their suggestions.
Regards,
Wade xxxxxx
www.paradigmtechnologies.net
Paradigm Technologies Inc.
2/21/14
Thanks so much. I’ve been very happy with the data you provide, the support, and the affordability. I’ll definitely recommend you as the best out there, having looked at several.
Randy
www.pricinghealthcare.com
1/8/14
Jennifer,
The research you did on this alone was worth the $50. Thank you for your professionalism, expediency and impeccable customer service.
Thanks again,
Gianfranco
www.sevenfifty.com
11/15/13
Thank you Jennifer,
I appreciate your firm’s consideration. I will spend some time experimenting with DC over the next few days. I hope to have a nice set of DC maps soon. Your level of customer support is excellent. It’s already obvious that your company cares about its customers and will go the extra mile to make sure your products are useful.
Karl
www.dyngeo.com
10/25/13
Hello Jennifer,
Thank you so much for the sample information.
I will go over it for our EDDM mailers.
I appreciate your prompt reply and great service.
Have a good day,
Ursula
Insurance Brokers for Seniors, Inc.
Ruth Publications LLC
10/16/13
Hi Jim,
Thanks for the prompt and informative reply. I will note that in my
records for future reporting. I just purchased the ZIP codes database
today (still waiting on my company's accounts payable to mail in the check)
and look forward to working with the full data set.
Regards,
Daniel xxxxxxxx
Business Analyst, Medicare Product Development, Health Net, Inc.
9/20/13
Thank you very much for your quick response. We look forward to working with your data and are gratified to see that your customer service is at such a high level.
Kind regards,
Sue xxxxxxx
Experian Automotive
8/28/13
Thank you so much. This was super fast and extremely kind of you to refer me to a place that might help.
I'm very impressed with the level of service.
Can you tell me what products you offer and how that may help me as a rental agency?
Thank you.
Shaya Sxxxx
MZS Realty Corp.
7/31/13
Thanks Jennifer - I really appreciate all your help and guidance. You are an outstanding asset for your organization and their customers!
Alok
07/05/2013
Jim,I tried that after I sent the message - and I got it thanks! Great product and will be ordering more for North and Central Texas.
Thank you so much!!!
Phae
06/14/2013
Have enjoyed using your database and the radius tool. Super things. Have just spent a lot of money on a new customer dB system that includes Zip Code radius search. I do not think that it is as up-to-date and comprehensive as yours, but we have to live with it. Thanks for several years of service.
Jayme
Robert Biale Vineyards
www.robertbialevineyards.com
05/31/2013
Jim, your quick response is certainly appreciated, especially with the nature of this project.I may be logging on this weekend, and your explanation will really help me! THANK YOU!!
Sincerely,
Dave xxxxxxx, MBA, JD
Sr. Business Analyst
University of Phoenix
3090 Bristol Street, Costa Mesa, CA 92626
Portions of data provided by and © United States Postal Service 2024. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.