It just drives me nuts that the web is full of zipcode database downloads that are not free! It is not like the resellers did anything special to compile this information. The USPS publishes it for a fee, and then they charge you a fee for publicly available information.
That’s just not acceptable. So, I’ve written some scripts to gather all known zip codes (from 00000 – 99999) and placed them below in several common formats. Enjoy, and let information like this be free!
There are 41,815 geocoded zipcodes in all. Note presently the US has 41,950, but that includes APO zips, which are not included here.
Downloads
- Excel Formatted Zips [1.98MB]
- CSV Formatted Downloads [757KB]
- MySql Database Format [769KB]
Each zipcode is provided with it’s state, city, latitude, and longitude.
GitHub
Or run the scripts yourself from Github.