It is important to know what do you want to do with it ?
If you want to map locations against it, do you want the data in UTM or WGS84 format?
If you want to simply color the states that isn't important
You also want cities ?
Either what Hui said or a Choropleth in Excel. Example below but same principles apply
Hi All, In terms of creating Choropleths I am a complete novice. For those of you who don't know what a Choropleth is, its basically a Geographical representation of data (as I understand it). What that means is that you create a map that changes basis the data you input, e.g. location wise...chandoo.org