USPS licensed · Updated monthly · 23 years

Free ZIP Code Database

Every U.S. ZIP Code with its city, state, latitude, longitude, type and 2020 Census population. CSV, Excel, Access and SQL.

42,000+ZIP codes
7data fields
Sep 1last update
4file formats
Download the free database
Free account and one email confirmation. No credit card, no expiry.
Need more than 7 fields?

Professional databases

Demographics, counties, time zones and ZIP+4 precision — plus a commercial-use license.

31–94+ fields · from $49.95/year
Compare editions →
Building software?

ZIP Code API — free tier

Query live instead of downloading. Nothing to host, nothing to schedule.

2,500 credits/day · no credit card
Try it live — no API key needed → or create a free account

What you get free — and where it stops

The FREE edition covers the basics for personal use. This is exactly where its limits are, so you can tell at a glance whether you need a paid edition.

Feature FREEpersonal use only Standard$49.95/yr Business$189.95/yr APIfree tier
The basics
All 42,000+ U.S. ZIP codes
ZIP code, city, state, latitude and longitude
Classification code (Standard, PO Box, Unique, Military)
Free phone and email support
How you get itCSV, Excel, Access, SQLCSV, Excel, Access, SQLCSV, Excel, Access, SQLREST / JSON
How it refreshesMonthlyMonthlyMonthlyLive at every call
Runs locally — no rate limits, no per-call costmetered by credits
2020 Census population
Total data fields73194+150+542 with enrichments
Standard adds
Commercial-use licenseFree ends here
Full postal geography — county & FIPS, time zone & DST, area code, elevation, city aliases, carrier route
Higher coordinate precision (FREE is 4-decimal)6-decimal6-decimalZIP+4 centroid
Automated FTP deliveryn/a — always live
Redistribution licenseAdd-onAdd-onNot permitted
Business adds
Demographics — households, median income, median home value, median age, race & ethnicityStandard ends here
ACS demographics, 4 profiles
Statistical areas — MSA, PMSA, CSA, CBSA, region & division
Business data — establishment counts, employment, payroll, delivery & mailbox counts
Only in the API
Boundary-level spatial analysis — which county, place, CBSA, census tract, block group and congressional district a point actually falls insideBusiness ends here
Radius search — every ZIP within a given distance
Distance calculation — between any two ZIP codes or coordinates
Type-ahead autocomplete — for address and ZIP entry forms
Address validation & ZIP+4 append
Canadian postal codes§ included
$0 Download free $49.95/yr See Standard $189.95/yr See Business Free tier Try the API

The API column shows the free tier — 2,500 credits a day, 60 requests a minute, one API key, radius searches to 100 miles, and up to 15 autocomplete suggestions. Paid plans from $49/month lift every one of those: up to 1.5 million credits a month, 600 requests a minute, 25 keys, a 500-mile centroid and 250-mile spatial radius, up to 500 suggestions, and the batch endpoints that process thousands of lookups or addresses in a single request — with priority or dedicated support on the higher plans. Address validation, every enrichment and Canadian coverage are on every plan, including the free one. Compare API plans →
FTP automation allows each monthly refresh to be pulled from our server without a manual download.
The FREE edition carries 2020 Census population. The Standard edition is a pure postal-geography product and does not include population figures — Business does.
§ Canadian postal codes are available for the databases as a separate product; the API includes them at no extra cost.

Also available: the Deluxe edition ($89.95/yr, 60 fields) sits between Standard and Business.  ·  Download a sample file  ·  Full field specifications for every edition

This is the USPS list, not Census ZCTAs

Other free ZIP Code files on the internet usually come from the the U.S. Census Bureau’s ZCTA set, and it is not the same thing. A ZCTA is a statistical geography built by aggregating populated Census blocks; a ZIP Code is a set of delivery routes. They are close enough to be mistaken for each other and different enough to break a join. 7,758 of the 41,540 ZIP Codes in use today — 18.7% — have no 2020 ZCTA at all. If you're using the ZCTA's, then you are missing valid ZIP Codes.

ZIP Code type In our free file Missing from 2020 ZCTA
Standard29,808299 (1.00%)
PO Box9,1215,183 (56.8%)
Unique2,0231,688 (83.4%)
Military588588 (100.0%)
All ZIP Codes 41,540 7,758 (18.7%)
Counted against our August 2026 data release and the Census 2020 ZCTA file, at page load.

It is a 2020 snapshot

ZCTAs are redrawn once a decade. The current set is the 2020 vintage and the next is the 2030 Census. The USPS has introduced 78 ZIP Codes since it was drawn that it cannot contain. Our file refreshes monthly.

No delivery area, no ZCTA

A ZCTA is aggregated from populated Census blocks, so a ZIP Code with deliveries but no residential area never becomes one. That is most PO Box and Unique ZIP Codes, and every military ZIP Code — all still real, all still in your address data.

Where it bites

A missing ZIP Code does not throw an error. It silently fails to match, and a customer record quietly drops out of a report — which is why the gap tends to be discovered late.

The most recently created ZIP Codes the Census set is missing — newest first, of the 299 Standard ZIP Codes with no 2020 ZCTA across 48 states. Not PO Boxes, not military: ordinary Standard-classification ZIP Codes that will turn up in an address file and match nothing. Look one up and check us.

  • 77352 Livingston, TX Jun 2026
  • 84048 Lehi, UT Jun 2025
  • 85144 San Tan Valley, AZ Jun 2023
  • 85288 Tempe, AZ Jun 2021
  • 55131 Saint Paul, MN Nov 2018
  • 90134 Los Angeles, CA Aug 2018
  • 72643 Lead Hill, MO Jun 2018
  • 97129 Hillsboro, OR Oct 2016
  • 97252 Portland, OR May 2016
  • 33191 Miami, FL Jul 2015
  • 33198 Miami, FL Jul 2015
  • 40122 Fort Knox, KY Jun 2010
  • 17611 Lancaster, PA Jan 2006
  • 89165 Las Vegas, NV Jul 2005

All 299 are in the free ZIP Code database below, and this list is rebuilt from the current release every time the page loads.

To be fair to the Census: this is not an error in their data. A ZIP Code Tabulation Area is doing a different job. ZCTAs exist so demographic counts can be reported against something roughly ZIP-shaped, and for that it is the right tool. It was never meant to be a list of ZIP Codes. The problem is that because it is free, it gets used as a list of valid ZIP Codes when it really is not.

Explore a Live Sample with our Data Explorer

Real rows from the live database. Switch editions to see what you get at each tier, or filter down to your own state and county.

Version: | Pro:

Loading ZIP Code Database Sample

Connecting to our live database for real, current data from our U.S. ZIP Code Database.

What You'll See:

  • Real database fields from every edition shown
  • Geographic coordinates (latitude/longitude)
  • City, state, and county information
  • Population and demographic data (professional editions)
  • Statistical classifications and area codes

Interactive Features:

  • Filter by state to see regional data
  • Drill down by county for precise locations
  • Compare the editions (FREE, Standard, Business)
  • Sort and explore all available fields
  • See exactly what you're getting before downloading
Pro Tip: Use the filters above to explore data for your specific state, county, and edition. Switch between FREE and Professional editions to compare field availability.

Get Instant Access to the FREE Database

Create your free account and download immediately. No credit card required.

Been here before? Log in to get the current file →

1Confirmation email, usually within a minute
2Click the link to confirm your address
3Download unlocks — CSV, Excel, Access, SQL
4Return any time. Your account never expires
SSL encrypted No credit card Instant download

Which license do you actually need?

Thirty seconds now can save a compliance problem later. The free edition is generous, but it is licensed for personal use only.

Free is the right fit

Personal, learning, or a side project

  • A personal or school project
  • Learning, testing, or prototyping
  • Internal analysis that never leaves your own machine

You are covered indefinitely. Nothing to buy, no expiry.

You need a commercial license

For your company or a client

  • Anything shipped to customers or embedded in a product
  • Company operations — shipping, territories, marketing lists
  • Work delivered to a client

Commercial work also tends to need what free leaves out: county, time zone, area code, demographics, and 6-decimal coordinates. Free coordinates are 4-decimal — fine for a dot on a map, too coarse for ZIP+4 work.

View Professional Editions — from $49.95/year →

Not sure? The simplest test: is the data leaving your own laptop or personal account? If yes, you need a paid edition. If no, free is fine.

Frequently Asked Questions

Quick answers to common questions about the FREE ZIP Code Database. Have technical questions? See the full Technical FAQ.

No, the FREE edition is for personal use only.

Personal use includes:

  • Educational projects and research
  • Personal mapping and distance calculations
  • Learning and experimentation
  • Hobby projects and personal tools

You need a Professional edition if:

  • Using the data in a business application or website
  • Incorporating it into commercial software or services
  • Using it for business operations (logistics, marketing, sales)
  • Providing services to clients or customers using the data

Professional editions start at just $49.95/year and include commercial usage rights, plus 24-87 additional data fields like demographics, county information, time zones, and statistical areas.

Compare the editions to find the right fit for your commercial needs.

The FREE edition includes 7 essential data fields for all 42,000+ U.S. ZIP codes:

Field Name Description
ZIP Code 5-digit ZIP code
State 2-letter state abbreviation
City Primary city name
Latitude Geographic coordinate (4-decimal precision)
Longitude Geographic coordinate (4-decimal precision)
Classification Code ZIP type (Standard, PO Box, Unique, Military)
Population 2020 Census population (ZCTA)

Perfect for: Address validation, basic mapping, personal projects, educational use, form validation, and distance calculations.

Want more? Explore the Data Explorer to compare FREE with Professional editions and see all available fields.

The Free download bundles four ready-to-import flavors of the same 7-column dataset, so you can match whatever tool you already have on the desktop without a conversion step:

  • CSV: Plain text, opens in everything from Excel to pandas to PowerBI; the recommended choice for any custom pipeline.
  • XLS (legacy Excel workbook): Pre-loaded, freezes the header row, drops straight into a pivot table.
  • MDB (Microsoft Access): Land it in Access for ad-hoc SQL without spinning up a server.
  • SQL: A pair of MySQL-flavored and SQL Server-flavored scripts — execute, get the table created and populated in one pass.

Since the field set is fixed at 7 columns (ZIP, city, state, lat, lon, classification, population), every flavor parses identically; pick by familiarity rather than capability. Need richer fields? The paid editions ship the same four formats with 31 to 94 columns.

Monthly updates, published on the 1st of each month. We synchronize with official USPS updates to ensure you have the most current data.

What changes each month:

  • New ZIP codes added by the USPS
  • Discontinued ZIP codes removed
  • City name corrections or changes
  • Coordinate refinements
  • Population updates (when new Census data is released)

How to stay updated:

  • Email notifications: We send monthly announcements when updates are available
  • Manual download: Log into your account anytime to download the latest version
  • Automated FTP: Available on the paid editions — each monthly refresh is pulled to your server with no manual download

Good news: ZIP codes are relatively stable. Most months see only 10-50 changes across the entire U.S., so updates are optional - download new versions only when it makes sense for your use case.

No credit card required. We only need your name, email address, and password to create your account.

Why we ask for an email:

  • To send you the email confirmation link (activates your account)
  • To notify you about monthly database updates
  • To provide important announcements (rare)

We respect your privacy and will never sell your information. You can unsubscribe from update notifications anytime, though your download access remains active forever.

The FREE edition includes 7 core fields. Professional editions add 24-87+ additional fields depending on the tier:

  • FREE (7 fields): ZIP code, city, state, coordinates, classification, population. Perfect for personal use.
  • Standard (31 fields): Adds county, area codes, time zone, DST, FIPS codes, and more. Starting at $49.95/year.
  • Deluxe (60 fields): Adds Census 2020 demographics (income, households, age), statistical areas (MSA, CBSA), and mailing indicators. $89.95/year.
  • Business (94+ fields): Complete Census 2020 data, annual ACS updates, 5 supplemental files, multi-county logic. $189.95/year.

Key differences:

  • FREE: Personal use only | Professional: Commercial use allowed
  • FREE: 4-decimal coordinate precision (~36 feet) | Professional: 6-decimal precision (~4 inches)
  • FREE: Basic fields | Professional: Demographics, statistical areas, enhanced classifications

See the full comparison or explore the Data Explorer to see the actual fields side-by-side.

Yes, completely free. No credit card required, no trial period, no hidden fees.

What you get at no cost:

  • All 42,000+ U.S. ZIP codes with 7 essential data fields
  • Lifetime access to monthly updates (forever)
  • All file formats (CSV, Excel, Access, SQL)
  • Free phone and email support

The only restriction: The FREE edition is for personal use only. Commercial applications require a Professional Edition (starting at $49.95/year).

The download process is quick and simple:

  1. Create your free account: Fill out the registration form with your name, email, and password. No credit card required.
  2. Check your email: We'll send a confirmation email to verify your address (check spam folder if you don't see it).
  3. Click the confirmation link: This activates your account instantly.
  4. Log in and download: Access your account homepage where you can download all file formats (CSV, Excel, Access, SQL).

Total time: Usually less than 2 minutes from registration to download.

Having trouble? Contact our support team at 1-800-425-1169 or info@zip-codes.com - we're happy to help!

Absolutely! You can upgrade anytime when your needs change.

Common upgrade scenarios:

  • Started with FREE for a personal project, now need it for your business
  • Need demographic data for market analysis
  • Require higher coordinate precision for mapping applications
  • Need county information or statistical area codes

Upgrade process:

  1. Choose your Professional edition (Standard, Deluxe, or Business)
  2. Complete the purchase through our secure checkout
  3. Immediately download the upgraded database with all additional fields

Your FREE edition account remains active, so you can always access both versions if needed.

View Professional Edition Options →

The 7-column Free snapshot covers the bulk of small-scale, personal-project workloads — anything where you need 5-digit-ZIP-to-city/state lookup, rough centroid mapping, or basic distance math but don't need demographics, ZIP+4, time zones, or Census geography.

Common Free-edition workflows we hear about:

  • Personal projects asking "is this ZIP valid?"
  • Class projects building a US map with population shading
  • Personal-finance tools comparing cost-of-living across ZIPs at a coarse level
  • Homebrew store-locator scripts run on a laptop, not a production server
  • One-off academic research where ZIP-level granularity is enough
  • Validating mailing lists for a personal newsletter

What pushes you out of Free territory: anything that ships the data to other people (commercial license required), anything needing county / time zone / area code, demographic enrichment, or sub-36-foot coordinate precision. The Free coordinates are 4-decimal — fine for plotting a dot on a map, too coarse for ZIP+4 / DPV-style work.

If the use case is fuzzy, the safest check is the license question: is the data leaving your laptop / personal account? If yes, you need a paid edition. If no, Free is fine indefinitely.

Forever. Your FREE account never expires.

What this means:

  • Unlimited access to download the current month's database
  • Monthly updates available indefinitely (no 12-month limit like paid editions)
  • No automatic renewals or subscription fees
  • Download as often as you want, whenever you need

Your data never expires either: Any version you download remains fully functional forever. Use it for years without needing updates if your use case doesn't require current data.

Professional editions work differently: They include 12 months of updates, after which you can renew annually if you want to continue receiving updates. Compare editions to see all differences.

Yes! FREE users get the same support as paid customers.

Available support channels:

  • Phone Support: Call us at 1-800-425-1169 during business hours (Monday-Friday, 9 AM - 5 PM ET)
  • Email Support: Email info@zip-codes.com anytime - we typically respond within 24 hours
  • Technical Documentation: Access our comprehensive Technical FAQ and field specifications

What we help with:

  • Account access and download issues
  • File format questions and import guidance
  • Data field explanations and technical specifications
  • Helping you determine if FREE meets your needs or if you should upgrade

We're committed to providing excellent support regardless of whether you're using the FREE edition or a paid product. Don't hesitate to reach out!

The Free bundle is set up so most folks won't need any setup work at all:

  • For a quick one-off: open the .XLS in Excel or the .MDB in Access. Both files already have the rows in place, no import dialog.
  • For a script: feed the CSV to whatever's at hand — Python's csv module, pandas.read_csv, Node's csv-parse, Ruby's CSV.read, PHP's fgetcsv — they all read identical schemas.
  • For a database: run the bundled MySQL or SQL Server .sql file with the CLI tool of your choice (mysql --execute, sqlcmd -i, etc.). The script creates the table, types each column, and inserts every row in one transaction; you can drop and re-run it whenever a new monthly snapshot is published.

We don't ship a Postgres-flavored script, but the CSV plus a one-liner gets you there: COPY zip_codes FROM 'file.csv' DELIMITER ',' CSV HEADER;

Need help fitting the import into a specific stack? Support is free for Free-edition users too — drop an email to info@zip-codes.com.

All Free-edition coordinates are encoded in EPSG:4326 (WGS84 lon-lat) — the same CRS used by GPS, every common web-map tile, Google/Apple/Bing maps APIs, and OpenStreetMap. No reprojection needed for the standard plotting workflows.

Two things to know that are specific to the Free edition:

  • Precision is intentionally capped at 4 decimal places — about ±36 feet (±11 meters). Good enough to plot a marker on a map at zoom levels under 16; not good enough to align with a building rooftop or to power ZIP+4-level workflows.
  • The lat/lon represents the centroid of the ZIP's delivery area for a Standard ZIP. PO-Box-only ZIPs are pinned at the local post office; Unique ZIPs (single high-volume recipient like a corporate mailroom or government building) are pinned at the registered address. Military ZIPs (AE/AP/AA prefixes) sometimes lack coordinates because the destination is operational, not geographic.

Need higher precision (6-decimal, ~4-inch / ~10-cm) or full polygon coverage? Step up to a Professional edition for 6-decimal lat/lon, or layer in the ZIP Code Boundary Data product for actual shape files.

Yes — every row in the Free file ships with a centroid lat/lon, which is everything you need for as-the-crow-flies distance math. Three implementation paths people typically take:

  • Spreadsheet: drop a Haversine formula into Excel and you have a distance column between any two ZIP centroids in seconds. There's no installation, no library, no setup — just SIN/COS arithmetic over the two lat/lon pairs.
  • Script: every modern language has a one-import distance helper. Python has geopy.distance.geodesic; JavaScript has @turf/distance or geolib.getDistance; PHP has any geodist package on Packagist; Ruby has geocoder; Java has the Apache SIS or JTS great-circle helpers. All of them take (lat1, lon1, lat2, lon2) and return meters or miles.
  • Database: if the data lives in MySQL 8+, ST_Distance_Sphere(POINT(lon, lat), POINT(lon, lat)) returns meters directly. Postgres + PostGIS gives ST_Distance with a GEOGRAPHY cast. SQL Server's geography::STDistance does the same. Index a GEOGRAPHY column and a 50-mile radius query across all 42,000 ZIPs returns sub-second.

Two limits worth flagging up-front. (1) These are straight-line distances, not driving distances — for ETA / route work, layer a routing engine (OSRM, Valhalla, GraphHopper, Google Directions, Mapbox Directions) on top. (2) The Free edition's 4-decimal lat/lon means the result is precise to ~36 ft per endpoint; for personal-project mapping that's invisible noise, for ZIP+4-style precision you'll want a Professional edition's 6-decimal coordinates.

Paid customers also get our standalone Radius Finder app (offline desktop tool) and the online radius search inside their account.

Decades of Trust: We're the ZIP Code Data Experts

Our Experts

Eddie Harris

Lead Data Architect - 23 Years Experience

Even a free download deserves accurate data. The 7-field Free ZIP Code Database snapshot is pulled from the same verified USPS source that feeds our paid editions — same monthly USPS reconciliation, same human review on the source records, just a smaller field set and a one-time snapshot instead of ongoing updates.

Eddie and the team treat the free release the same way they treat the paid ones: validate, sanity-check, ship. We'd rather you get accurate basics today than a broken full extract tomorrow.

More About Our Team →

We Stand Behind Our Work

Our 100% Money Back Guarantee!

Why give away free ZIP code data at all? Because if the basics work for your project today, we've earned the conversation later. If your needs outgrow the free snapshot — more fields, monthly updates, demographics, multi-county handling, redistribution rights — you already know our data is accurate.

The free download is a snapshot, not a subscription. One free account, one email confirmation, and the current file is yours — no credit card, no expiring license, and no obligation to ever buy anything. If you ever need monthly USPS reconciliation, ZIP+4 street-level precision, or any of the 94+ fields in our paid editions, the upgrade path is one click away.

Questions about the schema or fit? Real humans answer the phone and read the inbox. Whether you're an indie developer prototyping a lookup tool or a Fortune 500 evaluating before a procurement decision, you get the same direct line.

Learn Why Many Place Their Trust In Us →

Trusted by Thousands of Companies

Background image for Real Reviews from Real Customers

Real Reviews from Real Customers

★★★★★ 4.8out of 5

from 76+ verified reviews on our Google Business profile

Sources & References


Our sources include trusted federal and licensed data from the United States Postal Service, U.S. Census Bureau, U.S. Geological Survey, and Centers for Medicare & Medicaid Services, along with proprietary datasets created by ZIP-Codes.com. Data last updated on September 9, 2026.

  1. U.S. Postal Service [Last Updated: 9/1/2026], https://www.usps.com
  2. ZIP-Codes.com Proprietary Data Enhancements [Updated: 9/1/2026], https://www.zip-codes.com
  3. U.S. Census [Updated: Varies], https://www.census.gov
    • U.S. Census Office of Management and Budget [Updated: As Released]
    • U.S. Census 2020 Demographic & Housing Characteristics (DHC) [Decennial] [Updated: 5/25/2023]
    • U.S. Census 2011-2023 American Community Survey 5-year estimates (ACS) [Annually] [Updated: Annually, As Released]
    • U.S. Census Business Patterns (CBD) [Annually] [Updated: Annually, As Released]
    • U.S. Census American National Standards Institute (ANSI) [Updated: As Released]
  4. U.S. Geological Survey [Updated: Varies], https://www.usgs.gov
  5. Centers for Medicare & Medicaid Services [Updated: Annually, As Released], https://www.cms.gov
Portions of data are provided by the United States Postal Service and are © 2026. Zip-Codes.com is a non-exclusive licensee of the United States Postal Service.