US cities and states spreadsheet

Get Started
1

Does anyone have a text file, csv, or excel spreadsheet containing all US cities and states? I need this because I am trying to insert the data into a database and I need something that can be easily parsed. A text file formatted like

City, State

on each line would be perfect.

Thanks in advance.

2

Here ya go:
http://www.maxmind.com/download/worldcities/

125MB, 2.7 million cities

3

I do have one of US cities and states only, in Excel, csv, and text formats. I have sent you a pm regarding this. Please respond if you’re still looking.

4

Thank you so much for that! It wasn’t just US cities, but I had no problem writing a PHP script to remove all other countries and parse the CSV to just extract the needed data.

Thanks again. You saved me so much time… I was going to have to enter everything manually.

5