Google Answers Logo
View Question
Q: List of World Cities ( Answered,   0 Comments )
Subject: List of World Cities
Category: Reference, Education and News > General Reference
Asked by: artdonovan-ga
List Price: $100.00
Posted: 03 Nov 2006 17:06 PST
Expires: 03 Dec 2006 17:06 PST
Question ID: 779905
I would like a public domain list of all the world cities formatted in
a XLS or CSV format. The list would have City, Country, Latitude,
Longitude and would have all cities with more than 100,000 people.  I
already have all the US cities, so I don't want these in the list.  I
am willing to pay for the actual file with the list of cities, not for
a tip on how I can build it myself or pay some data provider to
license it to me.

Request for Question Clarification by pafalafa-ga on 03 Nov 2006 18:27 PST

I have a list of about 700 of the world's largest cities (both US and
non-US) with city, population, lat/long and country.

The list covers all cities with populations of 500,000 or more, so
isn't quite everything you're after, but pretty close.

The listings, in spreadsheet format, look like this:

Shanghai	15,017,783	31.23N	121.47E	China
Bombay	        12,883,645	18.96N	72.82E	        India
Karachi	        11,969,284	24.86N	67.01E	        Pakistan
Buenos Aires	11,595,183	34.61S	58.37W	        Argentina
Delhi	        11,215,130	28.67N	77.21E	        India
Manila	        10,546,511	14.62N	120.97E	Philippines
Moscow	        10,472,629	55.75N	37.62E	        Russia
Seoul	        10,409,345	37.56N	126.99E	Korea (South)
So Paulo	10,059,502	23.53S	46.63W	        Brazil
Istanbul	10,034,830	41.10N	29.00E	        Turkey
Lagos	         9,020,089	6.45N	3.47E	        Nigeria
Mexico City	 8,659,409	19.43N	99.14W	        Mexico
Jakarta	         8,556,798	6.18S	106.83E	Indonesia
Tokyo	         8,372,440	35.67N	139.77E	Japan
New York	 8,124,427	40.67N	73.94W	        United States 

[the above table may not stay formatted after posting....sorry!]

In my experience, the free lists available for world cities tend to be
huge databases with hundreds of thousands of entries -- more than my
poor PC can handle.

For instance, the free download at World Gazetteer:

has just what you need, but the dataset is several hundred thousand
entries in length...too large for an Excel file to handle.

Anyway, let me know if the 700+ cities I have available is of interest to you.

Subject: Re: List of World Cities
Answered By: hummer-ga on 23 Nov 2006 14:23 PST
Hi artdonovan,

Ok, here you go. I made an XLS file for you of all cities in the world
with a population over 100,000 excluding the U.S.. You can get it by
clicking on this link:

Your file is available for download:
GA-cities-world.xls (2534 KB)

I compiled the list using the data I found here:

Click on: "world large city list"
"This page lists all cities with population of more than 100,000 in the world."

I was glad to work on this for you, I hope it's just what you want. If
you have any questions, please post a clarification request and wait
for me to respond before closing/rating my answer. My file will be
available for only 7 days, so if you miss retrieving it before then
for some reason, just let me know and I'll upload another copy.

Thank you,
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy