World Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML
Last update : 22 March 2026.
>> DOWNLOAD AN ARCHIVE CONTAINING A SAMPLE <<
Explore the World through Data: A Comprehensive Database of Cities on the Planet
Welcome to a new geographic journey! Whether you are a researcher, developer, urbanist or simply a lover of geography, this global database of cities is designed to save you precious time while providing you with an incomparable wealth of information.
Cities, coordinates and more
Imagine a living map, not in pixels but in actionable data. What you have here is a structured collection of **several tens of thousands of cities around the world**, each with:
- The **city name** (in a standardized format)
- Its precise **latitude and longitude**, ideal for mapping and GIS projects
- The **sub-region** (e.g. Western Europe, Southeast Asia)
- The **region** (e.g. Europe, Africa, Americas)
These data are organized with care, thoroughness and a deeply geographical vision. They make it possible to reconstruct entire atlases, to cross socio-spatial variables, or to supply client databases, internal search engines or geolocation systems.
5 formats to adapt to all uses
Because a single file may not be suitable for all trades, each pack is downloadable in **5 universal formats:
- **Excel (.xlsx)**: perfect for analysts and spreadsheets
- **CSV**: raw, simple, compatible with almost everything
- **JSON**: structured, ideal for web developers and APIs
- **SQL**: ready to be injected into a relational database
- **XML**: for custom integrations or more complex technical environments
The data structure remains uniform, clean and well-structured regardless of format. This is not a generic export, but a thorough, well thought out and documented work.
A global, up-to-date and reliable resource
As a geographer, I know how rare it is to come across bases that are both **comprehensive, geographically balanced***, and **technically well thought out**. This project was designed to solve exactly this problem. Whether you need world capitals, small coastal towns or growing African metropolises, you will find what you need.
Sources are crossed, cleaned, checked. City names are deduplicated and associated with the most accurate GPS coordinates available.
Why is this database unique?
- 🌍 **Global coverage without compromise
- 📐 **Geographical classification by region/sub-region according to international standards
- 🧩 **Ready-to-use multi-purpose formats
- 🗺️ **Perfect for visualizations, dashboards or geocoding algorithms
Real-world applications
- Include a smart city field in a registration form
- Create an interactive map on your website
- Analyze urban density by region of the world
- Generate commercial or logistics clusters
- Automate the enrichment of customer profiles with GPS coordinates
Download the world cities database today and give your projects a geographic dimension. Because, at the end of the day, understanding the world also means knowing where everything starts: a city, a point on the map... and a coordinate.