VacationSelector

Cologne or Madrid?

Two destinations compared on nine measures of openly sourced data. Weight what matters to you and the verdict follows.

Your match

Cologne
57
match

Wins on nature & day trips with your weighting.

Madrid
✓ Best match
66
match

Wins on sights concentration and nightlife with your weighting.

What matters to you?

Pick a travel style or drag the sliders. The match scores above update as you do.

Scoreboard

Each measure scored 0 to 100. Open a row for the figures behind the score.

CologneMadrid
Beaches & swimming. Cologne and Madrid are level on 0.
CologneMadrid
Score00
Swim season months00
Beaches 10 km404
Coast distance256 km305 km
Water distance
Places to eat. Madrid leads by 11 points.11
CologneMadrid
Score7283
Restaurants within 2 km of centre1,1423,508
Effective number of cuisines within 2 km3528
Museums & heritage. Madrid leads by 15 points.15
CologneMadrid
Score6075
Museums within 10 km4797
Museums within 2 km of centre2759
Share of museums within 2 km %5761
Unesco sites within 50 km34
Nightlife. Madrid leads by 17 points.17
CologneMadrid
Score6481
Drinking venues within 4 km1,1072,414
Drinking venues within 2 km of centre7271,498
Share of drinking venues within 2 km %6662
Nightclubs within 4 km90341
Nature & day trips. Cologne leads by 8 points.8
CologneMadrid
Score7163
Protected land share 50 km %5319
Landscape blanket share 50 km %520
Land share of disc %100100
Park area within 2 km118 hectares187 hectares
Good for families. Madrid leads by 5 points.5
CologneMadrid
Score7277
Tourist attractions within 2 km4361
Park area within 2 km118 hectares187 hectares
Theme parks within 30 km63
Sights concentration. Madrid leads by 22 points.22
CologneMadrid
Score5375
Notable places within 2 km81288
Min wikipedia languages55
Value for money. Madrid leads by 11 points.11
CologneMadrid
Score6071
Price level global75.960.8
Daily budget€163€122
Year-round weather. Madrid leads by 12 points.12
CologneMadrid
Score6072
Monthly daytime high6.3 °C to 25 °C10 °C to 32.7 °C
Monthly rainfall48 mm to 81 mm9 mm to 64 mm
Dry months07
0255075100

When should you go?

The figures behind each month. Each row is shaded against that destination's own year, so the deepest cell is its best month for that measure and the palest its weakest. Shades are not comparable between the two rows.

J
F
M
A
M
J
J
A
S
O
N
D
Daytime high, °C
Cologne
6
7
12
16
20
23
25
25
21
15
10
7
Madrid
10
12
16
19
23
29
33
32
27
20
14
10
Rainfall, mm
Cologne
64
56
53
48
60
76
81
81
67
65
68
72
Madrid
32
34
35
46
49
20
9
10
24
64
53
42
Daylight, hours per day
Cologne
9
10
12
14
16
16
16
15
13
11
9
8
Madrid
10
11
12
13
14
15
15
14
13
11
10
9
Sunshine, hours per day
Cologne
2
2
4
6
7
7
7
6
5
3
2
1
Madrid
5
5
7
8
9
11
12
11
9
6
5
4

Temperature and rainfall are thirty-year climate normals, averaged over the years shown. Cologne: 1991-2020 normals, Köln-Stammheim (5.4 km from centre). Madrid: 1991-2020 normals, Madrid (1.7 km from centre).

WorseBetter

Getting there

Flying fromCologneMadrid
PalmaPMI
2 h 10 m
no fares
CGN · 15 km
1 h 20 m
€56-238
MAD · 14 km
LondonLHR, LGW, STN, LTN +2
1 h 20 m
no fares
CGN · 15 km
2 h 10 m
€52-105
MAD · 14 km
IstanbulIST, SAW
3 h 0 m
€145-156
CGN · 15 km
3 h 50 m
€182-348
MAD · 14 km
BarcelonaBCN
2 h 0 m
€77-159
CGN · 15 km
1 h 15 m
€116-130
1 stop
MAD · 14 km
MunichMUC
1 h 10 m
no fares
CGN · 15 km
2 h 25 m
€193-236
1 stop
MAD · 14 km
RomeFCO, CIA
1 h 55 m
no fares
CGN · 15 km
2 h 15 m
€83-91
MAD · 14 km
TenerifeTFS, TFN
4 h 30 m
no fares
CGN · 15 km
2 h 50 m
€109-153
MAD · 14 km
MilanMXP, BGY, LIN
1 h 20 m
€81-121
CGN · 15 km
2 h 0 m
€53-86
MAD · 14 km
ParisCDG, ORY, BVA
1 h 10 m
no fares
DUS · 41 km
1 h 55 m
€95-123
MAD · 14 km
DohaDOH
6 h 15 m
no fares
DUS · 41 km
6 h 55 m
no fares
MAD · 14 km

The busiest departure cities for these two, with a place kept for each other part of the world. Busiest means arriving passengers where an official count exists, and where none does, the number of non-stop services flown: official route statistics are published by the European reporting countries and by nobody else, so a table ranked on them alone would offer a reader in New York or Tokyo ten European cities. Flying times are estimated from the distance between airports, and every row is a city flown non-stop to both. Where the typical offer connects anyway, the stops are shown. Under each figure is the airport the flight lands at and how far that is from the centre, because the nearest airport is not always the one a route is flown to. Where both columns name the same airport it is one flight, and the difference between the two is the distance printed beside it. Typical return fares for 2026-09 to 2026-10, cached market data up to 7 days old. The figure is the middle half of the offers found, so a single price means they agreed and a range means they did not; for a typical route that middle half spans about a quarter of the median, and for the least settled routes rather more than the median itself.

Before you go

MeasureCologneMadrid
Official languageGermanSpanish
CurrencyEuro (EUR)Euro (EUR)
SocketsCF230 V, 50 HzCF230 V, 50 Hz
Driving sideRightRight
Time zoneUTC+1, UTC+2 in summerUTC+1, UTC+2 in summer
Emergency number112112
Elevation59 m663 m
Main airportCologne Bonn Airport (CGN)15 km from centre113 non-stop destinationsAdolfo Suárez Madrid–Barajas Airport (MAD)14 km from centre236 non-stop destinations
Public holidays this year11 days12 days

By the numbers

MeasureCologneMadrid
City population1,024,6213,506,730
People per km²2,5305,801
Museums within 10 km4088
UNESCO World Heritage sites within 50 km34
Distinct cuisines in the centre84106

Where else could you go?

Every comparison below shares a destination with this one, so you can follow Cologne or Madrid somewhere new.

Browse every destination we have measured

Sources

© OpenStreetMap contributors, data available under the Open Database Licence. Place counts include data from Overture Maps Foundation (CDLA Permissive 2.0), assembled from Meta, Microsoft, Foursquare and other providers. Notable-place counts from Wikidata (CC0), weighted by Wikipedia language editions. Structured data from Wikidata (CC0). Weather data by Meteostat. Meteorological data provided by NOAA, DWD and others. Airport data from OurAirports (public domain). Tourism statistics from Eurostat, © European Union, reused under CC BY 4.0. Public holidays from Nager.Date (MIT). Non-stop route lists from the "Airlines and destinations" tables on English Wikipedia airport articles, by Wikipedia contributors, reused under CC BY-SA 4.0. Currency from the ISO 4217 register maintained by SIX, cross-checked against country data from GeoNames (CC BY 4.0). Price level from World Bank open data (PPP conversion factor for private consumption and official exchange rate), CC BY 4.0. Time zones from GeoNames (CC BY 4.0); clock offsets computed from the IANA time zone database. Daylight hours computed from each destination's latitude using the NOAA solar position algorithm. Typical fares from Travelpayouts (Aviasales data). Route-level air passenger statistics from Eurostat, © European Union, reused under CC BY 4.0. Exchange rates via Frankfurter, based on European Central Bank reference rates.

Scores follow rubric v2; snapshot generated 2026-08-31. Typical prices can be up to 7 days old. Daily budgets are estimates from country price levels.