Standardize a column without moving its rows
A column of places often mixes full names, postal codes and older abbreviations. Convert them to one format before a spreadsheet lookup, mailing-list check or database import. This tool covers the 56 U.S. state, district and territory entries, 13 Canadian provinces and territories, and six supplementary USPS codes. Each input line keeps its position, including blank lines. Review notes explain special postal codes and hidden-character cleanup. Your input is processed locally in your browser.
State and province conversion examples
A mixed column of abbreviations
Input
Calif. CA california N.Y.
Result
CA CA CA NY
Traditional abbreviations, postal codes and full names can share one column. CA already has the requested format; the other values are standardized without deduplicating rows.
Canadian and military codes
Input
US-CA CA-ON PQ AA
Result
CA ON QC AA
ISO subdivision forms are accepted. PQ is an older Quebec abbreviation. AA remains a military postal code, with its type explained in the review panel.
Expand codes and keep empty rows
Input
CA DC QC
Result
California Washington D.C. Quebec
Full-name output uses the dataset names. The empty row remains empty, keeping the converted column aligned with the source.
How to convert state and province names
- Paste one value per line or open a UTF-8 text file. Choose Abbreviation or Full name.
- Keep Converted value only to replace a spreadsheet column, or choose tab-separated pairs to compare original and converted values side by side.
- Review unmatched values and notes. Keep unresolved input as written, or explicitly choose blank output for those rows.
- Copy or download the result. Optional next steps can sort, deduplicate or compare it; those operations can change row order or row count.
State abbreviation questions
Are territories and military codes included?
Yes. The 56 U.S. entries include DC and five territories. AA, AE and AP are military postal codes; FM, MH and PW identify freely associated states. These supplementary codes are labeled by type rather than presented as U.S. states.
Can I mix Canadian provinces with U.S. states?
Yes. All 13 provinces and territories are included. Their current postal codes do not collide with U.S. codes. Traditional forms such as Alta., Que. and Nfld. are accepted, along with reviewed older forms PQ, NF and YK.
What does Washington mean?
Washington alone resolves to WA. Washington DC, Washington, D.C., District of Columbia and D.C. resolve to DC. Full-name output preserves the dataset spelling, Washington D.C.
Will the output stay aligned with my spreadsheet?
Yes. Conversion keeps one output line for every input line, in the same order. Blank lines remain. Unmatched or ambiguous values keep their original text unless you choose blank output. No header row is added.
Postal references, not address validation
Matching ignores case, accents, periods, repeated spaces and reviewed name variations. It does not guess misspellings or validate addresses, ZIP codes or residency. CRLF, LF and CR input rows are accepted; output uses LF. Up to 250,000 lines are supported within the shared input limit; counts and output cover all rows, while the review panel keeps the first 500 notes or unresolved rows.