×

List of Top 50 Largest Cities In The World

By Chris Newman •  Updated: 04/08/22 •  3 min read
A list of the 50 largest cities in the world sorted by population for Excel import

Why I Made This City List…

I grew tired of searching for a well-formatted web page where I could easily grab simple lists of names like the 50 U.S. States or the largest cities in the world. Oftentimes, I would rely on these sorts of lists to create drop-down lists or create sample data within my Excel spreadsheets.

So I took matters into my own hands and have painstakingly listed out the city names, countries, continents, and estimated population sizes. All this data is listed with the intent of copying them from the list and pasting them into Excel. That’s it! No reformatting, no weird spacing, no removing hyperlinks, notta! And yes, you are most certainly welcome 🙂

Bonus: I even have a direct download if you want this data already in an Excel Spreadsheet (link below the table).

Top 50 Largest Cities In The World

No.
01.
02.
03.
04.
05.
06.
07.
08.
09.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.

City
Chongqing
Shanghai
Beijing
Chengdu
Delhi
Guangzhou
Mumbai
Shenzhen
Kinshasa
Istanbul
Karachi
Tokyo
Tianjin
Zhengzhou
São Paulo
Tehran
Moscow
Hangzhou
Lahore
Shijiazhuang
Suzhou
Jakarta
Dongguan
Qingdao
Changsha
Cairo
Harbin
Seoul
Ningbo
Hefei
Nanjing
Mexico City
Jinan
Ho Chi Minh City
London
New York
Xi'an
Kunming
Chittagong
Bengaluru
Shenyang
Bangkok
Hanoi
Lagos
Riyadh
Changchun
Lima
Hong Kong
Bogotá
Baghdad

Country
China
China
China
China
India
China
India
China
Congo
Turkey
Pakistan
Japan
China
China
Brazil
Iran
Russia
China
Pakistan
China
China
Indonesia
China
China
China
Egypt
China
South Korea
China
China
China
Mexico
China
Vietnam
United Kingdom
United States
China
China
Bangladesh
India
China
Thailand
Vietnam
Nigeria
Saudi Arabia
China
Peru
Hong Kong
Colombia
Iraq

Population
32,054,159
24,870,895
21,893,095
20,937,757
18,983,000
18,676,605
18,414,288
17,560,000
17,071,000
15,462,452
14,910,352
14,043,239
13,866,009
12,600,574
12,400,232
12,223,598
11,979,529
11,936,010
11,126,285
11,031,200
10,721,700
10,562,088
10,466,625
10,071,722
10,047,914
10,025,657
10,009,854
9,765,869
9,404,283
9,369,881
9,314,685
9,209,944
9,202,432
8,993,082
8,961,989
8,804,190
8,467,838
8,460,088
8,440,000
8,425,970
8,294,171
8,280,925
8,053,663
7,937,932
7,676,654
7,674,439
7,605,742
7,507,400
7,412,566
7,216,040

Continent
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Africa
Asia
Asia
Asia
Asia
Asia
South America
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Africa
Asia
Asia
Asia
Asia
Asia
North America
Asia
Asia
Europe
North America
Asia
Asia
Asia
Asia
Asia
Asia
Asia
Africa
Asia
Asia
South America
Asia
South America
Asia


How To Paste This List Into Microsoft Excel

Here are the steps I take to paste this data quickly and cleanly into Excel

  1. Use ctrl + c and ctrl + v to copy/paste the data from this page into your spreadsheet
  2. Use ctrl + m to Match Destination Formatting (you can do this with your mouse as well, shown below)
    • This sets the font color to Automatic
    • This adjusts the font size to your default size
Copying a list of states into Excel

Next, you can quickly throw this data into an Excel Table object using the shortcut ctrl + t.

Make sure you check the box stating My table has headers before clicking OK in the Create Table dialog box.

Importing a list of states into Excel

Viola! You now have your states cleanly into Excel and you can utilize them as you wish.


Any Other Lists You Would Like to See?

Let me know in the comments section if there are other common listings you’d like me to generate for ease of use. In this day and age, it shouldn’t be this complicated to grab these sorts of listings cleanly from the internet!

Keep Learning

Chris Newman

Chris Newman

Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.