List of Top 50 Largest Cities In The World

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

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

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.

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!

Format Excel Charts Like a Pro!!!

Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!

Get These Hacks Now For Free!

Keep Learning

Explore more →

Add Total Value Labels to Stacked Bar Chart in Excel (Easy)

Stacked Bar Charts Missing Total Labels In Excel Unfortunately, Microsoft does not have the ability to insert data labels at...

Printable Excel Contact List With Dynamic Dotted Underlines

Everybody Should Have One! I'm currently going through a reorganization with my day job and I'm going to be interacting...

Top Microsoft Excel Add-ins You Should Consider Using

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...

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.