Simple List of 50 States, Abbreviations, & Capitals (2024)

Why I Made This List of 50 US States…

I grew tired of searching for a well-formatted web page where I could easily grab all 50 states and drop them into Excel (mostly to make drop-down lists). So I took matters into my own hands and have painstakingly listed out of the States in the U.S., their two-letter abbreviations, region, and their capital cities.

All this data is listed with the intent of copying them from the list and pasting them into Excel. That’s it! No reformatting, no weird spacing, no removing hyperlinks, notta!

And yes, you are most certainly welcome 🙂

All 50 United States in Alphabetical Order

This table can be copied and pasted column by column!

US Territory List in Alphabetical Order

Copy and paste column by column.

Free Downloadable Files Of States/Capitals/Abbreviations

If you are in search of a specific file format with the 50 United States, their two-letter abbreviations, and their corresponding capital city, below I’ve compiled a variety of file formats you can click and instantly download.

• 50 States (Excel File)
• 50 States (Excel File) - Stored in Table Object
• 50 States (PowerPoint File)
• 50 States (Microsoft Word File)
• 50 States (CSV File)
• 50 States (Text File)

If there are other file formats you want to see, please let me know in the comments section towards the end of this article.

50 State Shapes For Excel

If you would like icons/shapes of the 50 United States, you can check out my post that shows you how to build some neat Excel dashboards and map charts with state shapes that I compiled.

Within the 50 State Shapes Excel tutorial, there is a free spreadsheet download where you can get all the state shapes and reformat them any way you’d like (size, color, etc...).

How To Paste This List Into Microsoft Excel

Here are the steps I take to paste this data quickly and cleanly into Excel

1. Use ctrl + c and ctrl + v to copy/paste the data from this page into your spreadsheet

2. Use ctrl + m to Match Destination Formatting (you can do this with your mouse as well - shown below)

   • This sets the font color to Automatic
   • This adjusts the font size to your default size

Next, you can quickly throw this data into an Excel Table object using the shortcut ctrl + t.

Make sure you check the box stating My table has headers before clicking OK in the Create Table dialog box.

Viola! You now have your states cleanly into Excel and you can utilize them as you wish.

More Lists To Check Out

Printable Excel Contact List With Dynamic Dotted Underlines

Read It >>

Simple List of National Parks In The United States

Read It >>

List of Top 50 Largest Cities In The World

Read It >>

List of Top 50 Largest Cities in United States

Read It >>

Read It >>

Any Other Lists You Would Like to See?

Let me know in the comments section if there are other common listings you’d like me to generate for ease of use. It’s 2023 and it shouldn’t be this complicated to grab these listings cleanly from the internet!