Skip to content

Europe Trip: Spreadsheet

Current Plan
1
Arrive
Depart
City
Country
Lodging booked
Transport booked
Days (calculated)
Travel Time
Mode of transit
Travel v break
Notes
IGNORE >>>
Timeframe (from spreadsheet)
Days (from spreadsheet)
Shengen Country
Continual block?
Wikipedia
Row ID
Position
1
Tue, Sep 15, 2020
Tue, Oct 6, 2020
Bromley
England
22 days
Flight
N
Y
Bromley
82
0
2
Wed, Oct 7, 2020
Sat, Jun 26, 2021
Barcelona
Spain
263 days
Flight
Y
Y
Barcelona
81
1
3
Sun, Jun 27, 2021
Wed, Jun 30, 2021
Palma de Mallorca
Spain
4 days
Ferry
Y
Y
Palma de Mallorca
79
2
4
Thu, Jul 1, 2021
Sun, Sep 26, 2021
Barcelona
Spain
88 days
Ferry
Y
Y
Barcelona
80
3
5
Mon, Sep 27, 2021
Thu, Sep 30, 2021
Heraklion
Greece
4 days
Flight
Y
Y
Heraklion
84
4
6
Fri, Oct 1, 2021
Wed, Oct 6, 2021
Athens
Greece
6 days
Flight
Y
Y
Athens
86
5
7
Thu, Oct 7, 2021
Sun, Oct 10, 2021
Palermo
Italy
4 days
Flight
Y
Y
Palermo
85
6
8
Mon, Oct 11, 2021
Wed, Oct 20, 2021
Barcelona
Spain
10 days
Flight
Y
Y
Barcelona
87
7
9
Thu, Oct 21, 2021
Sun, Oct 24, 2021
Bilbao
Spain
4 days
Train
Y
Y
Bilbao
89
8
10
Mon, Oct 25, 2021
Thu, Oct 28, 2021
San Sebastian
Spain
4 days
Train
Rod’s birthday. 3* dinner Tuesday, 1* lunch Thursday
Y
Y
San Sebastián
90
9
11
Fri, Oct 29, 2021
Sun, Oct 31, 2021
Pamplona
Spain
3 days
Train
Y
Y
Pamplona
91
10
12
Mon, Nov 1, 2021
Wed, Nov 3, 2021
Zaragoza
Spain
3 days
Train
Y
Y
Zaragoza
92
11
13
Thu, Nov 4, 2021
Tue, Dec 14, 2021
Barcelona
Spain
41 days
Train
Y
Y
Barcelona
88
12
14
Wed, Dec 15, 2021
Sun, Dec 26, 2021
Bromley
England
12 days
Flight
N
Y
Bromley
77
13
15
Mon, Dec 27, 2021
Sun, Jan 9, 2022
Barcelona
Spain
14 days
Flight
Y
Y
Barcelona
76
14
16
Mon, Jan 10, 2022
Sun, Jan 16, 2022
Madrid
Spain
7 days
3h train
Train
50
Toledo day trip?
Jan 10 - 16
7
Y
Y
Madrid
9
15
17
Tue, Feb 1, 2022
Thu, Feb 3, 2022
Amalfi Coast
Italy
3 days
10h ferry or 8h 30m train
Ferry or train
50
Feb 1 - 3
3
Y
N
Amalfi Coast, Italy
13
16
18
Fri, Feb 4, 2022
Thu, Feb 10, 2022
Rome
Italy
7 days
3h train
Train
50
Feb 4 - 10
7
Y
Y
Rome
14
17
19
Fri, Feb 11, 2022
Tue, Feb 15, 2022
Florence
Italy
5 days
3h train
Train
50
Feb 11 - 15
5
Y
Y
Florence
15
18
20
Wed, Feb 16, 2022
Fri, Feb 18, 2022
Cinque Terre
Italy
3 days
3h train
Train
50
Feb 16 - 18
3
Y
Y
Cinque Terre, Italy
16
19
21
Sat, Feb 19, 2022
Wed, Feb 23, 2022
Venice
Italy
5 days
6h train
Train
50
Carnival
Feb 19 - 23
5
Y
Y
Venice
17
20
22
Thu, Feb 24, 2022
Mon, Feb 28, 2022
Munich
Germany
5 days
Train
50
Idles 2/24
Feb 24 - 28
5
Y
Y
Munich
18
21
23
Tue, Mar 1, 2022
Mon, Mar 14, 2022
Paris
France
14 days
Train
14
Lacey Birthday
March 1 - 14
14
Y
Y
Paris
19
22
24
Tue, Mar 15, 2022
Thu, Mar 17, 2022
Luxembourg
Luxembourg
3 days
Train
45
March 15 - 17
3
Y
Y
Luxembourg City
20
23
25
Fri, Mar 18, 2022
Tue, Mar 22, 2022
Bruges
Belgium
5 days
Train
45
March 18 - 22
5
Y
Y
Bruges
21
24
26
Wed, Mar 23, 2022
Sun, Mar 27, 2022
Antwerp
Belgium
5 days
Train
45
March 23 - 27
5
Y
Y
Antwerp
22
25
27
Mon, Mar 28, 2022
Fri, Apr 1, 2022
Rotterdam
Netherlands
5 days
Train
45
March 28 - April 1
5
Y
Y
Rotterdam
23
26
28
Sat, Apr 2, 2022
Wed, Apr 6, 2022
The Hague
Netherlands
5 days
Train
45
April 2 - 6
5
Y
Y
The Hague
24
27
29
Thu, Apr 7, 2022
Wed, Apr 13, 2022
Amsterdam
Netherlands
7 days
Train
45
Tulips in season
April 7 - 13
7
Y
Y
Amsterdam
25
28
30
Thu, Apr 14, 2022
Sat, Apr 16, 2022
Cologne/Dresden?
Germany
3 days
Train
45
April 14 - 16
3
Y
Y
Cologne/Dresden?, Germany
26
29
31
Sun, Apr 17, 2022
Thu, Apr 21, 2022
Hamburg
Germany
5 days
Train
45
Belle & Sebastian 4/17
April 17 - 21
5
Y
Y
Hamburg
27
30
32
Fri, Apr 22, 2022
Thu, Apr 28, 2022
Prague
Czechia
7 days
Train
45
April 22 - 28
7
Y
Y
Prague
28
31
33
Fri, Apr 29, 2022
Mon, May 9, 2022
Stockholm
Sweden
11 days
Flight
11
April 29 - May 9
11
Y
Y
Stockholm
29
32
34
Tue, May 10, 2022
Sat, May 14, 2022
Italy
5 days
Flight
44
EUROVISION
May 10 - 14
5
Y
Y
, Italy
30
33
35
Sun, May 15, 2022
Thu, May 19, 2022
Salzburg
Austria
5 days
Flight or train
44
May 15 - 19
5
Y
Y
Salzburg
31
34
36
Fri, May 20, 2022
Thu, May 26, 2022
Vienna
Austria
7 days
Train
44
May 20 - 26
7
Y
Y
Vienna
32
35
37
Fri, May 27, 2022
Tue, May 31, 2022
Slovenia
5 days
Train
44
May 27 - 31
5
Y
Y
, Slovenia
33
36
38
Wed, Jun 1, 2022
Tue, Jun 7, 2022
Budapest
Hungary
7 days
Train
44
June 1 - 7
7
Y
Y
Budapest
34
37
39
Wed, Jun 8, 2022
Sun, Jun 12, 2022
Barcelona
Spain
5 days
Flight
44
June 9, 10, 11 - Primavera
June 8 - 12
5
Y
Y
Barcelona
35
38
40
Mon, Jun 13, 2022
Fri, Jun 17, 2022
Slovakia
5 days
Flight
44
June 13 - 17
5
Y
Y
, Slovakia
36
39
41
Sat, Jun 18, 2022
Wed, Jun 22, 2022
Warsaw or Krakow
Poland
5 days
Train
44
June 18 - 22
5
Y
Y
Warsaw or Krakow, Poland
37
40
42
Thu, Jun 23, 2022
Tue, Jul 5, 2022
Berlin
Germany
13 days
Train
13
Wedding anniversary, Billie Eilish 6/30
June 23 - July 5
13
Y
Y
Berlin
38
41
43
Wed, Jul 6, 2022
Sun, Jul 10, 2022
Estonia
5 days
Flight
12
July 6 - 10
5
Y
Y
, Estonia
39
42
44
Mon, Jul 11, 2022
Sun, Jul 17, 2022
Helsinki
Finland
7 days
2h ferry
Ferry
12
July 11 - 17
7
Y
Y
Helsinki
40
43
45
Mon, Jul 18, 2022
Fri, Jul 29, 2022
London
England
12 days
Flight
12
Stay in London
July 18 - 29 - LEAVE E.U.
12
N
Y
London
41
44
46
Sat, Jul 30, 2022
Fri, Aug 5, 2022
Zagerb?
Croatia
7 days
Flight
24
July 30 - Aug 5 - LEAVE E.U.
7
N
Y
Zagerb?, Croatia
42
45
47
Sat, Aug 6, 2022
Wed, Aug 10, 2022
Montenegro
5 days
Train
24
Aug 6 - 10 - LEAVE E.U.
5
N
Y
, Montenegro
43
46
48
Thu, Aug 11, 2022
Mon, Aug 15, 2022
Sofia
Bulgaria
5 days
Train
24
Aug 11 - 15 - LEAVE E.U.
5
N
Y
Sofia
44
47
49
Tue, Aug 16, 2022
Sat, Aug 20, 2022
Bucharest
Romania
5 days
Train
24
Aug 16 - 20 - LEAVE E.U.
5
N
Y
Bucharest
45
48
50
Sun, Aug 21, 2022
Mon, Aug 22, 2022
Transylvania
Romania
2 days
Train
24
Aug 21 - 22 - LEAVE E.U.
2
N
Y
Transylvania
46
49
51
Tue, Aug 23, 2022
Fri, Sep 2, 2022
Edinburgh (and Stirling)
Scotland
11 days
Flight
10
Fringe, Military Tattoo
Aug 23 - Sept 2 - LEAVE E.U.
10
N
Y
Edinburgh (and Stirling), Scotland
47
50
52
Sat, Sep 3, 2022
Sat, Sep 10, 2022
Driving around
Scotland
8 days
Car
26
Largs Viking Festival, North Ayrshire Sept 1-9
Sept 3 - 10 - LEAVE E.U.
8
N
Y
Driving around, Scotland
48
51
53
Sun, Sep 11, 2022
Thu, Sep 15, 2022
Glasgow
Scotland
5 days
Train
26
Sept 11 - 15 - LEAVE E.U.
5
N
Y
Glasgow
49
52
54
Fri, Sep 16, 2022
Sun, Sep 18, 2022
Liverpool (Whitby)
England
3 days
Train
26
Set 16 - 18 - LEAVE E.U.
3
N
Y
Liverpool (Whitby), England
50
53
55
Mon, Sep 19, 2022
Tue, Sep 20, 2022
Manchester
England
2 days
Train
26
Sept 19 - 20 - LEAVE E.U.
2
N
Y
Manchester
51
54
56
Wed, Sep 21, 2022
Sun, Sep 25, 2022
Birmingham, Newcastle, etc
England
5 days
Train
26
Sept 21 - 25 - LEAVE E.U.
5
N
Y
Birmingham, Newcastle, etc, England
52
55
57
Mon, Sep 26, 2022
Wed, Sep 28, 2022
Bath
England
3 days
Train
26
Jane Austen festival - earlier
Sept 26 - 28 - LEAVE E.U.
3
N
Y
Bath , England
53
56
58
Thu, Sep 29, 2022
Sat, Oct 8, 2022
London
England
10 days
Train
10
Sept 29 - Oct 8 - LEAVE E.U.
10
N
Y
London
54
57
59
Sun, Oct 9, 2022
Tue, Oct 11, 2022
Brighton
England
3 days
Train
3
Oct 9 - 11 - LEAVE E.U.
3
N
Y
Brighton
55
58
60
Wed, Oct 12, 2022
Mon, Oct 24, 2022
Paris
France
13 days
Train
13
Giverny - Monets garden, Versailles, Le Mont Sant Michel
Oct 12 - 24
13
Y
Y
Paris
56
59
61
Tue, Oct 25, 2022
Mon, Oct 31, 2022
Copenhagen
Denmark
7 days
Train
49
Rod Birthday
Oct 25 - 31
7
Y
Y
Copenhagen
57
60
62
Tue, Nov 1, 2022
Mon, Nov 7, 2022
Oslo
Norway
7 days
Train
49
Nov 1 - 7
7
Y
Y
Oslo
58
61
63
Tue, Nov 8, 2022
Thu, Nov 10, 2022
Liechtenstein
Liechtenstein
3 days
Train
49
Nov 8 - 10
3
Y
Y
Liechtenstein, Liechtenstein
59
62
64
Fri, Nov 11, 2022
Mon, Nov 14, 2022
Basel or Lucerne
Switzerland
4 days
Train
49
Nov 11 - 14
4
Y
Y
Basel or Lucerne, Switzerland
60
63
65
Tue, Nov 15, 2022
Wed, Nov 16, 2022
Zermatt
Switzerland
2 days
Train
49
Nov 15 - 16
2
Y
Y
Zermatt
61
64
66
Thu, Nov 17, 2022
Mon, Nov 21, 2022
Geneva
Switzerland
5 days
Train
49
Nov 17 - 21
5
Y
Y
Geneva
62
65
67
Tue, Nov 22, 2022
Tue, Nov 22, 2022
Monte Carlo
Monaco
1 day
Train
49
Nov 22
1
N
Y
Monte Carlo
63
66
68
Wed, Nov 23, 2022
Fri, Nov 25, 2022
Nice or St Tropez
France
3 days
Train
49
Nov 23 - 25
3
Y
Y
Nice or St Tropez, France
64
67
69
Sat, Nov 26, 2022
Mon, Nov 28, 2022
Marsielle
France
3 days
Train
49
Nov 26 - 28
3
Y
Y
Marsielle, France
65
68
70
Tue, Nov 29, 2022
Fri, Dec 2, 2022
Toulouse
France
4 days
Train
49
Nov 29 - Dec 2
3
Y
Y
Toulouse
66
69
71
Sat, Dec 3, 2022
Mon, Dec 5, 2022
Bordeaux
France
3 days
Train
49
Dec 3 - 5
3
Y
Y
Bordeaux
67
70
72
Tue, Dec 6, 2022
Thu, Dec 8, 2022
Lyon
France
3 days
Train
49
Dec 6 - 8
3
Y
Y
Lyon
68
71
73
Fri, Dec 9, 2022
Tue, Dec 13, 2022
Hamburg
Germany
5 days
Train
49
Dec 9 - 13
5
Y
Y
Hamburg
69
72
74
Wed, Dec 14, 2022
Fri, Dec 23, 2022
Berlin
Germany
10 days
Train
10
Dec 14 - 23
10
Y
Y
Berlin
70
73
75
Sat, Dec 24, 2022
Fri, Dec 30, 2022
London
England
7 days
Train
24
Christmas
Dec 24 - 30 - LEAVE E.U.
7
N
Y
London
71
74
76
Sat, Dec 31, 2022
Fri, Jan 6, 2023
Stirling/Edinburgh - be in Edinburgh for new years
Scotland
7 days
Train
24
NYE
Dec 31 - 6 - LEAVE E.U.
7
N
Y
Stirling/Edinburgh - be in Edinburgh for new years, Scotland
72
75
77
Sat, Jan 7, 2023
Mon, Jan 9, 2023
Liverpool
England
3 days
Train
24
Jan 7 - 9 - LEAVE E.U.
3
N
Y
Liverpool
73
76
78
Tue, Jan 10, 2023
Wed, Jan 11, 2023
Manchester
England
2 days
Train
24
Jan 10 - 11 - LEAVE E.U.
2
N
Y
Manchester
74
77
79
Thu, Jan 12, 2023
Mon, Jan 16, 2023
Reykjavik
Iceland
5 days
Flight
24
Jan 12 - 16
5
Y
Y
Reykjavík
75
78
There are no rows in this table
Members of the Schengen area
0
Country
Area
Population
Date signed
Date of first implementation
1
Austria
83,871
8,891,388
28 April 1995[19]
1 December 1997[20][21][Note 3]
2
Belgium
30,528
11,482,178
14 June 1985[22]
26 March 1995[23]
3
Czechia
78,866
16 April 2003[24]
21 December 2007[25][Note 4]
4
Denmark
43,094
5,752,126
19 December 1996[31]
25 March 2001[32]
5
Estonia
45,338
1,322,920
16 April 2003[24]
21 December 2007[25][Note 4]
6
Finland
338,145
5,522,576
19 December 1996[33]
25 March 2001[32]
7
France
551,695
64,990,511
14 June 1985[22]
26 March 1995[23]
8
Germany
357,022
83,124,418
14 June 1985[22]
26 March 1995[23]
9
Greece
131,990
10,522,246
6 November 1992[39]
1 January 2000[40][Note 9]
10
Hungary
93,030
9,707,499
16 April 2003[24]
21 December 2007[25][Note 4]
11
Iceland
103,000
336,713
19 December 1996[41]
12
Italy
301,318
60,627,291
27 November 1990[44]
26 October 1997[21][45][Note 12]
13
Latvia
64,589
1,928,459
16 April 2003[24]
21 December 2007[25][Note 4]
14
Liechtenstein
160
37,910
28 February 2008[46]
19 December 2011[47]
15
Lithuania
65,300
2,801,264
16 April 2003[24]
21 December 2007[25][Note 4]
16
Luxembourg
2,586
604,245
14 June 1985[22]
26 March 1995[23]
17
Malta
316
439,248
16 April 2003[24]
21 December 2007[25][Note 4]
18
Netherlands
41,526
17,059,560
14 June 1985[22]
26 March 1995[23]
19
Norway
385,155
5,337,962
19 December 1996[41]
20
Poland
312,683
37,921,592
16 April 2003[24]
21 December 2007[25][Note 4]
21
Portugal
92,391
10,256,193
25 June 1991[49]
26 March 1995[23]
22
Slovakia
49,037
5,453,014
16 April 2003[24]
21 December 2007[25][Note 4]
23
Slovenia
20,273
2,077,837
16 April 2003[24]
21 December 2007[25][Note 4]
24
Spain
505,990
46,692,858
25 June 1991[51][52]
26 March 1995[23]
25
Sweden
449,964
9,971,638
19 December 1996[53]
25 March 2001[32]
26
Switzerland
41,285
8,525,611
26 October 2004[54]
12 December 2008[55][Note 14]
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.