Canada cities list with latitude and longitude in CSV format

Canada
Canada
CSV, SQL, XML, JSON

Last update : 24 April 2024.

Country
Canada
Capitale
Ottawa
Number of cities
14924
Download

This is the best list of 14924 cities in the Canada available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Canada file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
6064638MakwaCASaskatchewan54.0002-108.918160America/Reginapopulated place
7302876Saint MargaretsCANew Brunswick46.90947-65.209010America/Monctonpopulated place
6071831Melanson SettlementCANew Brunswick46.08308-64.64380America/Monctonpopulated place
5943530Duff CornersCAOntarioHastings County44.39889-77.291390America/Torontopopulated place
6138319Saint-GrégoireCAQuebecCentre-du-Québec46.27226-72.510220America/Torontopopulated place
6138345Saint-HilaireCAQuebecMontérégie45.55838-73.197450America/Torontopopulated place
6621052PercePerce,Percé,Perse,XFG,ПерсеCAQuebecGaspésie-Îles-de-la-Madeleine48.48794-64.298520America/Torontopopulated place
6090000NorthfieldCANova Scotia45.25349-63.676380America/Halifaxpopulated place
6154118Spring CreekCAOntario45.96889-79.9350America/Torontopopulated place
5992059KimberleyKimberley,Kimberli,YQE,kymbyrly,Кимберли,Кімберлі,كيمبيرلي,کمبرلے، برٹش کولمبیاCABritish ColumbiaRegional District of East Kootenay49.67071-115.97767425America/Edmontonpopulated place
7870908DavenportCAOntario43.67107-79.437760America/Torontopopulated place
6053122LetangCANew Brunswick45.08097-66.834640America/Monctonpopulated place
5979033HyblaCAOntarioHastings County45.16417-77.848330America/Torontopopulated place
5919353Chaffeys LocksCAOntarioUnited Counties of Leeds and Grenville44.58083-76.317220America/Torontopopulated place
5936124Deadmans HarbourCANew Brunswick45.05285-66.767630America/Monctonpopulated place
5919677ChamplainCANew Brunswick45.1704-67.172580America/Monctonpopulated place
6176573WaskatenauCAAlberta54.11687-112.785270America/Edmontonpopulated place
6112385Potton SpringsCAQuebecEstrie45.14393-72.362610America/Torontopopulated place
6137982Sainte-Marguerite-du-Lac-MassonCAQuebecLaurentides46.03338-74.06590America/Torontopopulated place
6178049WemyssCAOntarioLanark County44.87-76.385830America/Torontopopulated place
6152249South Ingonish HarbourCANova Scotia46.62965-60.437620America/Halifaxpopulated place
6099733PattonCAOntario46.29402-83.178340America/Torontopopulated place
5970964HargraveCAManitoba49.9172-101.072830America/Winnipegpopulated place
6174923Wade’s LandingCAOntarioParry Sound District46.11823-79.528350America/Torontopopulated place
6139830Salt SpringsCANova Scotia45.5855-62.008520America/Halifaxpopulated place
5925267ColinetCANewfoundland and Labrador47.2166-53.54810America/St_Johnspopulated place
6185591York MillsCANew Brunswick45.66897-67.092960America/Monctonpopulated place
5938855DewdneyCABritish Columbia49.16667-122.20America/Vancouverpopulated place
6137671Saint-DenisCAQuebecMontérégie45.78288-73.159750America/Torontopopulated place
11820688MarkervilleCAAlbertaRed Deer County52.12399-114.170142America/Edmontonpopulated place
5967682GuiguesCAQuebecAbitibi-Témiscamingue47.46455-79.438560America/Torontopopulated place
5962627Golden LakeCAOntarioRenfrew County45.58342-77.232760America/Torontopopulated place
5941300Domaine-OuelletCAQuebecMauricie46.49864-72.914850America/Torontopopulated place
6128702RoxvilleCANova Scotia44.60746-65.866460America/Halifaxpopulated place
5973052Healey FallsCAOntario44.37876-77.786890America/Torontopopulated place
6087777New SudburyCAOntario46.52459-80.958830America/Torontopopulated place
6138568Saint-Joseph-des-MontsCAQuebecGaspésie-Îles-de-la-Madeleine49.03005-66.470790America/Torontopopulated place
5917172Carleys CornerCAOntario44.86513-75.808640America/Torontopopulated place
5899537Big Bay PointCAOntario44.4-79.516940America/Torontopopulated place
6069228McDonald CornerCANew Brunswick45.78351-66.00320America/Monctonpopulated place
5919305CeylonCASaskatchewan49.45007-104.601070America/Reginapopulated place
6118167Red Deer HillCASaskatchewan53.01678-105.801060America/Reginapopulated place
6147213ShulieCANova Scotia45.59963-64.57110America/Halifaxpopulated place
6142338Schyan PointCAQuebecOutaouais46.09694-77.436110America/Torontopopulated place
6172147Upper BlackvilleCANew Brunswick46.65011-65.865470America/Monctonpopulated place
6049372L’Ange-GardienCAOntarioComtés unis de Prescott et Russell45.59278-74.768060America/Torontopopulated place
6152163SouthgateCAOntarioMiddlesex County43.12462-81.366140America/Torontopopulated place
5885410Annandale-Little Pond-Howe BayCAPrince Edward Island46.3001-62.415330America/Halifaxpopulated place
6092896Okanagan MissionCABritish ColumbiaRegional District of Central Okanagan49.81667-119.483330America/Vancouverpopulated place
6146480Shining TreeCAOntario47.55833-81.261110America/Torontopopulated place
5907104BrackenCASaskatchewan49.18333-108.101340America/Reginapopulated place
6160074Sutton BayCAOntarioTimiskaming District47.56705-79.594950America/Torontopopulated place
11126061ElkwaterCAAlberta49.66196-110.281020America/Edmontonpopulated place
6156831Stirling FallsCAOntarioParry Sound District45.68761-79.445280America/Torontopopulated place
5935388DaveluyvilleCAQuebecCentre-du-Québec46.20006-72.132391318America/Torontopopulated place
5995269LacadenaCASaskatchewan50.95005-108.334030America/Reginapopulated place
5925990Collins BayCAOntario44.24572-76.612950America/Torontopopulated place
5956860Fox CreekCANew Brunswick46.05822-64.697080America/Monctonpopulated place
6052230Le Mont-LucCAQuebecOutaouais45.49449-75.721060America/Torontopopulated place
8593825LysterCAQuebecCentre-du-Québec46.36873-71.612660America/Torontopopulated place
6185778YouvilleCAQuebecMontréal45.54865-73.644030America/Torontopopulated place
12096561ManuelsCANew BrunswickNorthumberland County47.03535-64.986910America/Monctonpopulated place
5894555Base Line RoadCANova Scotia45.1378-64.752440America/Halifaxpopulated place
6093761OnanoleCAManitoba50.62252-99.968930America/Winnipegpopulated place
6160070SuttonSuttonCAQuebecMontérégie45.10008-72.615823906America/Torontopopulated place
6167828TorbrookCANova Scotia44.91401-64.977330America/Halifaxpopulated place
5991556Key JunctionCAOntario45.98338-80.716410America/Torontopopulated place
6167890TorranceCAOntarioDistrict Municipality of Muskoka45.0001-79.566340America/Torontopopulated place
5977040Hornell HeightsCAOntario46.35832-79.413460America/Torontopopulated place
6164084The JunctionWest TorontoCAOntario43.66328-79.466170America/Torontopopulated place
6179555WestviewCAOntario44.34389-77.908060America/Torontopopulated place
12096440Martin SidingCANew BrunswickMadawaska County47.09422-67.842750America/Monctonpopulated place
6111972Port NelsonCAOntario43.345-79.769440America/Torontopopulated place
6053216LevackCAOntario46.63338-81.383070America/Torontopopulated place
6094367OrloCAQuebecOutaouais46.20611-76.041110America/Torontopopulated place
6150331Smooth TownCAOntario43.03222-80.074170America/Torontopopulated place
5949074EntrelacsCAQuebecLanaudière46.11678-73.99920America/Torontopopulated place
5896231Bear River EastCANova Scotia44.60192-65.591720America/Halifaxpopulated place
5887093Armstrong MillsCAOntarioWellington County43.62917-80.261390America/Torontopopulated place
5919815Channel-Port aux BasquesChannel-Port-aux-Basques,Port aux BasquesCANewfoundland and Labrador47.57286-59.138084220America/St_Johnspopulated place
6118823Reeces CornersCAOntario42.97992-82.117650America/Torontopopulated place
6138241Saint-François-du-Lacsn-franswa-dw-lak kbk,سن-فرانسوا-دو-لاک، کبک,سینٹ-فرانکوئس-دو-لاک، کیوبکCAQuebecCentre-du-Québec46.0637-72.819060America/Torontopopulated place
5915182CanwoodCASaskatchewan53.3668-106.601110America/Reginapopulated place
7871318The PeanutCAOntario43.78293-79.350990America/Torontopopulated place
5946143East SpringbankCAAlberta51.04167-114.208330America/Edmontonpopulated place
5883302AldergroveCAAlberta53.51667-113.501390America/Edmontonpopulated place
5886564Arbor VitaeCAOntario48.89791-94.294340America/Winnipegpopulated place
7871305DownsviewCAOntario43.73203-79.493980America/Torontopopulated place
12096851Saint-Martin-de-RestigoucheCANew BrunswickRestigouche47.56757-67.336850America/Monctonpopulated place
6111345Portage-du-CapCAQuebecGaspésie-Îles-de-la-Madeleine47.24229-61.897620America/Halifaxpopulated place
5954897FloridaCAOntario49.10261-80.844160America/Torontopopulated place
6172009UnityCASaskatchewan52.45014-109.168162475America/Reginapopulated place
6087581New GlasgowCAQuebecLaurentides45.83476-73.877370America/Torontopopulated place
6094512Osborne HarbourCANova Scotia43.71588-65.108420America/Halifaxpopulated place
5935303DashwoodCABritish Columbia49.36633-124.51947982America/Vancouverpopulated place
5896967BeaverleyCABritish Columbia53.81659-122.886310America/Vancouverpopulated place
5913908Cameron SettlementCANova Scotia45.28411-62.493610America/Halifaxpopulated place
6067346MarydaleCANova Scotia45.53419-61.861350America/Halifaxpopulated place
6152270South JunctionCAManitoba49.04057-95.766140America/Winnipegpopulated place
7870913Junction TriangleCAOntario43.66033-79.447630America/Torontopopulated place

FaQ about Canada


Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.