Switzerland cities list with latitude and longitude in CSV format

Switzerland
Switzerland
CSV, SQL, XML, JSON

Last update : 12 December 2023.

Country
Switzerland
Capitale
Bern
Number of cities
7690
Download
Click here

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


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
6291421HofacherCHZurichBezirk Bülach47.489548.5571864Europe/Zurichpopulated place
7669630HatswilCHThurgauBezirk Arbon47.557189.325894300Europe/Zurichpopulated place
7669799NiederneunfornCHThurgauBezirk Frauenfeld47.597298.784824450Europe/Zurichpopulated place
2661455BoltigenBol’tigen,Boltigen,bo er di gen,Больтиген,博爾蒂根CHBernObersimmental-Saanen District46.628477.390541443Europe/Zurichpopulated place
2659575MosciaCHTicinoLocarno District46.15138.748640Europe/Zurichpopulated place
2661465BodenCHBernInterlaken-Oberhasli District46.668768.266650Europe/Zurichpopulated place
2658255Unter EigerCHBernInterlaken-Oberhasli District46.617648.011450Europe/Zurichpopulated place
2658770SaxetenSaxeten,Zakseten,sa ke sai teng,Заксетен,薩克塞滕CHBernInterlaken-Oberhasli District46.636587.83087132Europe/Zurichpopulated place
2661554BeringenBeringen,Beringen SH,БерингенCHSchaffhausenBezirk Schaffhausen47.697638.574314553216Europe/Zurichpopulated place
11466902Les ChesauxLes ChesauxCHVaudNyon District46.448236.149750Europe/Zurichpopulated place
2659720MaurCHZurichBezirk Uster47.339968.66778307Europe/Zurichpopulated place
2657968WittenbachVittenbakh,Wittenbach,Wittenbach SG,wei teng ba he,Виттенбах,維滕巴赫CHSaint GallenWahlkreis St. Gallen47.461089.386018542Europe/Zurichpopulated place
2661380BronschhofenBronshkhofen,Pramolveshova,bu long shi huo fen,Броншхофен,布龍施霍芬CHSaint GallenWahlkreis Wil47.478359.034544489Europe/Zurichpopulated place
6935411OberdettigenCHBernBern-Mittelland District46.972797.392060Europe/Zurichpopulated place
11487916HälmeschwandHalmeschwand,HälmeschwandCHBernFrutigen-Niedersimmental District46.607127.564150Europe/Zurichpopulated place
2659646MognoMognoCHTicinoVallemaggia District46.43128.663410Europe/Zurichpopulated place
11113680Al PonteAl PonteCHTicinoLugano District46.07989.019060Europe/Zurichpopulated place
7302237SulzCHLucerneHochdorf District47.220018.285710Europe/Zurichpopulated place
2661879AarburgAarburg,Aarmpournk,Arburg,Arburgo,a er bao,arbwrg,arbywrgh,Άαρμπουργκ,Арбург,أربيورغ,اربورگ,阿爾堡CHAargauBezirk Zofingen47.320677.899866828Europe/Zurichpopulated place
8533474LoveresseLoveresse,Lovres,luo wei sai,Ловрес,洛韋塞CHBernJura bernois47.243877.238810Europe/Zurichpopulated place
2659565MuggioMuggioCHTicinoMendrisio District45.902069.04303218Europe/Zurichpopulated place
11048590VillarzelCHVaudBroye-Vully District46.747646.912160Europe/Zurichpopulated place
11113402SasselliSasselliCHTicinoBellinzona District46.145358.947950Europe/Zurichpopulated place
2657926ZernezCernec,Gumpus de Ernece,Zernes,Zernez,ce er nei ci,tsuerunettsu,Цернец,ツェルネッツ,策爾內茨CHGrisonsRegion Engiadina Bassa / Val Müstair46.6986210.092681053Europe/Zurichpopulated place
6295514SchwerzenbachShvercenbakh,shi wei cen ba he,Шверценбах,施韋岑巴赫CHZurichBezirk Uster47.382138.657274180Europe/Zurichpopulated place
11487851MoosMoosCHBernObersimmental-Saanen District46.617327.375820Europe/Zurichpopulated place
6292248ChindismüliCHZurichBezirk Hinwil47.292698.7702547Europe/Zurichpopulated place
11488689Au VessieuxAu VessieuxCHFribourgGruyère District46.619357.088010Europe/Zurichpopulated place
11113496RovereRovereCHTicinoLocarno District46.122028.68840Europe/Zurichpopulated place
6292147UnteraurütiCHZurichBezirk Hinwil47.321958.9294124Europe/Zurichpopulated place
2658166VercorinCHValaisSierre District46.256537.5310413400Europe/Zurichpopulated place
2661571BellechasseCHFribourgSee District46.974517.132060Europe/Zurichpopulated place
8533511GempenachGempenachCHFribourgSee District46.9437.199240Europe/Zurichpopulated place
2661265CarougeCarroge,Karuzas,Karuzh,Karužas,Quadruvium,ka lu ri,kaluju,karuju,karwj,krwzh,qrwz,Каруж,קרוז,كاروج,کروژ,カルージュ,卡鲁日,카루주CHGenevaGeneva46.180966.1392119344Europe/Zurichpopulated place
2661326BürchenBetula,Buerchen VS,Bürchen VS,bi er xing,比爾興CHValaisRaron District46.280537.81506705Europe/Zurichpopulated place
11113375CrumiagaCrumiagaCHTicinoLocarno District46.152758.722190Europe/Zurichpopulated place
6615405Les CrosetsCHValaisMonthey District46.185066.83470Europe/Zurichpopulated place
6292393UnterhusCHZurichBezirk Hinwil47.28398.889517Europe/Zurichpopulated place
2660496GrodoeyGrodei,GrodoeyCHBernObersimmental-Saanen District46.508367.395430Europe/Zurichpopulated place
11492996SelvaneraSelvaneraCHGrisonsRegion Viamala46.60529.45220Europe/Zurichpopulated place
7670443VautenaivreCHJuraFranches-Montagnes District47.278196.956246400Europe/Zurichpopulated place
7670020WeiningenCHThurgauBezirk Frauenfeld47.589958.887284480Europe/Zurichpopulated place
2658449SumiswaldSumiswald,Zumisval’d,su mi si wa er de,Зумисвальд,蘇米斯瓦爾德CHBernEmmental District47.027477.745265159Europe/Zurichpopulated place
2659972L’EtivazCHVaudRiviera-Pays-d’Enhaut District46.424777.146220Europe/Zurichpopulated place
7669679KüngoldingenCHAargauBezirk Zofingen47.308747.943254330Europe/Zurichpopulated place
8533266MartherengesMartherenges,ma te lang ri,马特朗日CHVaudGros-de-Vaud District46.662286.75570Europe/Zurichpopulated place
2661172ChippisChippis,xi pi,希皮CHValaisSierre District46.28027.539621556Europe/Zurichpopulated place
11048570EnnetmoosCHNidwaldenNidwalden46.955948.338840Europe/Zurichpopulated place
6294519WihaldenCHZurichBezirk Uster47.302598.719940Europe/Zurichpopulated place
2661804Alpe di CortasCHGrisonsRegion Moesa46.49.216670Europe/Zurichpopulated place
6941590Givisiezji wei xie,吉維謝CHFribourgSarine District46.812017.126396443010Europe/Zurichpopulated place
8468979Mont-de-ButtesCHNeuchâtelVal-de-Travers District46.877856.508630Europe/Zurichpopulated place
11048359MeikirchCHBernBern-Mittelland District47.007517.364020Europe/Zurichpopulated place
2661092CourtelaryCurtis Alerici,Kurtelari,ku te la li,Куртелари,庫特拉里CHBernJura bernois47.178227.072361163Europe/Zurichpopulated place
7670423SurcastiCHGrisonsRegion Surselva46.697239.178519910Europe/Zurichpopulated place
2660798FerenbalmFerenbal’m,Villa de Balmis,fei lun ba er mu,Ференбальм,費倫巴爾姆CHBernBern-Mittelland District46.94887.211241310Europe/Zurichpopulated place
6293924FirstCHZurichBezirk Pfäffikon47.439028.7358234Europe/Zurichpopulated place
2660062La FerrièreLa Ferriere BE,La Ferriere i Sveits,La Ferrière BE,La Ferrière i Sveits,la fei li ai,拉費里埃CHBernJura bernois47.143036.89220Europe/Zurichpopulated place
2660083LaaxLaax,Laax bei Ilanz,Laks,Nagens,la ke si,lagseu,Лакс,拉克斯,락스CHGrisonsRegion Surselva46.804529.257871252Europe/Zurichpopulated place
2661729ArchArkh,a er he,Арх,阿爾赫CHBernSeeland District47.165337.431391574Europe/Zurichpopulated place
2660532Le Grand-SaconnexGrand-Saconnex,Le Grand-Saconnex,Saconnex,da sa kong nei,ル・グラン＝サコネ,大萨孔内CHGenevaGeneva46.231886.120919781Europe/Zurichpopulated place
2661114CornauxCornauxCHNeuchâtelNeuchâtel District47.03967.018721557Europe/Zurichpopulated place
7670092BrunniCHSchwyzBezirk Schwyz47.044878.7052110890Europe/Zurichpopulated place
10194780HornmattHornmattCHNidwaldenNidwalden46.913678.381910Europe/Zurichpopulated place
2660051LaldenCHValaisVisp District46.299517.90235696Europe/Zurichpopulated place
2659332UrdorfUrdorf,wu duo fu,Урдорф,烏多夫CHZurichBezirk Dietikon47.385078.425819205Europe/Zurichpopulated place
7669644HörstettenCHThurgauBezirk Frauenfeld47.619478.980545190Europe/Zurichpopulated place
2659150PraromanPraromanCHFribourgSarine District46.751457.177781223Europe/Zurichpopulated place
8198730GiezCHVaudJura-Nord vaudois District46.816046.617120Europe/Zurichpopulated place
2658491SteinStein,Stein ARCHAppenzell AusserrhodenBezirk Hinterland47.371279.34353390Europe/Zurichpopulated place
9253241BiaufondCHJuraFranches-Montagnes District47.16696.858130Europe/Zurichpopulated place
7670278LitzistorfCHFribourgSense District46.876647.222285710Europe/Zurichpopulated place
11492870Le Grand Croset DessusLe Grand Croset DessusCHVaudJura-Nord vaudois District46.584746.282090Europe/Zurichpopulated place
6293772WidenCHZurichBezirk Pfäffikon47.370278.8655931Europe/Zurichpopulated place
11048573MocevronCHValaisSion District46.266037.352040Europe/Zurichpopulated place
6291994RüeggshausenCHZurichBezirk Hinwil47.249618.8122721Europe/Zurichpopulated place
2659013RittiRiti,RittiCHValaisVisp District46.251177.876340Europe/Zurichpopulated place
7669862RheinklingenCHThurgauBezirk Frauenfeld47.676358.808554080Europe/Zurichpopulated place
7669925SignyCHVaudNyon District46.391746.202944680Europe/Zurichpopulated place
2661254CastelsCHGrisonsRegion Prättigau / Davos46.966679.816670Europe/Zurichpopulated place
6291668LaubisserCHZurichBezirk Dielsdorf47.448288.47661617Europe/Zurichpopulated place
6941264ThunstettenThunstetten BE,Tunshtetten,tong si tai teng,Тунштеттен,通斯泰滕CHBernOberaargau47.202757.757460Europe/Zurichpopulated place
6290582HombergCHZurichBezirk Affoltern47.248898.480349Europe/Zurichpopulated place
8478301PutzPutz,Putz GRCHGrisonsRegion Prättigau / Davos46.926069.747020Europe/Zurichpopulated place
7670356ProgensCHFribourgVeveyse District46.584786.911068730Europe/Zurichpopulated place
2660543GrabsGrabs,Quaravedes,ge la bu si,Грабс,格拉布斯CHSaint GallenWahlkreis Werdenberg47.182489.443954656384Europe/Zurichpopulated place
2661285CalörtschCHGrisonsRegion Surselva46.777349.327370Europe/Zurichpopulated place
6295406Unter ReppischtalCHZurichBezirk Dietikon47.374418.410628Europe/Zurichpopulated place
6291227Nieder-HöriCHZurichBezirk Bülach47.50918.503855Europe/Zurichpopulated place
7669561ErdessonCHValaisSierre District46.245367.471059950Europe/Zurichpopulated place
2658598SignôraCHTicinoLugano District46.092589.047160Europe/Zurichpopulated place
2660395HeerbruggHeerbrugg,Heerbrugge,Herbrug,ZHLCHSaint GallenWahlkreis Rheintal47.414889.626840Europe/Zurichpopulated place
2660191KanderstegKandershteg,Kandersteg,Pons Kanderae,ZHR,kan de si tai ge,Кандерштег,坎德斯泰格CHBernFrutigen-Niedersimmental District46.494677.673261123Europe/Zurichpopulated place
2661518Thayngen, BibernBibern,Bibern SHCHSchaffhausenBezirk Reiat47.772918.6762486254Europe/Zurichpopulated place
7670222InsoneCHTicinoLugano District46.086419.030768800Europe/Zurichpopulated place
7670237La CrêtaCHValaisMartigny District46.095137.0048710790Europe/Zurichpopulated place
2658034WeissbadCHAppenzell InnerrhodenAppenzell Inner Rhodes47.308929.434680Europe/Zurichpopulated place
11493072ChappelihusChappelihusCHGrisonsRegion Surselva46.591299.196790Europe/Zurichpopulated place
2661726ArdezArdec,Ardez,Ardezis,a er de ci,Ардец,阿爾德茨CHGrisonsRegion Engiadina Bassa / Val Müstair46.7749510.20159441Europe/Zurichpopulated place
7670038ZiegelriedCHBernSeeland District47.041577.349365850Europe/Zurichpopulated place

FaQ about Switzerland

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.