Free Airbnb Booking Tracker Spreadsheet – Simple One-Property Booking Log with Nights & Totals, Excel & Google Sheets, No Canva
Free Airbnb Booking Tracker Spreadsheet – Simple One-Property Booking Log with Nights & Totals, Excel & Google Sheets, No Canva
Keep every reservation in one place with this free Airbnb booking tracker spreadsheet. It is a single clean tab for one property: type the guest name, check-in and check-out dates and your nightly rate, and the sheet works out the number of nights and the total for each stay.
A summary at the top adds up your bookings, nights booked, total income and average income per night. A platform drop-down (main listing site, Vrbo, Booking.com, direct and more) shows where each booking came from. It works in Excel and Google Sheets, and the PDF is ready to print and pin up.
What you get
- One spreadsheet tab: a booking log for one property with room for 30 bookings
- Columns for guest, check-in, check-out, nights (formula), nightly rate, total (formula) and platform
- Summary row: number of bookings, nights booked, total income and average per night
- Platform drop-down list that also accepts your own entries
- Sample bookings so you can see it work, then replace them with your own
- Print-ready PDF in US Letter and A4
Files in the download
- Free-Booking-Tracker.xlsx (editable)
- Free-Booking-Tracker.pdf (US Letter)
- Free-Booking-Tracker-A4.pdf
- START-HERE-How-to-Edit.pdf
How to edit it (no Canva needed)
- Download the ZIP and unzip it.
- Open the editable file in Excel, Google Sheets (free) or Numbers. No Canva account and no subscription are needed.
- Type into the light yellow input cells. The gray formula cells update by themselves.
- Add each new booking on the next free row, or print the PDF and fill it in by hand.
The START-HERE guide in the ZIP walks you through each app step by step and explains how to print at the right size.
Want the full version?
This free template is a sample of the Multi-Property Booking Calendar. The full spreadsheet is a 12-month booking calendar for up to 10 properties, with nights and occupancy % calculated automatically and a dashboard, instead of a one-property booking list. Running several listings or want everything at once? The Host Mega Bundle includes every paid Welcome Desk Co. template in one download.
FAQ
Is it really free? Yes. Add it to your cart, complete the free checkout and download the ZIP.
Do I need Canva? No. The file opens in Excel, Google Sheets (free) or Numbers.
Can I change the wording, colors and fonts? Yes. Every word is real, editable text, and you can change colors and fonts like in any other document.
Does it work in Google Sheets? Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas and drop-down list keep working.
Can I track more than one property? This free tab is made for one property. Make a copy of the file for each home, or see the full multi-property booking calendar below.
License
Free for personal use on your own rental property. You may edit, print and share the finished pages with your guests. Please do not resell or redistribute the template files. Airbnb, VRBO and Booking.com are trademarks of their respective owners; Welcome Desk Co. is not affiliated with Airbnb, VRBO or Booking.com and this template is not endorsed by them.