Finland cities list with latitude and longitude in Excel, CSV, SQL, XML, JSON formats

Finland
Finland
Excel, CSV, SQL, XML, JSON

Last update : 22 January 2026.

Country
Finland
Capital
Helsinki
Number of cities
13351
Download
Click here

This is the best list of 13351 cities in the Finland available in 5 formats ( Excel, CSV, JSON, SQL, XML ). You will find only data associated with the cities of a country (capital, towns and villages). There is no information concerning the environment, such as the location of a river or a mountain, for example. All cities are 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 Finland file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
646149Metsä-KansolaFISouth KareliaLappeenranta60.9924828.465330Europe/Helsinkipopulated place
635174TaipaleFIKanta-HämeForssa60.8895823.346380Europe/Helsinkipopulated place
643169PaiholaFINorth KareliaJoensuu62.6877129.924170Europe/Helsinkipopulated place
639131RiutulaRiutula,RivdulFILaplandPohjois-Lappi68.9427226.805230Europe/Helsinkipopulated place
644751NiinikumpuFINorth KareliaKeski-Karjala62.06667300Europe/Helsinkipopulated place
650473KullaFIUusimaaRaaseporin60.0853223.362670Europe/Helsinkipopulated place
653177KerisaloKerisalo,КерисалоFINorth SavoVarkaus62.1012227.963370Europe/Helsinkipopulated place
637747SantamäkiFIKanta-HämeRiihimäki60.7333324.60Europe/Helsinkipopulated place
634760TeiskoFIPirkanmaaTampere61.6739923.84840Europe/Helsinkipopulated place
652612KiteenlahtiFINorth KareliaKeski-Karjala62.0680730.258140Europe/Helsinkipopulated place
842028KarvettiFISouthwest FinlandTurku60.4779522.050180Europe/Helsinkipopulated place
852947LepäinenFISouthwest FinlandVakka-Suomi60.8145721.27720Europe/Helsinkipopulated place
652773KimonkyläKimobole,Kimoböle,Kimonkjulja,Kimonkyla,КимонкюляFIUusimaaLoviisa60.7066326.304380Europe/Helsinkipopulated place
660086EtukyläFIKymenlaaksoKotka-Hamina60.4524626.892990Europe/Helsinkipopulated place
12364730HeinäsuoHeinasuo,HeinäsuoFISouthwest Finland60.3110123.336730Europe/Helsinkipopulated place
847348HämevaaraTavastbergaFIUusimaaHelsinki60.2484224.807640Europe/Helsinkipopulated place
635138TaivalmäkiFISouth OstrobothniaSeinäjoki62.4833322.90Europe/Helsinkipopulated place
10101265LamminkulmaLamminkulmaFISatakuntaRauma60.9481322.031060Europe/Helsinkipopulated place
842074NorrändanFIOstrobothniaSydösterbotten62.1340921.366020Europe/Helsinkipopulated place
656737IlmapohjaIlmapohja,Ilmojarvi,IlmojärviFICentral FinlandJyväskylä62.1333325.850Europe/Helsinkipopulated place
637854SammaljokiFIPirkanmaaLounais-Pirkanmaa61.2318823.130950Europe/Helsinkipopulated place
10101695DalasDalasFIOstrobothniaSydösterbotten62.66921.232570Europe/Helsinkipopulated place
642945PallolanmäkiFISouth SavoPieksämäki62.1224527.589270Europe/Helsinkipopulated place
650892KouraniemiFIPirkanmaaLounais-Pirkanmaa61.5297522.754040Europe/Helsinkipopulated place
631101VuorimäkiFINorth SavoYlä-Savo63.535627.748290Europe/Helsinkipopulated place
647483LukkoFIUusimaaHelsinki60.6854925.263330Europe/Helsinkipopulated place
639743RauhalaFINorth KareliaJoensuu62.5833328.550Europe/Helsinkipopulated place
632788ValamaFINorth KareliaPielisen Karjala63.6833330.033330Europe/Helsinkipopulated place
645600MurtoniemiFIKainuuKajaani64.0528.40Europe/Helsinkipopulated place
642926PaloFINorth OstrobothniaRaahe64.5833324.60Europe/Helsinkipopulated place
854850UhluFISouthwest FinlandTurku60.6090921.903490Europe/Helsinkipopulated place
644595NiskakangasFINorth OstrobothniaYlivieska64.0557624.224610Europe/Helsinkipopulated place
843802KeskikyläFINorth OstrobothniaOulu65.016624.741790Europe/Helsinkipopulated place
632755VälikyläFINorth OstrobothniaNivala-Haapajärvi63.9666724.766670Europe/Helsinkipopulated place
635297SyvälänkyläFIPirkanmaaTampere61.8488423.723650Europe/Helsinkipopulated place
847480KrapiFIUusimaaHelsinki60.4204625.047090Europe/Helsinkipopulated place
639103RoikansaariFINorth SavoKuopio62.8333328.050Europe/Helsinkipopulated place
12225817KermaFINorth KareliaJoensuu62.3938128.758670Europe/Helsinkipopulated place
633983TroihariFISouth OstrobothniaSeinäjoki63.0325622.665790Europe/Helsinkipopulated place
651092KoskenvarsiFISouth OstrobothniaJärviseutu62.982123.742880Europe/Helsinkipopulated place
661637AkkalaFISouth KareliaImatra61.4471828.544030Europe/Helsinkipopulated place
639920RantalaFIKainuuKajaani64.0666728.116670Europe/Helsinkipopulated place
662100AaljokiFISouthwest FinlandSalo60.2609823.263680Europe/Helsinkipopulated place
644367NorrnäsFIOstrobothniaSydösterbotten62.5788421.230950Europe/Helsinkipopulated place
641416PirttimäkiFINorth SavoYlä-Savo63.9732426.644680Europe/Helsinkipopulated place
640384PyhtääPjukhtjaa,Pyhtaeae,Pyhtaeae vald,Pyhtää,Pyhtää vald,Pyttis,pi he tai,Пюхтяа,皮赫泰FIKymenlaaksoKotka-Hamina60.4934926.543464964Europe/Helsinkipopulated place
647526LöyäFISouth OstrobothniaKuusiokunnat62.7521223.762230Europe/Helsinkipopulated place
644725NiinivaaraNiinivaara,Nijnivara,НийнивараFINorth SavoKoillis-Savo63.0048328.87180Europe/Helsinkipopulated place
645127NalkkilaFIUusimaaPorvoo60.5425625.580920Europe/Helsinkipopulated place
650833KoveroKoverolaFISouthwest FinlandVakka-Suomi60.8498421.750870Europe/Helsinkipopulated place
655609JouhtiskyläFICentral FinlandÄänekoski62.6858526.143080Europe/Helsinkipopulated place
636665SitlahtiSitlahti,SittlaxFISatakuntaRauma61.3521.666670Europe/Helsinkipopulated place
649947KuuksoFIPaijat-HameLahti60.8312226.458550Europe/Helsinkipopulated place
651757KomisuoFISouthwest FinlandSalo60.4584223.583420Europe/Helsinkipopulated place
650056KurkiperäFISouth OstrobothniaJärviseutu62.8493824.025030Europe/Helsinkipopulated place
7871162KilpakorpiFICentral FinlandJämsä61.8474725.14270Europe/Helsinkipopulated place
644684NikkariFINorth OstrobothniaYlivieska64.1859224.759580Europe/Helsinkipopulated place
654362KankaanpääFIPirkanmaaYlä-Pirkanmaa62.1248624.598510Europe/Helsinkipopulated place
852767VälimetsäFISouthwest FinlandVakka-Suomi60.8915521.709610Europe/Helsinkipopulated place
657255HuhkaankyläHuhkainkyla,Huhkainkylä,HuhkajaFIPirkanmaaTampere61.6770323.543460Europe/Helsinkipopulated place
643546ÖsterretaisFISouthwest FinlandÅboland-Turunmaa60.1759121.669860Europe/Helsinkipopulated place
654163KarhilaFICentral FinlandKeuruu62.501324.807830Europe/Helsinkipopulated place
10101727SödersundSoedersund,SödersundFIOstrobothniaVaasa63.0284821.555910Europe/Helsinkipopulated place
655938JärvensivuFIPirkanmaaTampere61.7833323.966670Europe/Helsinkipopulated place
661462AlapääFINorth OstrobothniaYlivieska64.0991824.179030Europe/Helsinkipopulated place
661126AntilaFISatakuntaPohjois-Satakunta61.9564422.209540Europe/Helsinkipopulated place
841966KohmoKohmoFISouthwest FinlandTurku60.4610522.341250Europe/Helsinkipopulated place
647762LohilampiFIUusimaaHelsinki60.2964823.80520Europe/Helsinkipopulated place
650276KuohenmaaKuohenmaa,Kuokhenma,КуохенмаFIPirkanmaaTampere61.3613324.049310Europe/Helsinkipopulated place
637638SärkijärviFIUusimaaHelsinki60.2166723.70Europe/Helsinkipopulated place
645279MyllylehtoFINorth SavoYlä-Savo63.6833326.766670Europe/Helsinkipopulated place
842352HenobackenFIOstrobothniaVaasa62.7151521.279270Europe/Helsinkipopulated place
657789HirsikangasFINorth SavoYlä-Savo63.3333326.40Europe/Helsinkipopulated place
634317AkaaAckas,AkaaFIPirkanmaaEtelä-Pirkanmaa61.1666723.866678258Europe/Helsinkipopulated place
642348PeloFIOstrobothniaJakobstadsregionen63.722123.327570Europe/Helsinkipopulated place
644822NiemiFISouth SavoMikkeli61.6527.516670Europe/Helsinkipopulated place
647149MäättäläMaatala,Maattala,Määtalä,Määttälä,Naattala,NäättäläFIKainuuKehys-Kainuu64.0666730.050Europe/Helsinkipopulated place
655752JokelaFINorth OstrobothniaNivala-Haapajärvi63.6333326.066670Europe/Helsinkipopulated place
842449KallkärrFIOstrobothniaVaasa62.8378721.456780Europe/Helsinkipopulated place
650273KuohijokiKuohijoki,Kuokhijoki,КуохийокиFIPirkanmaaTampere61.3017724.804440Europe/Helsinkipopulated place
656670RautioFISouth KareliaImatra61.2381228.876190Europe/Helsinkipopulated place
633518TyyneläFINorth OstrobothniaKoillismaa65.9666729.933330Europe/Helsinkipopulated place
640035RajavaaraFINorth KareliaJoensuu62.6095531.244790Europe/Helsinkipopulated place
633344UrajärviUrajaervi,Urajarvi,Urajärvi,УраярвиFIPaijat-HameLahti61.1333325.783330Europe/Helsinkipopulated place
7871201MyllymaaFIPirkanmaaTampere61.6711424.05920Europe/Helsinkipopulated place
654026KarjalaFIKainuuKajaani64.18333270Europe/Helsinkipopulated place
654530KälviäläFISouth KareliaLappeenranta60.8666728.150Europe/Helsinkipopulated place
644138NuutajärviFIPirkanmaaEtelä-Pirkanmaa61.0422923.429990Europe/Helsinkipopulated place
634784TeerirantaTeeriranta,Teriranta,ТерирантаFINorth OstrobothniaKoillismaa65.5186129.541830Europe/Helsinkipopulated place
652408KivikyläFISatakuntaRauma61.1143321.798750Europe/Helsinkipopulated place
630904YlikyläFISouthwest FinlandTurku60.2864821.931340Europe/Helsinkipopulated place
638779RuolahtiFIPirkanmaaTampere61.4533523.271190Europe/Helsinkipopulated place
854498TakalaFISouthwest FinlandVakka-Suomi60.6334621.684190Europe/Helsinkipopulated place
640520PuujaaPuujaa,PuujasFIKanta-HämeRiihimäki60.8174124.936580Europe/Helsinkipopulated place
645897MolkojärviMolkojaervi,Molkojarvi,Molkojärvi,МолкоярвиFILaplandTunturi-Lappi67.2890425.263030Europe/Helsinkipopulated place
658685HattusaariFINorth KareliaPielisen Karjala63.2139229.72690Europe/Helsinkipopulated place
631385VirpeläFIKainuuKajaani64.427.466670Europe/Helsinkipopulated place
634359TjärlaxFIOstrobothniaSydösterbotten62.4692621.253140Europe/Helsinkipopulated place
633986TräskvikFIOstrobothniaSydösterbotten62.1802521.511130Europe/Helsinkipopulated place
642713PankalahtiFISouth SavoMikkeli61.3191926.599270Europe/Helsinkipopulated place

Finland: A Geographer's Insight into the Land of Lakes and Forests

The Geography of Finland: A Land of Extremes

Finland, located in Northern Europe, is a land of stunning contrasts. Known for its vast forests, pristine lakes, and the magical beauty of the Arctic Circle, Finland’s geography is as diverse as it is unique. The country shares borders with Sweden to the west, Russia to the east, and Norway to the north, while its southern border is washed by the Gulf of Finland. This positioning places Finland at the crossroads of European and Arctic climates, making its geography particularly intriguing for study.

Finland's terrain is largely shaped by its glacial past, with numerous lakes, rivers, and dense forests spreading across the country. Roughly 70% of Finland is forested, and the country is home to over 188,000 lakes, earning it the title "Land of a Thousand Lakes," though in reality, the number is far higher. The northern part of the country extends into the Arctic, offering unique landscapes like tundra and mountain ranges. These diverse terrains provide geographers with a wealth of natural features to study, making Finland a fascinating subject for geographical research.

Regions of Finland: Understanding the Structure

Finland is divided into 19 regions, each with distinct geographic and cultural characteristics. From the bustling urban areas of southern Finland to the remote, serene landscapes of Lapland in the north, each region offers a unique perspective on the country’s diversity. Major cities like Helsinki, Tampere, and Turku are situated in the southern part of the country, where the population density is highest. These urban areas are hubs of commerce, culture, and innovation, while the northern regions are sparsely populated but rich in natural beauty and resources.

For geographers, one of the most exciting aspects of Finland’s regions is the interplay between urban and rural areas. The southern regions, with their well-developed infrastructure and bustling cities, are in stark contrast to the rural, tranquil landscapes of the north. Understanding this regional division is key to comprehending the country’s economic and social structures.

The Importance of City Data in Finland

A deeper dive into Finland’s geography requires a more detailed look at its cities and towns. With over 300 municipalities spread across the country, each city has its own story to tell. The regions and departments within each city play an important role in shaping its identity, governance, and interaction with neighboring areas. For example, Helsinki, the capital, is not only the political and cultural center of Finland, but it also serves as an economic powerhouse, influencing both the southern regions and the country as a whole.

However, to truly grasp the geographical layout of Finland, it’s crucial to obtain data on its cities, regions, and departments. Detailed geographical data, including the latitude and longitude of each city, provides an essential tool for understanding Finland’s spatial distribution. Whether you are studying urbanization patterns, transportation networks, or climate variations, knowing the precise coordinates and regional divisions of each city is key to building a comprehensive geographical model of the country.

Unlocking the Potential of Finland's City Data

The potential of city-level data in Finland extends far beyond simple mapping. By obtaining data on cities, regions, and departments, researchers can track demographic shifts, evaluate environmental impacts, and forecast regional developments with greater precision. Geographical data, such as latitude and longitude, becomes a powerful tool in visualizing spatial relationships, helping to predict trends in population growth, infrastructure development, and regional climate change.

For geographers and researchers, having access to a comprehensive database of Finnish cities is invaluable. It allows for detailed spatial analysis, contributing to a deeper understanding of the geographical dynamics that shape the country. From the temperate southern regions to the Arctic tundra of the north, this data helps geographers draw meaningful connections between urban and rural spaces, fostering a more nuanced appreciation of Finland’s geography.

Data-Driven Exploration of Finland’s Geography

As Finland continues to evolve, understanding the geography of its cities becomes even more crucial. From the lakes and forests to the modern urban landscapes, each region offers its own set of challenges and opportunities. With access to detailed data on Finland’s cities—including their regions, departments, and geographical coordinates—you gain the ability to explore these dynamics in a way that was previously not possible.

Incorporating precise city data into geographical studies enables geographers, urban planners, and researchers to make informed decisions. Whether examining the effects of climate change, analyzing population density, or planning future urban development, the ability to access accurate geographical coordinates and regional information transforms the study of Finland from a static map into a dynamic, evolving field of exploration.

The Power of Geographic Data for Understanding Finland

For anyone looking to delve deeper into Finland's geographic makeup, obtaining data on its cities and regions is crucial. From urban areas like Helsinki to the far reaches of Lapland, every city’s location and characteristics tell a unique story. By leveraging this data—especially geographic coordinates like latitude and longitude—you can gain a clearer understanding of how Finland's cities interact with their surrounding regions, uncovering hidden patterns and connections that inform everything from urban planning to environmental conservation.

With the right data, Finland's geography can be understood not only in terms of its physical features but also through the complex web of relationships between cities, regions, and departments. This makes Finland an ideal case study for geographers seeking to explore the intersection of urbanization, regional diversity, and environmental change.

FaQ about Finland

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 5 Excel, 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 .zip archive containing the country files in Excel, 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.
Yes! We have recently updated our data packs and included the Excel (.xlsx) format, the latest Excel format. Take advantage now of 5 formats instead of 4 at no extra cost!

List of countries :

h2020-flow.eu

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