Free tool
ZIP Code Validator
Excel strips leading zeros from ZIP codes — so '02100' becomes '2100'. This tool pads them back to 5 digits, validates the format, and tells you which region of the US each prefix maps to.
One per line, or comma-separated. Leading zeros that Excel stripped will be padded back automatically.
Matching by ZIP with radius search?
The full product does ZIP radius matching — find customers within 10 miles of a store location, for example — using a full postal-geo database. And it fixes leading zeros automatically during file preparation, not as a separate step.
Try the full product freeLet the Genie handle the grunt work.
Free tier is real. No card. No forms. Just upload your first list and see the Genie clean and match it in under a minute.

