You can download a clean list of US state abbreviations for Excel from several reliable sources. For a direct, structured file, use the CDC Data Map State Names and Abbreviations CSV . Where to Download State Abbreviation Files
: Provides a comprehensive US state list that includes abbreviations and capitals available in Excel, CSV, and Word formats.
: If you are importing this data into a database or mailing software, download the CSV version, as it is more universally compatible than a standard Excel workbook.
If you prefer to copy and paste directly into your spreadsheet, use the table below. It contains the 50 states and the District of Columbia. State Name Abbreviation State Name Abbreviation New Hampshire California New Jersey New Mexico Connecticut North Carolina District of Columbia North Dakota Pennsylvania Rhode Island South Carolina South Dakota Massachusetts Washington West Virginia Mississippi Tips for Using State Data in Excel
: Keep a hidden "Master" sheet with this list to automatically convert full state names into abbreviations in your main data sheets.
: The Bureau of Labor Statistics (BLS) and the USPS maintain the official two-letter standards, though they are often presented as tables you can copy-paste into Excel. US State Abbreviations List (Reference Table)
: You can find frequently updated, developer-friendly datasets such as this states.csv file on GitHub .
If you need specific formats like Excel (XLSX), CSV, or even pre-formatted table objects, these sites offer free downloads:
: Use this list to create a Drop-Down Menu in Excel (Data > Data Validation) to ensure users only enter valid two-letter codes.