#EXCEL TRAVEL BUDGET PLANNER TEMPLATE HOW TO#
#EXCEL TRAVEL BUDGET PLANNER TEMPLATE FREE#

The term “conditional formatting” simply refers to a change in a cell’s appearance when certain requirements are met. Step 3: Personalize Your Travel Planning SpreadsheetĪll that’s left for you to do is add a touch of creativity to your vacation spreadsheet. Car rental company, including name, address, and contact numberĪfter adding your column headers, you can start filling out the fields with your information.Flight details, such as flight schedule and flight number.Keep in mind that you can virtually use any word or phrase for your column headers, though. The column headers we’ve used in the demonstration above are applicable to the Itinerary tab.

Alternatively, you can make them bold by pressing “Ctrl” + “B” (or “Cmd” + “B” for Mac) on your keyboard.

Once done, select all the column headers you’ve added, then click “Bold” in the toolbar.

(We used the headers “Date,” “Time,” “Transportation,” “Costs,” and “Status” in our example below).

Repeat the previous step for other cells in the same row.

Enter your preferred column header, such as “Location” (as used in our example).

Click on the first cell (cell A1) in the upper-left corner of your worksheet.

To add column headers, simply follow these steps. These are found at the top of your worksheet, describing what kind of values are present in a column’s cells.

Activities: List the things that you can do at your destination, like bar hopping, nightlife activities, concerts, and so on.Īfter creating multiple tabs, you can further categorize your details using column headers.

Packing List: Don’t leave anything essential at home before embarking on your trip - passports, IDs, cash, and similar things.

Budget: Track your day-to-day expenses and see how much money you’re left with.

Food: Plan where you can get your meals, the restaurants you want to visit, and the average costs of eating out.You can also include whether or not you’ve made a reservation already, the room prices, and more. Accommodation: List the names and locations of your lodgings.Transportation: Keep your flight schedule, the routes you plan to take, your commute options (car rental, bus, etc.), and similar information.Itinerary: Include the basic details of the places you plan to be in, like dinner reservations, conferences you need to attend, tourist attractions, etc.Here are some common tabs you’d typically see in a trip planning spreadsheet: You can create many kinds of worksheets depending on your specific requirements. Repeat steps 1 to 4 to rename the worksheet.To add another worksheet, click on the “Add Sheet” icon (plus + symbol) at the bottom-left corner of your screen.Type your preferred worksheet name, then press “Enter” or “Return” on your keyboard.Hover over the name of the current worksheet (usually named “ Sheet1”), click on the drop-down arrow, then select “Rename.”.Click “ Blank” under the “ Start a new spreadsheet” section.For example, you can separate your flight details from your budget planning.įollow the instructions below to do this. This allows you to categorize the kinds of information you’re going to deal with. To keep your travel planner tidy, you should first create several tabs inside your spreadsheet.

#EXCEL TRAVEL BUDGET PLANNER TEMPLATE HOW TO#

How to Create a Trip Planning Spreadsheet on Google Sheets Step 1: Make Multiple Tabs on Your Spreadsheet Enjoy Your Trip with Everything Prepared.

#EXCEL TRAVEL BUDGET PLANNER TEMPLATE FREE#

Free Google Sheets Trip Planner Templates.

Step 3: Personalize Your Travel Planning Spreadsheet.

Step 1: Make Multiple Tabs on Your Spreadsheet.

How to Create a Trip Planning Spreadsheet on Google Sheets.In this worksheet, you can specify your estimated budget for the trip and based on costs that are entered into the worksheet you are automatically updated on how many percents of the overall budget are spent. Spending one’s money diligently is one of the most important aspects of any successful trip. Personally, I like the budget worksheet most of all. There are fields for the name of the activity, date, time, location, and contact info included. Here you can record all you planned activities for the trip. The Lodging worksheet lets you keep track of you lodgings with hotel name, address, check in date, check out date, etc. This way you can have a few trips under your control at a glance. Travel: The travel worksheet is where your departure and return dates, times, airlines used, origin and destination and more. Following are short descriptions of the worksheets available in the free Trip Planner MS Excel Template:

Excel travel budget planner template