✦Template Printable Ideas Insights

All US States with Abbreviations: Comprehensive Excel List

By

Need a quick reference for U.S. state names and their abbreviations? Look no further. This guide will provide you with a comprehensive list of all 50 states and their corresponding two-letter and three-letter abbreviations, perfect for use in your spreadsheets or documents. Let's dive right in.

Before we proceed, it's essential to understand the difference between the two types of abbreviations. Two-letter abbreviations, also known as postal or U.S.PS abbreviations, are used in addressing and on mailing addresses. Three-letter abbreviations, or ISO 3166-1 alpha-3 codes, are internationally recognized and used globally.

U.S. States and Their Two-Letter Abbreviations

Here's a compact list of all U.S. states and their two-letter abbreviations, sorted alphabetically for easy reference.

Free Printable List Of US States Abbreviation [PDF]
Free Printable List Of US States Abbreviation [PDF]
List of All 50 US State Abbreviations
List of All 50 US State Abbreviations
State Abbreviations List State Abbreviations Guide State Abbreviations Handout
State Abbreviations List State Abbreviations Guide State Abbreviations Handout

To use this data in an Excel sheet, simply copy and paste the following table into the desired cells.

State Two-Letter Abbreviation
AlabamaAL
ArizonaAZ
ArkansasAR
CaliforniaCA
ColoradoCO
ConnecticutCT
DelawareDE
FloridaFL
GeorgiaGA
HawaiiHI
IdahoID
IllinoisIL
IndianaIN
IowaIA
KansasKS
KentuckyKY
LouisianaLA
MaineME
MarylandMD
MassachusettsMA
MichiganMI
MinnesotaMN
MississippiMS
MissouriMO
MontanaMT
NebraskaNE
NevadaNV
New HampshireNH
New JerseyNJ
New MexicoNM
New YorkNY
North CarolinaNC
North DakotaND
OhioOH
OklahomaOK
OregonOR
PennsylvaniaPA
Rhode IslandRI
South CarolinaSC
South DakotaSD
TennesseeTN
TexasTX
UtahUT
VermontVT
VirginiaVA
WashingtonWA
West VirginiaWV
WisconsinWI
WyomingWY

Two-Letter Abbreviations in Practice

Two-letter abbreviations are widely used in addressing and postal services. Here's an example of how to format an address using these abbreviations:

study abroad in the united states
study abroad in the united states
US States, Capitals, and Postal Abbreviation MEMORY WORK
US States, Capitals, and Postal Abbreviation MEMORY WORK
50 U.S. States & Capitals with Postal Abbreviations | Printable PDF
50 U.S. States & Capitals with Postal Abbreviations | Printable PDF

John Doe
123 Main St.
Anytown, CA 91234

State Abbreviations in Excel

To use these abbreviations in Microsoft Excel, simply enter the two-letter code in the desired cell, and Excel will automatically recognize it as a state abbreviation. This helps maintain consistency and reduces the risk of errors.

U.S. States and Their Three-Letter Abbreviations

Now, let's explore the ISO 3166-1 alpha-3 codes, which are internationally recognized three-letter abbreviations for each U.S. state.

State Abbreviations: List of All 50 U.S State Abbreviations in English - ESL Forums
State Abbreviations: List of All 50 U.S State Abbreviations in English - ESL Forums
the top ten states in each state with their respective names and abbreviations, as well as
the top ten states in each state with their respective names and abbreviations, as well as
Map of U.S. State Abbreviations
Map of U.S. State Abbreviations
study abroad in the united states
study abroad in the united states
🔴 50 USA State Name, Abbreviation, Map Location, Shape. U.S. United States of America Geography US 🔴
🔴 50 USA State Name, Abbreviation, Map Location, Shape. U.S. United States of America Geography US 🔴
USA States (Two-Letter Abbreviations)
USA States (Two-Letter Abbreviations)

These codes are useful when working with global datasets or when complying with international standards.

State Three-Letter Abbreviation
AlabamaALA
ArizonaAZA
ArkansasARK
CaliforniaCAL
ColoradoCOL
ConnecticutCON
DelawareDEL
FloridaFLA
GeorgiaGAE
HawaiiHAW
IdahoIDA
IllinoisILI
IndianaIND
IowaIOW
KansasKAN
KentuckyKYN
LouisianaLAU
MaineMAI
MarylandMDA
MassachusettsMAS
MichiganMIC
MinnesotaMNP
MississippiMSP
MissouriMOU
MontanaMON
NebraskaNEB
NevadaNEV
New HampshireNHM
New JerseyNJJ
New MexicoNME
New YorkNEW
North CarolinaNCN
North DakotaNDK
OhioOHI
OklahomaOKL
OregonORE
PennsylvaniaPEN
Rhode IslandRIR
South CarolinaSCN
South DakotaSDM
TennesseeTEN
TexasTEX
UtahUTA
VermontVTM
VirginiaVIR
WashingtonWSH
West VirginiaWVA
WisconsinWIS
WyomingWYM

Three-Letter Abbreviations in Global Context

In global datasets, three-letter abbreviations help maintain consistency and compatibility with international standards. Here's an example of how these codes might be used in a global address format:

John Doe
123 Main St.
Anytown, USA-CAL 91234

a table with the names and numbers of different languages
a table with the names and numbers of different languages
American States - Abbreviation - ZIP Codes
American States - Abbreviation - ZIP Codes
the list of us states and their capital cities
the list of us states and their capital cities

State Abbreviations in Excel (With Data Validation)

To maintain accuracy and consistency when using three-letter abbreviations in Excel, you can set up data validation. This helps prevent errors and ensures that only valid state codes can be entered into specific cells.

Knowing the U.S. state names and their corresponding abbreviations is crucial for various applications, from addressing to data analysis. This comprehensive list will serve as an invaluable resource for your projects. Whether you're working with two-letter postal codes or three-letter international codes, this guide has you covered. Happy data crunching!