Excel Spreadsheet of US States

12 Comments  
by Byron Bennett / February 12th, 2009

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.  Here you go:

Download:  US States

AK,ALASKA
AL,ALABAMA
AR,ARKANSAS
AZ,ARIZONA
CA,CALIFORNIA
CO,COLORADO
CT,CONNECTICUT
DE,DELAWARE
FL,FLORIDA
GA,GEORGIA
HI,HAWAII
IA,IOWA
ID,IDAHO
IL,ILLINOIS
IN,INDIANA
KS,KANSAS
KY,KENTUCKY
LA,LOUISIANA
MA,MASSACHUSETTS
MD,MARYLAND
ME,MAINE
MI,MICHIGAN
MN,MINNESOTA
MO,MISSOURI
MS,MISSISSIPPI
MT,MONTANA
NE,NEBRASKA
NC,NORTH CAROLINA
ND,NORTH DAKOTA
NH,NEW HAMPSHIRE
NJ,NEW JERSEY
NM,NEW MEXICO
NY,NEW YORK
NV,NEVADA
OH,OHIO
OK,OKLAHOMA
OR,OREGON
PA,PENNSYLVANIA
RI,RHODE ISLAND
SC,SOUTH CAROLINA
SD,SOUTH DAKOTA
TN,TENNESSEE
TX,TEXAS
UT,UTAH
VA,VIRGINIA
VT,VERMONT
WA,WASHINGTON
WI,WISCONSIN
WV,WEST VIRGINIA
WY,WYOMING

Popularity: 49%

Filed under: ASP.NET/C#, Blogging, Miscellany, Worksoft Certify

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

« Previous:
Next: »

Comments

  1. Sheri Rawlings Says:
    July 17th, 2009 at 11:21 am

    Thank you, thank you, thank you!

  2. Byron Bennett Says:
    July 17th, 2009 at 11:48 am

    I hear ya! Welcome.

  3. JP Says:
    September 22nd, 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!

  4. Byron Bennett Says:
    September 22nd, 2009 at 9:10 am

    Hi JP,

    Great tip! Thanks,
    BB

  5. MK Says:
    November 1st, 2009 at 6:32 pm

    So simple, yet such a time-saver! THANKS.

  6. Byron Bennett Says:
    November 1st, 2009 at 8:49 pm

    Welcome!
    BB

  7. RJB Says:
    March 8th, 2010 at 3:20 pm

    Very convenient.
    Thank you.

  8. Lauren Says:
    April 20th, 2010 at 12:51 pm

    Thanks!

  9. Jeremiah Says:
    June 9th, 2010 at 10:32 am

    Thanks sooooooooooooo much! I’ve retyped the same darn thing a thousand times over myself. No more!!!

  10. Byron Bennett Says:
    June 9th, 2010 at 11:43 am

    Welcome!

  11. paul henshaw Says:
    July 12th, 2010 at 3:21 am

    can you further enhance this excel sheet by indicating if on west cost of east coast?

  12. Pat Raz Says:
    July 21st, 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!

Leave a Reply