Convert state names to 2-letter postal abbreviations or full names
Convert US, Canadian, and Australian state names to official 2-letter postal codes (e.g. CA, NY) or expand codes to full names.
🛡️ Your rows never leave your browser.
Why Onfyt: Processes standardize state abbreviations entirely in-browser with dedicated Web Workers so your rows never leave your machine.
Interactive Sample Data
| account_id | contact_name | raw_state | city |
|---|---|---|---|
| ACC-101 | John Miller | California | Los Angeles |
| ACC-102 | Sarah Davis | ny | New York |
| ACC-103 | Michael Clark | Texas | Austin |
| ACC-104 | Emily Wilson | fla. | Miami |
How this tool works
Geographic datasets frequently contain a disorganized mix of full state names ("California", "New York"), lowercase abbreviations ("ca", "ny"), legacy dot abbreviations ("Calif.", "Fla."), and misspellings. This inconsistency creates headaches for sales tax reporting, regional marketing segmentation, and address verification APIs.
Standardizing state and province representations simplifies data management:
- US Postal Service (USPS) standard 2-letter codes (CA, NY, TX, FL) are required by shipping APIs and tax software.
- Full state names ("California", "New York") are preferred for customer-facing documents and executive reports.
This tool maps full state names, common abbreviations, and legacy forms into standardized 2-letter postal codes or full names. It supports all 50 US states, US territories (PR, GU, VI), Canadian provinces (ON, BC, QC), and Australian states (NSW, VIC, QLD).
All processing executes locally in your browser sandbox via Web Workers. Your private customer records never leave your device.
From a regional compliance and sales tax calculation standpoint, standardizing state names to official 2-letter postal codes (e.g., California to CA) is required by tax engines and shipping carrier APIs. DataFix maps full state names, legacy abbreviations with periods, and lowercase codes into standardized uppercase postal abbreviations across US states, Canadian provinces, Australian territories, and major commonwealth geographic regions with consistent verification.
From a data privacy perspective, customer address records contain protected personal information under international privacy statutes. Transmitting customer datasets to external cloud tools creates unnecessary security risks. DataFix executes all state standardization locally within your browser sandbox via Web Workers, ensuring that zero data leaves your local machine.
In automated sales tax compliance (Avalara, TaxJar) and regional logistics routing, state and province designations must match official 2-letter postal codes. Tax engines compute jurisdictional rates based on exact 2-letter abbreviations (e.g., CA, NY, TX). Inconsistent entries such as "Calif." or "New York" cause tax calculation engines to fail or apply fallback default rates. Standardizing state entries client-side ensures accurate billing, clean delivery routing, and dependable regional reporting.
Moreover, our lookup table accounts for regional territory designations and military postal codes (APO, FPO, DPO), ensuring comprehensive geographical coverage for national postal, eCommerce shipping, and tax reconciliation workflows across diverse business sectors.
Things that usually go wrong
- Legacy Dot Abbreviations (Fla., Calif.): Legacy abbreviations with periods confuse standard lookups. DataFix maps traditional forms to modern 2-letter codes.
- Lowercase Codes ("ca" vs "CA"): Lowercase state codes look unprofessional. DataFix capitalizes all 2-letter codes.
- Canadian / US Clashes (e.g. WA vs MB): Specify country context to ensure correct province or state mapping.
Edge cases we tested
🧪 Empty cells or missing values
Safely handled without schema corruption.
🧪 Leading or trailing cell whitespace
Sanitized prior to processing.
🧪 Large files with 25,000+ rows
Streamed via client-side Web Worker without tab freezing.
Frequently Asked Questions
Can it convert in both directions (names to codes and codes to names)?
Yes! You can convert full names into 2-letter codes or expand codes into full names.
Does it support Canadian provinces and Australian states?
Yes. It supports US states, Canadian provinces, and Australian states.
How does it handle lowercase codes like "tx"?
It automatically capitalizes them into standard uppercase (TX).
Is my data private?
Your rows never leave your browser. All processing runs in a JavaScript Web Worker inside this tab.
Related tools
Clean
Standardize Country Names and Codes
Convert inconsistent country names ("USA", "US", "United States") to standardized ISO 3166-1 alpha-2, alpha-3, or full country names.
Open Tool →
Clean
Fix ZIP and Postal Codes
Repair postal codes damaged by Excel auto-truncation, format US ZIP+4, and standardize UK and Canadian formats.
Open Tool →
Clean
Trim Whitespace
Clean up accidental leading, trailing, and duplicate spaces across all columns in your spreadsheet.
Open Tool →