Rebuild years of travel history from your inbox, with AI and one spreadsheet
The short answer: every booking you ever made is probably still in your email. An AI assistant that can search your inbox will find them and put them in one table, and TripStow imports that table in one go: flights, trains and hotel stays, years of them. Below are the prompts to copy, the columns to ask for, and how to import the file.
Travel apps close, change hands or stop working, and years of carefully logged trips can disappear with them. The bookings themselves are rarely lost: they are sitting in your inbox and your Sent folder.
Before you start: which assistant, and what it sees
You need an assistant that can search your email, with your permission. ChatGPT, Gemini and Copilot can each connect to Gmail or Outlook on some plans; check your assistant's settings for a Gmail, Google or Outlook connection. Whatever you choose, the assistant reads your email, not TripStow. TripStow only sees the file you import.
No assistant? Skip to searching your inbox yourself at the end.
Prompt 1: find every booking
Search my email for every travel booking I have made since 2010: flights, trains, ferries, coaches, hotel and holiday rental stays, car hire and cruises.
Look for booking confirmations, e-tickets, itineraries, boarding passes, check-in reminders and change notices, in any language. Also look in my Sent folder for bookings I forwarded to travel apps (for example trips@travelerbuddy.com or plans@tripit.com).
Ignore newsletters, price alerts, special offers and receipts that are not for a booking. If a booking was changed, use the final version. If it was cancelled, leave it out.
List what you find by year, and tell me how many bookings you found.Read the list. If a year looks thin, ask it to look again for that year, or for a particular airline or booking site (“search again for Ryanair and Booking.com emails from 2019”).
Prompt 2: turn them into one spreadsheet
Put every booking you found into one table, one row per flight, train or hotel stay, with exactly these columns:
Type, Date, From, To, Number, Airline, Hotel, City, Check-in, Check-out
Rules:
- Type is flight, train or hotel.
- A return trip is two rows, one for each direction. A connection is one row per flight.
- Date is the day of travel, written YYYY-MM-DD.
- From and To are airport codes (for example LHR, JFK) when you know them, otherwise the city or station name.
- Number is the flight or train number, for example BA117 or 1S11.
- Airline is the airline or train company.
- Hotel, City, Check-in and Check-out are only for hotel rows. Check-in and Check-out are dates, YYYY-MM-DD.
- Leave a cell empty rather than guess.
After the table, list separately any booking you were not sure about, and why.
Then give me the table as a CSV file I can download.Check the list of bookings it was not sure about: those are usually forwards of forwards, or emails with the details in an attached PDF. You can fix them in the spreadsheet, or forward the original email to TripStow instead.
What the file should look like
Type,Date,From,To,Number,Airline,Hotel,City,Check-in,Check-out
flight,2024-05-23,LHR,JFK,BA117,British Airways,,,,
flight,2024-05-30,JFK,LHR,VS4,Virgin Atlantic,,,,
train,2024-06-14,London Kings Cross,Edinburgh,1S11,LNER,,,,
hotel,,,,,,The Harbour Hotel,New York,2024-05-23,2024-05-30The column names can be in English or several other languages, and Excel files work as well as CSV.
Import it into TripStow
- In the TripStow app or on the website, go to Settings, then Import your history.
- Choose the file. TripStow places every airport, station and hotel town, and builds the trips.
- Read the summary. Anything already in your account is matched, not doubled, and any row that could not be read is listed with the reason, so you can fix it and import again.
Your trips then fill your scratch-off map and travel stats, every country and every flight.
Searching your inbox yourself
No assistant, or want to check its work? These Gmail searches find most bookings (Outlook's search understands most of them too):
to:trips@travelerbuddy.comorto:plans@tripit.com: everything you once forwarded to a travel app.subject:(booking confirmation OR e-ticket OR itinerary OR "boarding pass")from:(ryanair.com OR easyjet.com OR booking.com OR airbnb.com OR trainline.com), with the airlines and sites you use.has:attachment filename:pdf (ticket OR itinerary)for e-tickets sent as PDFs.- Add
after:2019/01/01 before:2020/01/01to work through one year at a time.
Then forward what you find to your TripStow address (it is on the Add page in the app). Each email is read and added to the right trip, however old, and an email that was already forwarded once works as it is. See forwarding your bookings for setting up a forwarding rule.