Firstly World cities database in Excel is a simple but accurate and up-to-date Excel database of the world’s cities, town and villages.
Secondly the database is constantly refreshing information so you are getting up-to-date information that includes over 4,5 million unique cities and towns from every country in the world.
Above all World cities database in Excel contains latitude and longitude coordinates, location names and short description in Excel spreadsheet, that allows you to filter, sort and maintain data easily, instead of digging piles of files.
Last map updates - 19 January 2023
List of countries with full data - is on left sidebar of the screen
ZOOM: mouse scroll | DRAG: SHIFT + Left mouse button | TOOLTIP: mouse hover | UNSELECT: click on empty space on the map
RESTORE VIEW: "home" icon on the left top corner | SPEED UP: select only one country/region at a time (where applicable)
for faster map loading - browse on desktop
All world countries with cities and villages by Latitude & Longitude.
Excel contains latitude and longitude coordinates, location names and short description in Excel spreadsheet, that allows you to filter, sort and maintain data easily, instead of digging piles of files. the database is constantly refreshing information so you are getting up-to-date information and is available for download after purchase. Once payment is done you will receive an e-mail with a link to download data file in Excel format. Here you can get your map of the country that can be easily visualized later in any preferable software. You will also be able convert the data of
All world countries with cities and villages by Latitude & Longitude
to other formats like CSV, xml and others. So please do check options of the maps below. Please select only one, because "full" map already contains all data from "basic" one. Once you purchase the map, you will get an e-mail with the link to download the map. Please, leave your comment in the Reviews tab of the selected map, it is very important for us to understand if everything was right. If you need customized data, with selected information - do let us know, we'll try to make it. Also please check carefully the demo-maps that are displayed before purchasing.
– you will get basic data of all 196 countries.
– additionally, you’ll receive a separate file with summary information of each country: capital, area in sq km, population, top-level domain, currency, phone code, languages.
Excel (made in v.2013)
Due to limitations of the Excel, all countries are devided alphabetically into 5 separate excel files (archived with free software 7-Zip)
File size 200MB, please have stable internet connection during downloading (at any case, please email: email@example.com)
- country name
- names of cities and villages in international ASCII format
payment with credit card (via Stripe) is available on checkout page
- you may need to check your spam folder
- the email will be titled "Cities by Latitude & Longitude"
- on the "Download" cell will be a link to download your Excel file. For some countries - there will be archive file due to big amount of data
- you can download the file from the same link endless times for half a year (180 days)
Those who got World cities Latitude and Longitude map they will get Excel with main information:
- country name, cities and villages names (in international ASCII format), latitude and longitude.
- they will get another file that sums up basic information of each country (currency, language, phone code, etc.)
Those who got specific country will get full information:
- besides cities and villages, file contains other places like: lakes, rivers, some buildings, parks, other populated places.
- some countries has additional information about region/province the location belongs (like it's done for Indonesia - see the last column in the screenshot below). Please check an interactive map of the your country to check if it has such info. If you need such column, but your needed country doesn't have such - send us a message and we will try our best to make it.
For example, you need to add information of postal codes, or you need locations devided into provinces/regions/areas - this we can discuss and do for you.
If poor internet is not your case, but you still can't download - send us a message and we will find a solution (another link to download or will send the file directly to your email)
- your link is valid for unlimited times of downloads for half a year (180 days)
- so in case of any updates on our database within 180 days from your purchase date - you can download them using the same link absolutely for free