Excel Spreadsheet of US States

By byron on February 12, 2009 in ASP.NET/C#, Blogging, Miscellany, Worksoft Certify

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

14 Responses to Excel Spreadsheet of US States

Sheri Rawlings July 17, 2009 at 11:21 am #

Thank you, thank you, thank you!
Byron Bennett July 17, 2009 at 11:48 am #

I hear ya! Welcome.
JP September 22, 2009 at 9:06 am #

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!
Byron Bennett September 22, 2009 at 9:10 am #

Hi JP,

Great tip! Thanks,
BB
MK November 1, 2009 at 6:32 pm #

So simple, yet such a time-saver! THANKS.
Byron Bennett November 1, 2009 at 8:49 pm #

Welcome!
BB
RJB March 8, 2010 at 3:20 pm #

Very convenient.
Thank you.
Lauren April 20, 2010 at 12:51 pm #

Thanks!
Jeremiah June 9, 2010 at 10:32 am #

Thanks sooooooooooooo much! I’ve retyped the same darn thing a thousand times over myself. No more!!!
- Byron Bennett June 9, 2010 at 11:43 am #
  
  Welcome!
paul henshaw July 12, 2010 at 3:21 am #

can you further enhance this excel sheet by indicating if on west cost of east coast?
Pat Raz July 21, 2010 at 6:02 pm #

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!
With Gratitude August 21, 2010 at 6:05 pm #

Thank you so much!! Your spreadsheet of the states reduced my website building time significantly.
dalik September 14, 2010 at 6:15 am #

THANKS a million