United States Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML

United_States
United States
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
United States
Capital
Washington
Number of cities
166794
Download

Here you’ll find a curated sample of 100 key cities from United States, each with essential data points such as latitude, longitude, administrative region, and other relevant attributes. This preview is extracted from our full dataset, which includes a total of 166794 geographic locations across United States.

Whether you’re working on mapping, analytics, or app development, the data is available for both personal and commercial use. All entries can be downloaded in five formats: Excel (.xlsx), CSV, SQL, JSON, and XML.

Capital Highlight: The official capital city of United States is Washington.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
5148413 Brookside US Ohio Belmont County 40.07063 -80.76092 201 614 America/New_York populated place
4740324 Waverly US Texas San Jacinto County 30.52492 -95.3505 128 0 America/Chicago populated place
5184623 Clinton US Pennsylvania Butler County 40.72423 -79.78561 385 0 America/New_York populated place
5516596 Baker US Texas Cottle County 34.20146 -100.11122 529 0 America/Chicago populated place
5024937 East Bethel City of East Bethel,East Bethel,Ist Betel,Ist Bezehl,Ist-Betel,ayst bythyl,Іст-Бетел,Ист Безэл,Ист Бетел,Ист-Бетел,إيست بيثيل,ایست بتل، مینه‌سوتا,ایسٹ بیتھل، مینیسوٹا US Minnesota Anoka County 45.31941 -93.20245 277 11692 America/Chicago populated place
7870714 Timber Creek Estates US Ohio Trumbull County 41.29316 -80.74818 0 America/New_York populated place
4700225 Ismael Montalvo Colonia Number 2 Ismael Montalvo Colonia Number 2,Ismael Montalvo Subdivision Number 2 US Texas Cameron County 26.0273 -97.62582 14 0 America/Chicago populated place
4982252 Wattons Mill Watsons Mill,Wattons Mill US Maine Knox County 44.17313 -69.23393 44 0 America/New_York populated place
4061270 Fairview US Alabama Lauderdale County 34.90981 -87.74364 184 0 America/Chicago populated place
5165303 Oakmont US Ohio Wood County 41.54172 -83.59716 193 0 America/New_York populated place
4350837 Centennial Homestead US Maryland Carroll County 39.49455 -76.90498 165 0 America/New_York populated place
4907773 Roanoke US Illinois Woodford County 40.79615 -89.1973 222 2073 America/Chicago populated place
4286219 Buras US Kentucky Breckinridge County 37.70173 -86.31609 231 0 America/Chicago populated place
4512467 Gano US Ohio Butler County 39.30228 -84.40827 203 0 America/New_York populated place
4360539 Lennox Park US Maryland Howard County 39.1765 -76.75164 56 0 America/New_York populated place
5865721 Kaltag Ggaal Doh,KAL,Kahltog,Kaltag,Kchaltak,Kkhaltel,Upper Kaltag,ka er ta ge,kaltag alaska,kaltagh,kyatalaga,Калтаг,كالتاغ,کالتاگ، آلاسکا,क्याटलाग,卡尔塔格 US Alaska Yukon-Koyukuk Census Area 64.32722 -158.72194 30 189 America/Anchorage populated place
4715031 North Buena Vista Colonia North Buena Vista Colonia,Solis Subdivision Colonia US Texas Duval County 27.74419 -98.24528 99 0 America/Chicago populated place
7147699 Freedom View US Pennsylvania Chester County 40.0969 -75.4739 77 0 America/New_York populated place
4368581 Saint Peters Key US Maryland Saint Mary’s County 38.1704 -76.41634 7 0 America/New_York populated place
4393997 LaValle La Valle,LaValle US Missouri Stoddard County 36.67533 -89.7737 87 0 America/Chicago populated place
4504104 Shinntown US New Jersey Burlington County 39.90011 -74.84405 17 0 America/New_York populated place
5800314 Lake Shore US Washington Clark County 45.69067 -122.69093 68 6571 America/Los_Angeles populated place
5086491 Gates Corner US New Hampshire Strafford County 43.22175 -70.88617 60 0 America/New_York populated place
5503283 Duckwater US Nevada Nye County 38.93243 -115.71448 1674 0 America/Los_Angeles populated place
5579857 Midway US Colorado Washington County 40.22637 -103.39772 1356 0 America/Denver populated place
4070746 Keystone Hardyville,Keystone US Alabama Shelby County 33.26789 -86.80971 145 0 America/Chicago populated place
5180058 Berkshire Hills US Pennsylvania York County 40.13981 -77.0297 144 0 America/New_York populated place
7239877 Catalpa Grove Mobile Home Park US Ohio Montgomery County 39.78972 -84.27194 241 0 America/New_York populated place
7714126 Portal Creek Mobile Home Park US Washington Whatcom County 48.87214 -122.5813 18 0 America/Los_Angeles populated place
4579339 Fruit Hill Fruit Hill,Fruithill US South Carolina Saluda County 33.94319 -81.85456 160 0 America/New_York populated place
5203144 New Columbus US Pennsylvania Carbon County 40.86842 -75.81519 258 207 America/New_York populated place
4308076 Shawnee Estates US Kentucky Warren County 36.95282 -86.45721 165 0 America/Chicago populated place
4603616 Baileyton Bailey,Baileyton,Laurel Gap US Tennessee Greene County 36.33427 -82.83683 369 431 America/New_York populated place
5005450 Petersburg Peterburg,Петербург US Michigan Monroe County 41.90116 -83.71494 206 1131 America/Detroit populated place
4358715 Hunters Harbor US Maryland Anne Arundel County 39.09705 -76.45663 5 0 America/New_York populated place
5178360 Ansonville US Pennsylvania Clearfield County 40.84756 -78.56558 511 0 America/New_York populated place
4792277 Warrington Heights US Virginia Dinwiddie County 37.21237 -77.47304 52 0 America/New_York populated place
4805681 Fayette Heights US West Virginia Fayette County 38.02428 -81.1151 601 0 America/New_York populated place
4771593 Marengo Hagood,Hagood Station,Marengo US Virginia Mecklenburg County 36.63848 -78.11944 116 0 America/New_York populated place
4636191 Lees Corner US Tennessee Maury County 35.69701 -86.8325 217 0 America/Chicago populated place
5085654 East Acworth US New Hampshire Sullivan County 43.22063 -72.23675 315 0 America/New_York populated place
5681679 Tarkio US Montana Mineral County 47.02131 -114.73901 895 0 America/Denver populated place
4141063 Westchester US Washington, D.C. Washington County 38.92594 -77.0797 78 0 America/New_York populated place
4720093 Porter US Texas Montgomery County 30.10244 -95.22966 31 0 America/Chicago populated place
8605009 Denali National Park US Alaska Denali Borough 63.54078 -151.72361 217 America/Anchorage populated place
5797557 Holtzinger US Washington Yakima County 46.67762 -120.72063 537 0 America/Los_Angeles populated place
5779176 Oakridge Farms US Utah Davis County 41.00272 -111.923 1312 0 America/Denver populated place
7217746 Gallery Gardens US Florida Hillsborough County 27.8998 -82.2906 9 0 America/New_York populated place
4663392 Tryon Trion,Tryon US Tennessee Jefferson County 35.98426 -83.32294 316 0 America/New_York populated place
4257650 Four Corners US Indiana Jennings County 38.95422 -85.74025 176 0 America/Indiana/Indianapolis populated place
4069520 Jackson Quarters US Alabama Greene County 32.64486 -87.85168 47 0 America/Chicago populated place
4952964 Thorndike Thorndike,Thorndike Village US Massachusetts Hampden County 42.18759 -72.33564 137 0 America/New_York populated place
7198156 Blackburn Village US Maryland Montgomery County 39.1056 -76.9305 134 0 America/New_York populated place
5225533 Washington Brayton Town,Braytonville,Coventry,Washington,Washington Village US Rhode Island Kent County 41.68843 -71.56673 75 0 America/New_York populated place
4133143 Tanglewood US Arkansas Benton County 36.31674 -93.9302 404 0 America/Chicago populated place
4830903 Avon Ejvon,afwn,ai wen,awwn alabama,ebhona,Ейвон,Ејвон,آوون، آلاباما,أفون,एभोन,埃文 US Alabama Houston County 31.18934 -85.28604 73 530 America/Chicago populated place
4104614 Carmel US Arkansas Bradley County 33.54483 -92.07153 74 0 America/Chicago populated place
4586197 Manning Acres US South Carolina Spartanburg County 34.92012 -82.18539 276 0 America/New_York populated place
4360615 Liberty Lake Hills US Maryland Carroll County 39.40427 -76.90414 148 0 America/New_York populated place
4397333 Marvin US Missouri Morgan County 38.41642 -92.77075 310 0 America/Chicago populated place
4656495 Sequoyah Shores US Tennessee Roane County 35.8473 -84.52882 246 0 America/New_York populated place
4442913 Raymond Rehjmond,Rejmond,rymwnd,rymwnd mysysypy,Рејмонд,Рэймонд,ريموند,ریمنڈ، مسیسپی,ریموند، میسیسیپی US Mississippi Hinds County 32.25931 -90.4226 98 2225 America/Chicago populated place
5273414 Slades Corners US Wisconsin Kenosha County 42.58196 -88.29398 263 0 America/Chicago populated place
4408067 Scopus Scopus,Seopus US Missouri Bollinger County 37.39894 -89.92066 202 0 America/Chicago populated place
4871799 Pomeroy Pomerov,Pomeroy US Iowa Calhoun County 42.55109 -94.68387 378 625 America/Chicago populated place
4371184 The Meadows at Elk Creek US Maryland Cecil County 39.63067 -75.80299 20 0 America/New_York populated place
4085645 Redmont Park US Alabama Jefferson County 33.50316 -86.77527 296 0 America/Chicago populated place
4761114 Glenmere US Virginia Fairfax County 38.90011 -77.22137 140 0 America/New_York populated place
5250515 Devils Corner US Wisconsin Pepin County 44.5108 -92.13517 348 0 America/Chicago populated place
5030840 Howard Lake Mobile Home Park US Minnesota Wright County 45.05667 -94.07556 315 0 America/Chicago populated place
4459911 Cedar Rock Estates US North Carolina Caldwell County 35.96263 -81.43759 398 0 America/New_York populated place
5171499 Scotland US Ohio Geauga County 41.52255 -81.3615 344 0 America/New_York populated place
4799968 Braeholm Braeholm,Sherman US West Virginia Logan County 37.77511 -81.82151 263 0 America/New_York populated place
4294022 Hardcastle US Kentucky Warren County 36.94171 -86.32888 171 0 America/Chicago populated place
4286327 Burton US Kentucky Floyd County 37.35955 -82.72377 277 0 America/New_York populated place
5194704 Idaville Idaville,Whitestown US Pennsylvania Adams County 40.01481 -77.20276 245 177 America/New_York populated place
4447665 Swan Lake US Mississippi Tallahatchie County 33.87484 -90.28342 45 0 America/Chicago populated place
4952567 Tahanto Beach Tahanto,Tahanto Beach US Massachusetts Barnstable County 41.70011 -70.62031 4 0 America/New_York populated place
4459353 Carroll Carlton,Carroll US North Carolina Duplin County 34.95211 -78.0761 42 0 America/New_York populated place
5272285 Saxeville Saxeville,Saxville US Wisconsin Waushara County 44.17609 -89.11456 258 973 America/Chicago populated place
5179093 Barneston US Pennsylvania Chester County 40.10454 -75.80994 147 0 America/New_York populated place
4549834 Row US Oklahoma Delaware County 36.27869 -94.6905 351 0 America/Chicago populated place
5816302 Winesap Winesap,Winesap Siding US Washington Chelan County 47.75958 -120.20008 232 0 America/Los_Angeles populated place
4944558 Mount Auburn US Massachusetts Middlesex County 42.3751 -71.1495 10 0 America/New_York populated place
4231720 Wood Valley US Georgia Fulton County 34.14982 -84.31076 312 0 America/New_York populated place
5202424 Mount Zion US Pennsylvania Cumberland County 40.12926 -77.17415 166 0 America/New_York populated place
4176387 Venice Gardens US Florida Sarasota County 27.07311 -82.4076 3 7104 America/New_York populated place
4516087 La Grange La Grange,LaGrange,Lagrange US Ohio Lawrence County 38.57175 -82.6785 177 0 America/New_York populated place
5058322 Binford US North Dakota Griggs County 47.56194 -98.3451 465 174 America/Chicago populated place
4225118 Summertown US Georgia Emanuel County 32.74599 -82.27624 77 163 America/New_York populated place
4116918 Junction City US Arkansas Union County 33.01625 -92.72432 59 547 America/Chicago populated place
8503169 Athens US Kentucky Casey County 37.24844 -84.89067 263 0 America/New_York populated place
4578840 Forest Acres US South Carolina Oconee County 34.80759 -83.05348 320 0 America/New_York populated place
4131914 Spencer Place US Arkansas Lee County 34.78982 -90.59788 58 0 America/Chicago populated place
4452137 Aberdeen Aberdeen,Aberdin,Blue’s Crossing,Абердин US North Carolina Moore County 35.13155 -79.42948 105 7343 America/New_York populated place
5364079 La Quinta La Kinta,La Kuinta,la kvinta,la kwynta,la kwyynta kalyfrnya,Ла Кинта,Ла Куинта,لا كوينتا,لا کوئینتا، کالیفرنیا,لا کوینٹا، کیلیفورنیا,ला क्विन्टा US California Riverside County 33.66336 -116.31001 41 40476 America/Los_Angeles populated place
4445222 Saukum Ashley,Saukum US Mississippi Wilkinson County 31.23128 -91.18483 56 0 America/Chicago populated place
5738995 Maplewood US Oregon Multnomah County 45.46984 -122.7301 118 0 America/Los_Angeles populated place
4720922 Puerta Blanca Colonia Puerta Blanca Colonia,Puerta Blanca Subdivision Colonia,Tom Gill Road Colonia US Texas Hidalgo County 26.28229 -98.4403 67 0 America/Chicago populated place
4676987 Bryan Beach US Texas Brazoria County 28.88331 -95.37855 1 0 America/Chicago populated place

Unveiling the United States: A Geographer’s Passionate Journey Through Urban Landscapes and Data

The United States stands as a vast mosaic of cities, each one a vibrant node within a sprawling network of regions and administrative divisions. From the towering skyscrapers of New York City to the sun-drenched streets of San Diego, the urban fabric of this nation is as diverse as its geography. For a geographer, the true essence of understanding the United States lies not only in observing its grand scale but in dissecting the intricate details of its urban centers—specifically, through precise data that anchors each city in its unique regional and departmental context.

Navigating the Administrative Web: Regions and Departments

The U.S. is a federation composed of states, counties, and municipalities, each layer carrying distinct governance and cultural significance. Mapping every city to its respective state and county isn’t merely a bureaucratic exercise—it reveals how geography shapes policy, economics, and community life. This foundational understanding is critical for scholars, planners, and decision-makers who aim to grasp the spatial dynamics driving America’s growth and challenges.

Pinpointing Places: Latitude and Longitude Coordinates

Geographic accuracy breathes life into urban data. Knowing the latitude and longitude of each city enables more than just a point on a map—it opens doors to sophisticated spatial analysis and planning. Whether it’s modeling urban sprawl, disaster management, or infrastructure development, exact coordinates become the backbone of actionable geographic insight. Such precision supports integration with Geographic Information Systems (GIS) and facilitates real-world applications that benefit millions.

Excel at the Core: Emphasizing Usability and Access

In the realm of data dissemination, Excel (.xlsx) reigns supreme as an intuitive yet powerful tool. By prioritizing this format, the data becomes accessible to a broad spectrum of users—from students and researchers to government officials and business strategists. The ability to sort, filter, and visualize urban data in Excel empowers users to transform raw figures into meaningful narratives about the country’s urban evolution.

Versatile Formats for Diverse Needs: CSV, SQL, JSON, and XML

Beyond Excel, the inclusion of CSV, SQL, JSON, and XML formats ensures the dataset’s compatibility across various platforms and applications. Whether integrating with databases, powering web services, or feeding analytical software, these formats offer essential flexibility. This diversity supports a wide range of technical environments, encouraging innovative uses of urban geographic data.

Harnessing Data for Urban Understanding and Innovation

Comprehensive and organized data on American cities—linked with their administrative territories and precise coordinates—is more than information; it’s a catalyst for discovery and progress. In an era where urban centers face unprecedented pressures from population growth, climate change, and technological shifts, such a database equips professionals with the knowledge to design resilient, equitable, and efficient cities.

A Living Archive for Geographic Exploration

This collection transcends the static notion of data. It embodies a living archive, continuously relevant to anyone invested in the geographic and social fabric of the United States. Through its detailed structure and especially the Excel format’s accessibility, it invites exploration, fuels research, and supports the development of a deeper, more nuanced understanding of America’s multifaceted urban reality.

Download United_States cities in Excel SQL CSV JSON XML

Access detailed latitude and longitude data for cities in United States, now available in Excel (.xlsx) — plus CSV, SQL, XML, and JSON formats

List of countries :

download-cities-data.org