Spreadsheet: 866447d1713361612-look-up-values-with-inconsistent-names-example-1-
Sheet: City Names in Local Language

Name
Mariehamn
Tiranë
[NAME]
Elbasan
Shkodër
Fier
Vlorë
Andorra la Vella
Escaldes-Engordany
Oranjestad
San Nicolas
Noord
Paradera
Santa Cruz
Savaneta
[NAME]
Graz
Linz
[NAME]
Innsbruck
Klagenfurt am Wörthersee
Brussels
Schaerbeek
Anderlecht
Molenbeek-Saint-Jean
Ixelles
Uccle
Charleroi
Municipality of Koekelberg
Bonaire
Sint Eustatius
Saba
Sarajevo
Banja Luka
Tuzla
Zenica
Bijeljina
Mostar
866486
918366
Sofia
Plovdiv
Varna
Burgas
Ruse
[NAME]
Zagreb
Split
[NAME]
Osijek
Zadar
[NAME]
[NAME]
Karlovac
Willemstad
Nicosia
Limassol
Larnaca
[NAME]
Paphos
Paralimni
Prague
Brno
[NAME]
Plzeň
Liberec
Olomouc
Copenhagen
Aarhus
Aalborg
Odense
Esbjerg
Vejle
Frederiksberg
Randers
Viborg
Kolding
Herning
[NAME]
Roskilde
Slagelse
Sønderborg
Gentofte
Holbæk
Hjørring
[NAME]
Guldborgsund
[NAME]
Frederikshavn
[NAME]
Svendborg
Ringkøbing-Skjern
[NAME]
Haderslev
Rudersdal
Lyngby-Taarbæk
Faaborg-Midtfyn
Hvidovre
Varde
[NAME]
[NAME]
Skive
Favrskov
Hedensted
Vordingborg
Lolland
Vejen
Assens
Tårnby
Fredensborg
[NAME]
[NAME]
Middelfart
Vesthimmerland
[NAME]
Faxe
Brøndby
Odsherred
Nyborg
Sorø
Nordfyn
[NAME]
Albertslund
Lejre
Herlev
Billund
Allerød
Kerteminde
Struer
Odder
Langeland
Ærø
Samsø
918147
58797
58865
62855
63615
[NAME] (linn)
Tartu (linn)
Narva (linn)
Pärnu (linn)
Kohtla-Järve ([NAME])
Saaremaa (vald)
Saue (vald)
Viimsi (vald)
Rakvere (linn)
Tórshavn
Helsinki
Espoo
Tampere
Vantaa
Oulu
Turku
Lahti
Lappeenranta
Vaasa
[NAME]
Rovaniemi
Paris
Marseille
Lyon
Toulouse
Nice
Nantes
Montpellier
Strasbourg ([NAME] (choose the one called “City and Metropolitan Municipality”). Deactivate the other one.)
Bordeaux
Lille
Rennes
Toulon
Le Havre
[NAME]
Villeurbanne
Saint-Denis (Seine-Saint-Denis)
Aix-en-Provence
Clermont-Ferrand
Le Mans
Brest
Tours
Annecy
Limoges
Metz
Besançon
Rouen
[NAME]
Mulhouse
Poitiers
Dunkerque
Versailles
Cherbourg-en-Cotentin
La Rochelle
Pau
Faaa
Punaauia
Papeete
Berlin
Hamburg (Freie und Hansestadt)
[NAME] ([NAME])
Frankfurt
Dortmund
Essen
Bremen (Freie Hansestadt)
Leipzig
Dresden (Landeshauptstadt)
Hanover (Hannover) (Landeshauptstadt)
Mannheim
Bonn
Gelsenkirchen
Münster
Augsburg
Aachen
Oldenburg
Heidelberg
Göttingen
[NAME]
Ingolstadt
Athens
Thessaloniki
Patras
Heraklion
Piraeus
[NAME]
Rhodes
Ioannina
Chania
Acharnes
Nikaia-Agios Ioannis Rentis
[NAME]
Kordelio-Evosmos
Kallithea
Pavlos Melas
Agrinio
Kalamaria
Keratsini-Drapetsona
Glyfada
[NAME]
Ilion
Neapoli-Sykies
Trikala
Ilioupoli
Serres
Lamia
Chalandri
[NAME]
Alexandroupoli
Marousi
Kozani
Agios Dimitrios
Kifisia
Zografou
Kavala
Pylaia-Chortiatis
Aigaleo
[NAME]
[NAME]
Corinth (municipality)
Mytilini / Mytilene
Thermi
Ampelokipoi-Menemeni
Thermaikos
Vari-Voula-Vouliagmeni
[NAME]
Fyli
Sermersooq
Avannaata
Qeqqata
Kujalleq
Qeqertalik
Stato della Città del Vaticano
Budapest
Debrecen
Szeged
Miskolc
Pécs
Reykjavík
Kópavogur
Hafnarfjörður
Reykjanesbær
[NAME]
[NAME]
Mosfellsbær
Árborg
Dublin City Council
Cork County Council
Fingal County Council
South Dublin County Council
Kildare County Council
[NAME]–Rathdown County Council
Cork City Council
Rome (Roma)
Milan (Milano)
[NAME] (Napoli)
Turin (Torino)
Palermo
Genoa (Genova)
[NAME]
Florence (Firenze)
[NAME]
Catania
[NAME]
Venice (Venezia)
[NAME]
Padua (Padova)
Trieste
[NAME]
Parma
Taranto
Prato
[NAME] (Riga)
Daugavpils
Liepāja
[NAME]
[NAME]
Ventspils
Vilnius City Municipality
Kaunas City Municipality
Klaipėda City Municipality
Šiauliai City Municipality
Vilnius District Municipality
Panevėžys City Municipality
Kaunas District Municipality
Marijampolė Municipality
Alytus City Municipality
Mažeikiai District Municipality
Klaipėda District Municipality
Kėdainiai District Municipality
Luxembourg
Esch-sur-Alzette
Differdange
Dudelange
Pétange
[NAME]
St. Paul's Bay
Birkirkara
Sliema
Mosta
Qormi
Żabbar
Monaco (Mairie)
Podgorica
Nikšić
[NAME]
Bar
Berane
Herceg Novi
Amsterdam
[NAME]
The Hague
Utrecht
Eindhoven
Groningen
Tilburg
Almere
[NAME]
Nijmegen
Apeldoorn
Haarlem
Arnhem
Enschede
Amersfoort
Zaanstad
Haarlemmermeer
s-Hertogenbosch
Zwolle
Nouméa
Dumbéa
Le Mont-Dore
Païta
Skopje (Greater Skopje)
Kumanovo
Bitola
Tetovo
Gostivar
Prilep
Oslo
Bergen
Trondheim
Stavanger
Bærum
Kristiansand
Fredrikstad
Sandnes
Tromsø
Drammen
Sandefjord
Asker
Warsaw
Łódź
[NAME]
Wrocław
Poznań
Gdańsk
Szczecin
Bydgoszcz
[NAME]
Katowice
Gdynia
Częstochowa
Radom
Sosnowiec
Kielce
Toruń
Gliwice
[NAME]
Bytom
Bielsko-Biała
Olsztyn
Rzeszów
Elbląg
Wałbrzych
[NAME]
Koszalin
Lisbon
Sintra
[NAME]
Porto
Loures
Braga
Cascais
Amadora
[NAME]
Oeiras
Matosinhos
Almada
Seixal
Guimarães
Odivelas
Coimbra
Santa Maria da Feira
Vila [NAME]
Vila Nova de Famalicão
Maia
Leiria
[NAME]
Setúbal
Funchal
Viseu
Valongo
Bucharest
Cluj-Napoca
Timișoara
Iași (Iasi)
Constanța (Constanta)
Craiova
Brașov / Brasov
[NAME]
[NAME]
Oradea
Brăila
[NAME]
Pitești (Pitesti)
[NAME]
Serravalle
Borgo Maggiore
[NAME]
Repubblica di San Marino
Prishtina
Prizreni
[NAME]
Peja
[NAME]
Gjilani
Belgrade
Novi Sad
Niš
Kragujevac
Leskovac
[NAME]
Bratislava
Košice
Prešov
Žilina
[NAME]
Nitra
[NAME]
City Municipality of Ljubljana
City Municipality of Maribor
City Municipality of Kranj
City Municipality of Koper
City Municipality of Celje
City Municipality of [NAME]
Municipality of Domžale
City Municipality of Velenje
Madrid
Barcelona
[NAME]
Seville
Zaragoza
Málaga
Murcia
Stockholm
Gothenburg Municipality
[NAME]
Uppsala Municipality
Linköping Municipality
[NAME]
Örebro Municipality
Norrköping Municipality
Helsingborg
[NAME]
Umeå Municipality (Umea)
[NAME]
Borås Municipality
Huddinge Municipality
[NAME]
Sundsvall Municipality
Gävle Municipality
Zürich
Basel
Bern
[NAME]
Luzern
St. Gallen
Kyiv
Kharkiv
Odesa
Dnipro
Donetsk
[NAME]