List of the 50 States, Abbreviations, & Capitals
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!
Salt Lake City
US Territory List in Alphabetical Order
Copy and paste column by column.
Northern Mariana Islands
US Virgin Islands
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
- Use ctrl + c and ctrl + v to copy/paste the data from this page into your spreadsheet
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
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!
Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!
Override Values With Formula Using Power Query
If you haven’t learned about Excel’s Power Query feature, you are missing out on a huge opportunity to create automated...
How To Create Excel Progress Bar Charts (Professional-Looking!)
Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...
Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.