List of Top 50 Largest Cities in United States
Why I Made This City List…
I grew tired of searching for a well-formatted web page where I could easily grab a list of the largest US cities and drop them into Excel (mostly to make drop-down lists or create sample data).
So I took matters into my own hands and have painstakingly listed out the city names, their two-letter state abbreviations, region, and population size (2020 census results). 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 United States
City
New York
Los Angeles
Chicago
Houston
Phoenix
Philadelphia
San Antonio
San Diego
Dallas
San Jose
Austin
Jacksonville
Fort Worth
Columbus
Indianapolis
Charlotte
San Francisco
Louisville
Seattle
Nashville
Denver
Washington
Oklahoma City
El Paso
Boston
Portland
Las Vegas
Detroit
Memphis
Baltimore
Milwaukee
Albuquerque
Tucson
Fresno
Sacramento
Kansas City
Mesa
Atlanta
Omaha
Colorado Springs
Raleigh
Long Beach
Virginia Beach
Miami
Oakland
Minneapolis
Tulsa
Bakersfield
Wichita
Arlington
State
NY
CA
IL
TX
AZ
PA
TX
CA
TX
CA
TX
FL
TX
OH
IN
NC
CA
KY
WA
TN
CO
DC
OK
TX
MA
OR
NV
MI
TN
MD
WI
NM
AZ
CA
CA
MO
AZ
GA
NE
CO
NC
CA
VA
FL
CA
MN
OK
CA
KS
TX
Population (2020)
8,804,190
3,898,747
2,746,388
2,304,580
1,608,139
1,603,797
1,434,625
1,386,932
1,304,379
1,013,240
961,855
949,611
927,720
905,748
887,642
874,579
873,965
782,969
737,015
715,884
715,522
689,545
681,054
678,815
675,647
652,503
641,903
639,111
633,104
585,708
577,222
564,559
542,629
542,107
524,943
508,090
504,258
498,715
486,051
478,961
467,665
466,742
459,470
442,241
440,646
429,954
413,066
403,455
397,532
394,266
Region
Northeast
West
Midwest
South
West
Northeast
South
West
South
West
South
South
South
Midwest
Midwest
South
West
South
West
South
West
South
South
South
Northeast
West
West
Midwest
South
Northeast
Midwest
West
West
West
West
Midwest
West
South
Midwest
West
South
West
South
South
West
Midwest
South
West
Midwest
South
If you would like to download this data stored inside a Microsoft Excel spreadsheet, simply click the button below.
How To Paste This List Into Microsoft Excel
Here are the steps I take to paste this data quickly and cleanly into Excel
- Use ctrl + c and ctrl + v to copy/paste the data from this page into your spreadsheet
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 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’d 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!
Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!
Keep Learning
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.