Turn a ZIP Code List Into Cities: Free Bulk Converter Guide
A spreadsheet arrives with a column of raw postal codes and no city names, a survey export needs location labels, or a mailing list has to be segmented by region. Looking codes up one at a time is tedious, and spreadsheets have no built-in postal-code-to-city function. The free ZIP Code to City Converter resolves up to 50 codes at once across 70 countries, flags the invalid ones per row, and hands you a clean CSV ready for Excel or Google Sheets.
Pick the country, paste the codes one per line, and watch the results table fill with cities and regions in seconds. For a deep dive on a single code with coordinates and a map link, the ZIP code lookup is the companion tool, and the ZIP distance calculator measures the miles between any two codes afterward. If you have a city name instead of a code, the city to ZIP finder works in reverse.
How do you convert a list of postal codes to cities?
Pick the country, paste the codes into the box, one per line, and click Convert batch. The tool resolves each one against the free Zippopotam API and shows the city and region in a table, with invalid entries flagged in red and a CSV download for your spreadsheet. It beats one-at-a-time lookups for mailing lists and surveys.
This is the workflow Excel cannot do natively. There is no postal-code-to-city formula in any spreadsheet, which is why teams end up with helper tables, fragile VLOOKUP chains or expensive enrichment services. The batch converter replaces all of that for one-off jobs: paste, convert, download, and paste the city column back into your sheet.
The requests run in small parallel batches to stay polite to the free Zippopotam API, which is why you see a progress bar instead of a long freeze. Fifty codes resolve in seconds, and the polite pacing keeps the free service healthy for everyone. Free here does not mean abusive; it means shared.
What is the fastest way to clean a postal code list?
Run the list through the batch converter: valid codes resolve to cities while typos, transposed digits and discontinued codes get flagged in red per row. Fix the flagged entries and re-run until everything is green, then download the clean CSV. The status column lets you filter invalid codes in Excel or Sheets.
Real-world lists are never clean. Exports arrive with transposed digits, ZIP+4 extensions pasted as single entries, discontinued codes and plain typos. The converter treats cleaning as a loop: run the batch, read the red flags, fix those entries, re-run until everything is green. Because failures are reported per row with reasons, you always know which entries need attention and which are fine.
The CSV download makes the loop spreadsheet-friendly. Every row carries a status column, so you can filter to the failures in Excel or Sheets, correct them in bulk, and paste the fixed list back for a second run. Two or three passes usually take a messy export from half-broken to fully resolved.
Can you convert postal codes to cities in Excel?
Excel has no built-in postal-code-to-city function, which is why this tool exists. Convert your list here, download the CSV, and paste the city column back into your spreadsheet, or use VLOOKUP against the exported file as a reusable lookup table. For recurring workflows, save one clean download and match future exports against it first.
The downloaded CSV is designed to drop straight into a spreadsheet workflow. Its columns are country, postal code, city, state name, state abbreviation and status, which covers both display needs (city and state) and join keys (postal code) for merging back into your master sheet. Open it in Excel or Sheets, or paste the city column alongside your original codes.
For recurring work, the export doubles as a reusable lookup table keyed by postal code. Save one clean download, and next month's export can VLOOKUP against it before you touch the converter again. The new codes go through the tool; the known ones resolve instantly from your own table.
Why are some postal codes flagged as not found?
The usual causes are transposed digits, extensions pasted as one entry like ZIP+4, a format that does not match the selected country, or codes that were discontinued or never assigned. The tool reports each failure per row instead of guessing, so you know exactly which entries to fix and re-run.
Transposed digits and extensions are the top offenders: 90201 typed as 92010, or 90210-1234 pasted as one entry. Next comes format mismatch, where a code valid in one country is searched under another because the country dropdown was never changed. Discontinued and never-assigned codes round out the list, along with military APO/FPO codes and very new codes that the free database may not carry yet.
The right response depends on the cause. Format issues get fixed by editing the entry and re-running; country issues get fixed by switching the dropdown; genuinely missing codes get verified against the national postal service directly. Because the tool names the reason per row, you spend your time fixing instead of guessing.
How to use the ZIP to City Converter in 4 steps
- Paste your codes. Pick the country, then paste up to 50 postal codes into the box, one per line. Use the sample button to see the format.
- Convert the batch. Click Convert batch and watch the progress bar while the requests resolve politely.
- Review green and red rows. Found cities appear in green; invalid codes are flagged in red with the reason.
- Download the CSV. One click exports country, postal code, city, region and status columns for Excel or Sheets.
6 practical tips
- One code per line. Commas and spaces between codes break the format. Paste them vertically, one per line, for a clean batch.
- Keep one country per batch. All codes in a batch must share the selected country. Split mixed lists and run each group separately.
- Fix red rows and re-run. The flagged reasons tell you what to fix: typos, extensions, wrong country. Correct them and convert again.
- Split long lists. More than 50 codes? Divide into chunks of 50 and run multiple batches, then merge the CSVs.
- Filter by status in your sheet. The CSV's status column makes failures easy to isolate in Excel or Google Sheets for bulk correction.
- Save a reusable lookup table. Keep one clean download and VLOOKUP future exports against it before running new codes.
Frequently asked questions
Is bulk ZIP to city conversion really free?
Yes. Convert batches of up to 50 postal codes from 70 countries as often as you like with no account and no limits. Requests run in small parallel batches to stay polite to the free Zippopotam API, and real errors are reported per row.
How many postal codes can I convert at once?
Up to 50 per batch, one per line, all from the same country. For longer lists, split them and run multiple batches. The progress bar keeps you informed while the batch resolves.
What happens to invalid postal codes?
Each invalid entry is flagged in red with the reason, such as postal code not found or network error, while valid ones still resolve. Invalid rows are marked in the CSV download too, so nothing fails silently.
Can I download the results?
Yes. One click downloads a CSV with country, postal code, city, state name, state abbreviation and status columns, ready for Excel or Google Sheets. The status column lets you filter invalid rows instantly.
Where does the data come from?
The free Zippopotam API covering dozens of countries. Requests run in small parallel batches to stay polite to the free service, and real errors are reported per row instead of guessed.
Ready to try it yourself? It's free, no signup required.
Try the free ZIP to City Converter →