![]() ![]() This is the finished product after I’ve chosen (and booked!) the flights. I much prefer this format for quick and easy comparison. I wanted one place to compare everything so I had separate lines for each route and each airline I was comparing. I know there are online tools like SkyScanner but print outs from websites are never formatted nicely and to be honest I’d never look at them again. I wanted a spreadsheet to compare flight times and flight prices. Related: How I use Visit a City for trip planning This spreadsheet is a good overview if you don’t want to schedule things out in 30 minute timeslots (like I do with the Visit a City tool). Visit a City, like the name suggests, only has cities as it not ideal for planning road trips. However I created a weekly itinerary spreadsheet for my recent New Zealand road trip. Since Europe is a big trip I’ve opted to use Visit a City. I typically try not to spend more than 5 days in one country per trip so it doesn’t get too same same and because there’s so many places to see! I can also see if I’m spending too much time in one place. ![]() I always color code my itineraries – it makes it much easier to follow. A great overview page.Įxcel makes it easy to rearrange things too – just cut and paste. I can see the entire holiday in front of me. This is one of my favorite spreadsheets and the one I go to first when planning a big trip. There are pre-filled expenses (and space to add your own) for: So what tool could be more perfect than Excel? This is the reason I ended up creating spreadsheets for everything in Excel – I already had the budget so figured I may as well keep everything in the one place. I wanted to compare budget versus actual and have the totals for each travel expense automatically calculate. ![]() convert currencies, print itinerary, apply for visa etc. I created a separate spreadsheet with things to do before we leave e.g. This spreadsheet is specifically for things to book, research or check. Since I’m travelling with others I included a column to put who is responsible for planning what. the dates we’re leaving, how much annual leave each person has and what dates (if coordinating multiple schedules), what currencies are needed etc. I find this overview page helpful as a catch all for that random info that doesn’t really have a place e.g. Lf you’d like a copy of my travel planning spreadsheets click here! Handy Info reference page Subscribe to my YouTube channel for more planner videos! To enlarge the screen of the video, click the square icon in the bottom right hand corner of the video (it will say ‘full screen’ when you hover your mouse over the icon). Here’s a look into my trip planning process – I hope it gives you a few ideas! ![]() I also used these spreadsheets for a quick 10 day road trip around New Zealand and they worked great – simple, quick and easy – I wish I thought to use Excel for trip planning sooner! The spreadsheets can be used for any / every domestic and international trip. I started out with a budget spreadsheet and ended up with a few spreadsheets to organize everything: I’ve used various methods for travel planning in the past including a printable planner, bullet journal and attempted to (but quickly abandoned) various travel apps.įor this trip I wanted something I could use to keep everything in the one place. I’m off to Europe later this year! This is the biggest trip I’ve done to date – almost 7 weeks.
0 Comments
Leave a Reply. |