Here’s a simple Excel spreadsheet of US States and their abbreviations. I don’t know how many times I’ve recreated this blooming thing. I just found myself, once again trying to find a decent table of states to put into my Supple Forms states drop down list, and after ten minutes and finally getting it into an nice Excel table, I figured it was time to memorialize it forever here. So, no more hunting around.
UPDATE: I’ve replaced the original Excel file with a CSV. This is safer for everybody involved since Excel files can have macros. Also, the CSV includes the State as both all CAPS and proper case.
Here you go:
Download: US States
Alabama,AL
Alaska,AK
Arizona,AZ
Arkansas,AR
California,CA
Colorado,CO
Connecticut,CT
Delaware,DE
Florida,FL
Georgia,GA
Hawaii,HI
Idaho,ID
Illinois,IL
Indiana,IN
Iowa,IA
Kansas,KS
Kentucky,KY
Louisiana,LA
Maine,ME
Maryland,MD
Massachusetts,MA
Michigan,MI
Minnesota,MN
Mississippi,MS
Missouri,MO
Montana,MT
Nebraska,NE
Nevada,NV
New Hampshire,NH
New Jersey,NJ
New Mexico,NM
New York,NY
North Carolina,NC
North Dakota,ND
Ohio,OH
Oklahoma,OK
Oregon,OR
Pennsylvania,PA
Rhode Island,RI
South Carolina,SC
South Dakota,SD
Tennessee,TN
Texas,TX
Utah,UT
Vermont,VT
Virginia,VA
Washington,WA
West Virginia,WV
Wisconsin,WI
Wyoming,WY
Thank you, thank you, thank you!
I hear ya! Welcome.
Thanks for posting this, much easier than retyping.
FYI, you can add the state abbreviations to a custom list in Excel. These lists will persist across Excel sessions. After pasting the state abbreviations into Excel (and using Text to Columns to separate the abbreviations from the full names), just go to Tools > Options > Custom Lists and you can import the lists into Excel. (At least, that’s how it works in Excel 2003.) Now all you have to do is type “AK” in any cell, then click and drag down and you get your state abbreviations!
Hi JP,
Great tip! Thanks,
BB
So simple, yet such a time-saver! THANKS.
Welcome!
BB
Very convenient.
Thank you.
Thanks!
Thanks sooooooooooooo much! I’ve retyped the same darn thing a thousand times over myself. No more!!!
Welcome!
can you further enhance this excel sheet by indicating if on west cost of east coast?
Thanks so much. I have an old verson of Excel for use on a mac. No way to import custom stuff from MS. You just saved me an hour or two!
Thank you so much!! Your spreadsheet of the states reduced my website building time significantly.
THANKS a million 😀