Web/ Design/ Vista

Resources for Designers & Developer

Download 50 USA States List – Excel/CSV/SQL/JSON

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