I have a spreadsheet where I am compiling a list of all cities in the United State, Canada and Mexico.
I've started working on it.
There are two columns.
Column A - The State
Column B - The City and the State
State City, State
Virginia Norfolk, Virginia
I need a list of ALL cities in the US, Canada and Mexico in the format mentioned above.
I already have the cities for Virginia, Maryland, Delaware, California, and North Carolina.
I've just change the name at the end of the following wikipedia link to get the name of all cities in that state.
[url removed, login to view]