{"id":13016,"date":"2026-09-19T15:07:35","date_gmt":"2026-09-19T15:07:35","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13016"},"modified":"2026-10-16T14:49:41","modified_gmt":"2026-10-16T14:49:41","slug":"travel-planner-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/travel-planner-spreadsheet\/","title":{"rendered":"Travel Planner Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 How the trip adds up<\/span><\/p>\n<h2 id=\"a-travel-planner-spreadsheet-that-converts-every-cost-and-settles-up-the-group\">A travel planner spreadsheet that converts every cost and settles up the group<\/h2>\n<p>The Travel Planner is for the person who ends up holding the plans and the receipts, for a trip alone or with friends. Set the trip up once on Settings: its name and destination, the first and last day, the local currency and its rate, who is going, and a budget for each category (flights, stay, food, transport, activities, shopping and other, renamed if you like).<\/p>\n<h3>Four habits, and the rest follows<\/h3>\n<ol>\n<li>Put each booking on Bookings as it is confirmed: flight, stay, car, train, bus, tour or insurance, with its confirmation number and whether it is paid.<\/li>\n<li>Put the plan for each day on Itinerary as travel, stay, food, sight, activity or free time. Day by Day lays it out as a card per day, in time order.<\/li>\n<li>While you are away, log each cost on Spending in whichever currency you paid it, and who paid. The hotel paid at home and the dinner paid locally both land in your money.<\/li>\n<li>Work through Packing the night before. It starts with a full list by category, documents, clothes, toiletries, tech and health, that you trim to your own and keep for the next trip.<\/li>\n<\/ol>\n<p>On the Trip tab, settle up shares every cost equally between the travellers and shows who is owed and who owes, so nobody does the sums at the airport.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, plus the same workbook as blank and example Excel files.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Itinerary, bookings, spending in any currency and a packing list, with a trip page that counts down, tracks planned against spent and settles up who owes whom.<\/p>\n","protected":false},"featured_media":13017,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Travel Planner Spreadsheet for Google Sheets and Excel | Templacity","rank_math_description":"A travel planner for Google Sheets and Excel: itinerary, bookings, spending in any currency, packing list and a group settle-up table.","rank_math_seo_score":"9","_templacity_copy_live":"1","_templacity_faq":[{"q":"Does it convert currencies automatically?","a":"It converts at the rate you type on Settings, how much local money one unit of yours buys, so use the rate you actually got. It does not fetch live exchange rates. Pick Local or Home on each cost and it lands in your money either way."},{"q":"How does a group settle up?","a":"Every cost on Spending records who paid it. The Trip tab shares the costs equally between the travellers on Settings and shows who is owed money and who owes."},{"q":"Can it handle a trip through several countries?","a":"Settings holds one local currency and its rate beside your own. For a stop with a different currency, enter those costs in your own money."},{"q":"Is there a packing list in it already?","a":"Yes, a full starter list by category and by traveller. Delete what you never take, add your own, and keep it for the next trip. The Trip tab shows how much is packed."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13016","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product\/13016","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=13016"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/13017"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=13016"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=13016"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=13016"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=13016"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=13016"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=13016"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=13016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}