All 50 US states as CSV, XML, JSON and XLS files

by Klaus Graefensteiner 22. June 2010 02:00


Every now and then I need to work with US states data, but I never seem to find the right format on the interweb. The best I found so far is the following wiki article:


Figure 1: US states

In preparation of this article I created a Microsoft Excel spreadsheet that contains the following information for each of the 50 US states:

  • name
  • abbreviation
  • capital
  • most populous cit
  • population
  • square miles
  • time zone 1
  • time zone 2
  • DST (daylight savings time)

Microsoft Excel - States.xlsx

Figure 2: Looking at the states table

Next I converted the spreadsheet into a comma separated file using the Excel Save As command. The CSV I transformed into XML using PowerShell and the XML to JSON conversion was also done using this XML TO JSON online converter .


The set of four files can be downloaded here:


I hope this will make your live a little bit easier, since you don’t have to find and convert states data yourself.

Tags: , , , ,

Tips & Tricks

Comments are closed

About Klaus Graefensteiner

I like the programming of machines.

Add to Google Reader or Homepage

LinkedIn FacebookTwitter View Klaus Graefensteiner's profile on Technorati
Klaus Graefensteiner

Klaus Graefensteiner
works as Developer In Test and is founder of the PowerShell Unit Testing Framework PSUnit. More...

Open Source Projects

PSUnit is a Unit Testing framwork for PowerShell. It is designed for simplicity and hosted by Codeplex.
BlogShell is The tool for lazy developers who like to automate the composition of blog content during the writing of a blog post. It is hosted by CodePlex.



Powered by:

Creative Commons License

© Copyright 2015, Klaus Graefensteiner.

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Theme design:
This blog theme was designed and is copyrighted 2015 by Klaus Graefensteiner

Page rendered at 5/27/2015 6:45:28 PM (PST Pacific Standard Time UTC DST -7)