#Travel budget planning template how to
#Travel budget planning template free

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.

#Travel budget planning 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.

#Travel budget planning 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.