ZIP Validator & State Stats

Normalize ZIPs, see state stats, offline support, drag-and-drop CSV/TXT files.

Theme:

📁 Drag & Drop CSV/TXT files here or click to select

Total Entries

Unique ZIPs

Normalized Count

Invalid Tokens

Unique States

State ⬍	Unique ZIPs ⬍	Sample ZIPs
No data yet

Top 10 States by ZIP Count

ZIP Validator & State Stats PRO

ZIP+4 · Territory support · Duplicate tracking · Suspicious ZIP detection · Excel import/export · State heatmap

Theme:

📁 Drag & Drop CSV / TXT / XLSX here or click to select

Total Input

Unique ZIPs

Duplicates Removed

Auto-Padded

Invalid Tokens

Unique States/Terr.

ZIP+4 Detected

⚠ Flagged ZIPs

State / Territory Breakdown

State ⬍	Unique ZIPs ⬍	Total Occurrences ⬍	% of Total	Sample ZIPs
No data yet

Top 10 States by ZIP Count

State Heatmap (hover for detail)

Max Hover cells for detail

🗄️ ZIP → SQL Converter

Convert validated ZIPs into Vicidial/SQL IN() filter statements. Unlimited entries, client-side only.

Paste ZIPs (or drop .txt/.csv files). ZIPs can be sent here automatically from the validator tabs.

No files loaded

Filter type

Max items per IN()

Set large to include all in one statement

Keep ZIP+4 (if present) Quote values

Output

Unique ZIPs: 0

Chunks: 0

Warnings: 0

🗺️ State → SQL Converter

Convert state codes into Vicidial/SQL IN() or NOT IN() filter statements.

Paste state codes (e.g., CA, TX) or upload CSVs (Column A).

No files loaded

SQL field name

Mode

Max items per IN()

U.S. states / territories

Output

Unique States: 0

Chunks: 0

Warnings: 0