While working with US based clients, I often needed to use lists containing all the 50 states in the USA.

In most cases this list is required in one of the following formats

1. Spreadsheet (excel) / Csv list
2. A table with rows of states in a database
3. Plain Array format – keys being the state abbreviations and full state names as values

Usually this list is available in a table format on a web page, and you have to download and convert it to your preferred format. Not anymore! Here i have done the legwork for you! Find below the most in demand formats of this list.

1. USA States list in Spreadsheet (excel ) / CSV format
2. USA States list – SQL Dump
3. USA States list in plain PHP array format
4. USA States list in JSON format