How it WorksWho it's ForFeaturesExamplesLearn

Expanding state abbreviations

Expand or contract US state abbreviations to create addresses

Expanding state abbreviations


Switching between abbreviations and full names of States can be useful when transferring address data, yet it can be labor intensive. In Excel you may use a VLOOKUP, and in SQL you may use a JOIN.


Using provided data that has both the long form and abbreviations of states makes adjusting your data as simple as using the Join Object to add key data directly to your data. Just choose if you want to match along the abbreviation or the full name.

Start automating with Parabola
Parabola is free to use for teams of any size. We also offer paid plans with additional features and support.