Spain cities list with latitude and longitude in CSV format

Spain
Spain
CSV, SQL, XML, JSON

Last update : 24 April 2024.

Country
Spain
Capitale
Madrid
Number of cities
22946
Download

This is the best list of 22946 cities in the Spain 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 Spain file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
3105043Villar de los PisonesVillar de los PisonesESCastille and LeónProvincia de Zamora42.0725-6.511240Europe/Madridpopulated place
3118915LasiesoESAragonProvincia de Huesca42.42314-0.437480Europe/Madridpopulated place
3119041Las AlboredasLas Albaredas,Las AlboredasESValenciaProvíncia de Castelló40.533-0.295750Europe/Madridpopulated place
3128175BermelloESGaliciaProvincia da Coruña43.1401-8.928380Europe/Madridpopulated place
3114974OreitiaOreitiaESBasque CountryAraba / Álava42.85666-2.559040Europe/Madridpopulated place
3118371LineresESAsturiasProvince of Asturias43.43159-5.872470Europe/Madridpopulated place
8504772MadariaESBasque CountryAraba / Álava43.0448-3.082560Europe/Madridpopulated place
2515340Las LagunetasESCanary IslandsProvincia de Santa Cruz de Tenerife28.31667-16.783330Atlantic/Canarypopulated place
3118462LiberLiber,San RemigioESGaliciaProvincia de Lugo42.86443-7.093530Europe/Madridpopulated place
3125278CésarCesar,César,Santa Maria,Santa MaríaESGaliciaProvincia da Coruña42.96667-8.416670Europe/Madridpopulated place
3126907CamasobresCamasobresESCastille and LeónProvincia de Palencia43.01541-4.488220Europe/Madridpopulated place
3117244Masía de VisenMas de Visen,Masia de Visen,Masía de VisenESValenciaProvíncia de Castelló40.25-0.233330Europe/Madridpopulated place
3107624TrabazosESGaliciaProvincia de Ourense42.28195-7.186620Europe/Madridpopulated place
2515865La IglesiaCortijada La Iglesia,La IglesiaESAndalusiaProvincia de Jaén37.82497-3.890830Europe/Madridpopulated place
2515895La HerreraLa HerreraESAndalusiaProvincia de Jaén38.2-2.916670Europe/Madridpopulated place
2521066BenimametBenimametESValenciaProvíncia de València39.5-0.416670Europe/Madridpopulated place
3116467MoñíoESAsturiasProvince of Asturias43.38927-5.313610Europe/Madridpopulated place
3128278BenesoESGaliciaProvincia da Coruña42.75-8.95112Europe/Madridpopulated place
2513863Mina San MiguelESAndalusiaProvincia de Sevilla37.88333-60Europe/Madridpopulated place
3124347CousoCouzoESGaliciaProvincia da Coruña42.51975-9.037280Europe/Madridpopulated place
3126743Camporredondo de AlbaCamporredonde,Camporredondo,Camporredondo de AlbaESCastille and LeónProvincia de Palencia42.89572-4.74630Europe/Madridpopulated place
12156674San Miguel de BarcalaESGaliciaProvincia de Pontevedra42.73416-8.597580Europe/Madridpopulated place
3118931Las FraguasLas FraguasESCastille and LeónProvincia de Soria41.69491-2.717740Europe/Madridpopulated place
3110824San BlasBarrio de San Blas,San BlasESAragonProvincia de Teruel40.36016-1.178680Europe/Madridpopulated place
3109253SegovielaSegovielaESCastille and LeónProvincia de Soria41.92444-2.416660Europe/Madridpopulated place
2520009Casa de MeginaCasa de Megina,Casa de MejinaESAndalusiaProvincia de Sevilla37.38333-6.10Europe/Madridpopulated place
11280835Barrio Los MenoresESCanary IslandsProvincia de Santa Cruz de Tenerife28.14103-16.755740Atlantic/Canarypopulated place
2565081La MedianaESAndalusiaProvincia de Huelva37.13673-6.616370Europe/Madridpopulated place
2511633SabioteSabioteESAndalusiaProvincia de Jaén38.06916-3.314483958Europe/Madridpopulated place
3128681BarjaESGaliciaProvincia de Lugo42.48333-7.233330Europe/Madridpopulated place
3105787VilelaSanta Maria,Santa María,VilelaESGaliciaProvincia de Ourense42.38333-8.016670Europe/Madridpopulated place
3123029EscaleraEscaleraESCastille-La ManchaProvincia de Guadalajara40.77041-2.026950Europe/Madridpopulated place
3113411PiñuelPinuel,PiñuelESCastille and LeónProvincia de Zamora41.34923-6.018070Europe/Madridpopulated place
3106287Vega de RiacosVega de RiacosESCastille and LeónProvincia de Palencia42.75464-4.675394Europe/Madridpopulated place
2516815Hambre VivaCasas Hambre Gorda,Caserio Hambre Viva,Caserío Hambre Viva,Hambre VivaESMurciaMurcia37.96094-0.971750Europe/Madridpopulated place
3129908AraduengaESCastille and LeónProvincia de Burgos43.09647-3.171620Europe/Madridpopulated place
3115831MuroMuro,San JuanESGaliciaProvincia de Lugo42.85-7.40Europe/Madridpopulated place
6461763Vinya GranVinya GranESCataloniaProvíncia de Girona42.296942.950790Europe/Madridpopulated place
3118844Las SalinasCaserio de las Salinas,Caserío de las Salinas,Las SalinasESCastille and LeónProvincia de Valladolid41.26873-4.931790Europe/Madridpopulated place
3105934ViladamatViladamatESCataloniaProvíncia de Girona42.132993.075550Europe/Madridpopulated place
3117141MatienaMatiana,MatienaESBasque CountryBizkaia43.16667-2.60Europe/Madridpopulated place
3119655La GranadaLa GranadaESCataloniaProvíncia de Barcelona41.378161.719021566Europe/Madridpopulated place
3111921RevillaESCantabriaProvincia de Cantabria43.40642-3.866160Europe/Madridpopulated place
3128120BerrocalilloBerrocalillo,Caserio Berrocalillo,Caserío BerrocalilloESExtremaduraProvincia de Cáceres40.03532-6.113320Europe/Madridpopulated place
3122906EspasaESAsturiasProvince of Asturias43.57567-5.763620Europe/Madridpopulated place
2521387BaldazosBaldazos,Caserio Baldazos,Caserío BaldazosESMurciaMurcia37.69171-1.621310Europe/Madridpopulated place
3112066RejaESGaliciaProvincia de Lugo43.51667-7.266670Europe/Madridpopulated place
3119974LabarcesLabarcesESCantabriaProvincia de Cantabria43.32531-4.393040Europe/Madridpopulated place
3122270FontenlaFontenla,San MamedESGaliciaProvincia de Pontevedra42.16667-8.483330Europe/Madridpopulated place
3104802VillasoplizESCastille and LeónProvincia de Burgos42.92425-3.696560Europe/Madridpopulated place
3112191ErrekaldeErrekalde,RecaldeESBasque CountryBizkaia43.2-3.083330Europe/Madridpopulated place
3113132Portela de PortomouriscoESGaliciaProvincia de Lugo42.34537-7.133570Europe/Madridpopulated place
3119079LarráinzarESNavarreProvincia de Navarra42.97826-1.696260Europe/Madridpopulated place
3119197A PoblaESGaliciaProvincia de Ourense42.41667-7.016670Europe/Madridpopulated place
3129995AnlloAnlloESGaliciaProvincia de Ourense42.38875-8.090440Europe/Madridpopulated place
3108841SobredaESGaliciaProvincia de Lugo42.67007-7.595760Europe/Madridpopulated place
2511069Santiago de MoraSantiago de Mora,Santiago de MoroESCastille-La ManchaProvincia de Albacete38.57093-1.599730Europe/Madridpopulated place
3130015AnguixESCastille-La ManchaProvincia de Cuenca40.43269-2.806530Europe/Madridpopulated place
3124481CortegadaESGaliciaProvincia de Ourense42.11725-7.645290Europe/Madridpopulated place
3114049PedruelESAragonProvincia de Huesca42.26193-0.087230Europe/Madridpopulated place
12495708NázaraESGaliciaProvincia de Ourense42.33723-8.097750Europe/Madridpopulated place
9036842CabopinoESAndalusiaProvincia de Málaga36.49042-4.742830Europe/Madridpopulated place
3113164PorqueroPorquero,PorquerosESCastille and LeónProvincia de León42.59953-6.10770Europe/Madridpopulated place
2521347Baños de ZújarESAndalusiaProvincia de Granada37.59746-2.81510Europe/Madridpopulated place
3118757LauríaESAsturiasProvince of Asturias43.43333-5.516670Europe/Madridpopulated place
3111174SabugueiraSabugueira,San PelayoESGaliciaProvincia da Coruña42.9-8.416670Europe/Madridpopulated place
3128103BeruntzaESBasque CountryGipuzkoa42.97977-2.292250Europe/Madridpopulated place
3118554LeioaLeioa,Lejoa,Lejona,Lekhona,lai ao a,layaywa,reioa,Лейоа,Лехона,لايايوا,レイオア,莱奥阿ESBasque CountryBizkaia43.32686-2.9888431197Europe/Madridpopulated place
2518563El CharcoEl CharcoESCanary IslandsProvincia de Santa Cruz de Tenerife28.51667-17.850Atlantic/Canarypopulated place
3121692Gallinero de ArcallanaGallinero,Gallinero de ArcallanaESAsturiasProvince of Asturias43.54025-6.341350Europe/Madridpopulated place
3122513Ferreiros de BalboaESGaliciaProvincia de Lugo42.80994-7.176210Europe/Madridpopulated place
3104242Barrio ZuaztoiESNavarreProvincia de Navarra43.18333-1.50Europe/Madridpopulated place
3113281PoboledaPoboledaESCataloniaProvíncia de Tarragona41.234830.84534339Europe/Madridpopulated place
3125553CebránsCebrans,CebránsESGaliciaProvincia da Coruña43.07728-9.165290Europe/Madridpopulated place
3125966CastañeraESAsturiasProvince of Asturias43.23692-6.248890Europe/Madridpopulated place
3114363ParadapiñolParadapinol,Paradapiñol,Paradepinol,ParadepiñolESGaliciaProvincia de Lugo42.48148-7.167470Europe/Madridpopulated place
2511306Sanlúcar de BarramedaSan Lucar de Barrameda,Sanlucar,Sanlucar de Barrameda,Sanlukar de Barameda,Sanlukar-de-Barrameda,Sanlúcar,Sanlúcar de Barrameda,Sunlucar de Barrameda,san luk arde bar ra me da,sang lu ka er de wa la mei da,sanlukaleudebalameda,shlwqt,Санлукар де Барамеда,Санлукар-де-Баррамеда,شلوقة,ซานลูการ์เดบาร์ราเมดา,სანლუკარ-დე-ბარამედა,サンルーカル・デ・バラメーダ,桑卢卡尔德瓦拉梅达,산루카르데바라메다ESAndalusiaProvincia de Cádiz36.77808-6.351568037Europe/Madridpopulated place
2518649El CampilloCaserio El Campillo,Caserío El Campillo,El CampilloESAndalusiaProvincia de Cádiz36.65-6.316670Europe/Madridpopulated place
3123829DonsiónDonsion,Donsión,Santa EulaliaESGaliciaProvincia de Pontevedra42.66033-8.153290Europe/Madridpopulated place
3121327GomeciegoGomeciegoESCastille and LeónProvincia de Salamanca41.02607-6.312910Europe/Madridpopulated place
3116881Mequinensa / MequinenzaMequinensa,Mequinensa / Maquinenza,MequinenzaESAragonProvincia de Zaragoza41.372110.301692479Europe/Madridpopulated place
2517064GrañenaCortijada Granena,Cortijada Grañena,Granena,GrañenaESAndalusiaProvincia de Jaén37.84994-3.761220Europe/Madridpopulated place
3106972Valdecolmenas de ArribaESCastille-La ManchaProvincia de Cuenca40.09775-2.441530Europe/Madridpopulated place
3119582LaiñoLaino,Laiño,San JuanESGaliciaProvincia de Pontevedra42.71667-8.716670Europe/Madridpopulated place
3120362InsúaSalvador,San SalvadorESGaliciaProvincia de Lugo42.71379-7.714290Europe/Madridpopulated place
7115328Saliente BajoESAndalusiaAlmería37.46384-2.150290Europe/Madridpopulated place
3128216BercimuelleBercimuelle,Caserio Bercimuelle,Caserío BercimuelleESCastille and LeónProvincia de Ávila40.84584-5.152520Europe/Madridpopulated place
3124043CulebrosCulebrosESCastille and LeónProvincia de León42.6417-6.103770Europe/Madridpopulated place
3120444IgenaIgenaESAsturiasProvince of Asturias43.39455-5.018670Europe/Madridpopulated place
6325356AzpilgoetaAzpilgoetaESBasque CountryGipuzkoa43.25422-2.388420Europe/Madridpopulated place
3114714OvellarizaOvellarizaESAsturiasProvince of Asturias43.31015-6.980450Europe/Madridpopulated place
3124901Cobos Junto a la MolinaESCastille and LeónProvincia de Burgos42.53398-3.60970Europe/Madridpopulated place
3125745Castrillo de HayaESCantabriaProvincia de Cantabria42.91216-4.174620Europe/Madridpopulated place
3110852Sant Antoni de VilamajorSan Antonio de Vilamajor,Sant Antoni de VilamajorESCataloniaProvíncia de Barcelona41.666672.40Europe/Madridpopulated place
3129346ArtaArtaESBasque CountryBizkaia43.24342-2.536280Europe/Madridpopulated place
3125626Castroserna de ArribaCastroserna de ArribaESCastille and LeónProvincia de Segovia41.19029-3.716030Europe/Madridpopulated place
3104879VilarrasoESGaliciaProvincia da Coruña43.18333-8.033330Europe/Madridpopulated place
3107034ValdazoValdazoESCastille and LeónProvincia de Burgos42.52464-3.362450Europe/Madridpopulated place
6459074el Morassacel MorassacESCataloniaProvíncia de Girona42.33392.997250Europe/Madridpopulated place
3122200Fornelos de CovaFornelos de CovaESGaliciaProvincia de Ourense42.2073-7.10820Europe/Madridpopulated place

FaQ about Spain


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.