Template · CSV
Travel day log template
Short answer: one row per date, the place (or places) you were in, how you know, and a note. Fill it the same day. Download the CSV below — it opens in Excel, Numbers and Google Sheets.
The file has a row for every date in the year with the “Place” column empty. Nothing is pre-filled as home: an empty row is a gap you still need to fill.
The columns
| Column | What to write | Example |
|---|---|---|
| Date | One row per calendar date | 2026-04-20 |
| Place(s) | Every state or country you were in at any time that day | Florida; New York |
| How recorded | Automatic, Corrected or Manual | Manual |
| Transit only | A place you only passed through (kept, not deleted) | Georgia |
| Evidence | What supports it | Boarding pass DL1234 |
| Note | Anything that explains the day | Flew MCO → LGA, arrived 6pm |
Tips
- Fill it daily or at least weekly. Records made at the time carry more weight than reconstructions.
- Never fill a blank row with your home state unless you know you were there — and then say how you know.
- If you change a row later, add a note with the date of the change and the reason instead of overwriting it.
The Snowbird Day Tracker app keeps this log automatically on your phone and exports the same columns. Totals by state: state day counter.
Not tax or legal advice. The file is generated in your browser.