Row & Page / Guides
US State Abbreviation Normalizer
CRM Import-Ready Contact Cleanup
Want the whole file cleaned? We fix emails, phones, names and duplicates and return an import-ready CSV. $9 per 500 rows.
A state column filled in by hand ends up with "Texas", "TX", "Tex." and "tx " all meaning the same thing. Filters, segments and territory reports then split one state into four. Load your file below to convert every value to the official two-letter code, or to full names if you prefer. The tool runs in your browser and does not upload your file.
US state abbreviation normalizer
Paste state values one per line, or upload a CSV and name the state column. Full names ("Texas"), old-style abbreviations ("Tex.", "Calif"), lower case ("tx") and stray spaces or periods are converted to the two-letter USPS code. Values it cannot match are flagged.
Your file is read in your browser with JavaScript. Nothing is uploaded or sent anywhere, and nothing is stored after you close the page.
Where the codes come from
The tool uses the two-letter state and possession abbreviations in USPS Publication 28, Appendix B (source: https://pe.usps.com/text/pub28/28apb.htm). That list covers the 50 states, the District of Columbia (DC) and the possessions USPS lists: American Samoa (AS), Federated States of Micronesia (FM), Guam (GU), Marshall Islands (MH), Northern Mariana Islands (MP), Palau (PW), Puerto Rico (PR) and Virgin Islands (VI). USPS says to use these abbreviations when addressing mail (source: https://pe.usps.com/text/pub28/28apb.htm).
What the normalizer fixes
- Full names in any case: "texas", "TEXAS" and "Texas" all become TX.
- Codes in the wrong case or with periods: "tx", "T.X." and "Tx." become TX.
- Common old-style abbreviations such as Calif, Fla, Mass, Penn, Tenn and Wash.
- Forms like "Washington DC", "N Carolina" and "State of New York".
- Extra spaces before or after the value.
What gets flagged
Anything that is not a US state, DC or a listed possession, such as Canadian provinces, country names, city names typed into the state field, or typos. Flagged values are left unchanged and marked in a new state_check column so you can fix them by hand. Blank cells stay blank.
Code or full name?
We suggest storing the two-letter code. It is short, consistent and matches how USPS asks for addresses to be written. Some CRMs and forms display full names; pick "Full name" in the tool if your system expects those, and make sure your import uses the same format as your existing records.
Related clean-up
- ZIP codes lost their leading zeros? Use the ZIP code fixer.
- Phone numbers: the phone number format fixer.
- Full names in one column: the CSV name splitter.
FAQ
Does it handle Canadian provinces?
No. It only matches US states, DC and the USPS-listed possessions. Province values are flagged, not changed.
What about military addresses?
The tool does not convert Armed Forces values. They are flagged so you can check them by hand.
Is my file uploaded?
No. The file is read by JavaScript in your browser. Nothing is sent to us or anyone else, and nothing is kept after you close the tab.
If you want the whole file cleaned
Our CRM Import-Ready Contact Cleanup fixes names, emails, phones, states, ZIP codes and duplicates across the whole file and returns an import-ready CSV for $9 per 500 rows. We are independent and not affiliated with any CRM vendor.
Buy CRM cleanup - $9 per 500 rows
CRM Import-Ready Contact Cleanup
Want the whole file cleaned? We fix emails, phones, names and duplicates and return an import-ready CSV. $9 per 500 rows.