×

Simple List of 50 States, Abbreviations, & Capitals

By Chris Newman •  Updated: 09/18/23 •  4 min read
Excel list of United States, state Capitals, and State Abbreviations

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!

State
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

State
AL
AK
AZ
AR
CA
CO
CT
DE
FL
GA
HI
ID
IL
IN
IA
KS
KY
LA
ME
MD
MA
MI
MN
MS
MO
MT
NE
NV
NH
NJ
NM
NY
NC
ND
OH
OK
OR
PA
RI
SC
SD
TN
TX
UT
VT
VA
WA
WV
WI
WY

State Capital
Montgomery
Juneau
Phoenix
Little Rock
Sacramento
Denver
Hartford
Dover
Tallahassee
Atlanta
Honolulu
Boise
Springfield
Indianapolis
Des Moines
Topeka
Frankfort
Baton Rouge
Augusta
Annapolis
Boston
Lansing
St. Paul
Jackson
Jefferson City
Helena
Lincoln
Carson City
Concord
Trenton
Santa Fe
Albany
Raleigh
Bismarck
Columbus
Oklahoma City
Salem
Harrisburg
Providence
Columbia
Pierre
Nashville
Austin
Salt Lake City
Montpelier
Richmond
Olympia
Charleston
Madison
Cheyenne

Region
South
West
West
South
West
West
Northeast
Northeast
South
South
West
West
Midwest
Midwest
Midwest
Midwest
South
South
Northeast
Northeast
Northeast
Midwest
Midwest
South
Midwest
West
Midwest
West
Northeast
Northeast
West
Northeast
South
Midwest
Midwest
South
West
Northeast
Northeast
South
Midwest
South
South
West
Northeast
South
West
South
Midwest
West


US Territory List in Alphabetical Order

Copy and paste column by column.

US Territory
American Samoa
Guam
Northern Mariana Islands
Puerto Rico
US Virgin Islands
Washington, DC

US Territory
AS
GU
MP
PR
VI
DC

Capital
Pago Pago
Hagatna
Saipan
San Juan
Charlotte Amalie

Region
Territory
Territory
Territory
Territory
Territory
South


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.

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.

United State Shapes for Excel

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
Copying a list of states into Excel

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.

Importing a list of states into Excel

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


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!

Keep Learning

Chris Newman

Chris Newman

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.