Postal Code Finder
๐Ÿ“ My ZIP
๐Ÿ“Š Tool #6 ยท Batch CSV / Excel Enricher + Leading-Zero Recovery

Bulk Postal & ZIP Code Lookup and CSV Enricher

Paste up to 100 ZIP or postal codes (or upload a CSV). Our engine restores stripped Excel leading zeros (such as 2108 to 02108), enriches city, state/region, WGS84 latitude/longitude, plots every centroid on the map, and exports UTF-8 BOM CSV.

Submitted Rows
โ€”
Verified Matches
โ€”
Zeros Restored
โ€”
Input Normalized Country City / Place Region / State WGS84 Lat, Lng Status
Loading batch sample...

Verified Batch Centroids Map (WGS84)

Need Excel XLOOKUP or Power Query formulas to keep leading zeros permanently? Open Excel Leading-Zero Guide โ†’
Enriching >100 rows or full country datasets? Unlock Country Pro (โ‚ฌ19) or Global Pro.
Download complete national UTF-8 CSV, Excel XLSX & GeoJSON files for 249 countries with instant API key.
Explore Country Pro & Full Datasets โ†’

Frequently Asked Questions: Bulk Postal Code Lookup

Does this bulk ZIP lookup restore leading zeros stripped by Excel?

Yes. Enable auto-restore to pad 3- or 4-digit US, ES, FR, DE, and IT codes (such as Boston 2108 to 02108 or Barcelona 8001 to 08001) before matching official coordinates.

How many rows can I enrich at once via CSV or JSON API?

The interactive tool and GET/POST /api/v1/bulk-lookup endpoint enrich up to 100 postal codes per request for free, exporting a clean UTF-8 BOM CSV file.