Skip to main content

How to Export Trip Data on SquadTrip

Step-by-step guide to exporting trip data: access stats, select trips/packages, and download to Excel for easy organization and analysis.

Overview

SquadTrip lets you export your traveler data as an Excel (XLSX) file for offline record-keeping, tax reporting, or sharing with your team. The export includes names, emails, payment statuses, registration answers, promo codes, and add-ons. You can also download signed waivers and legal documents. Waitlist data is exported separately from the Waitlist page in the Trip Builder.

Getting to the Export

  1. Log in to your organizer dashboard

  2. Open the trip from your dashboard

  3. Filter the traveler list first if you only want a subset (package, search, or the Paid in Full, Balance Due, Cancelled or Abandoned status -- Attending, Past Due and add-on filters are not applied to the export)

  4. Open the More menu above the traveler list and choose Export → Travelers (CSV) or Travelers (Excel)

Export Your Traveler Data

  1. Open the trip from your dashboard

  2. The export covers that trip's travelers -- one trip per export

  3. Optionally filter the traveler list by package, search, or the Paid in Full, Balance Due, Cancelled or Abandoned status first (with Attending or Past Due selected, the file includes every traveler; an add-on filter is not applied to the export)

  4. Click More → Export → Travelers (Excel) or Travelers (CSV) to start the download

The file downloads automatically when ready (there is no loading indicator; if the export fails you see an "Export failed. Please try again." message).

The same Export menu also has Bookings (Excel), with one row per booking (package, room and amounts), and the Gross Sales Report, with amounts including fees. Once travelers have booked rooms, it also offers Rooms (Excel), with one row per room, and Rooming list (PDF); see Move travelers between rooms and print the rooming list. These four files always cover the whole trip, whatever filters you have set.

Trip dashboard Travelers list with the magnifier and the status filter pills from All to Cancelled, Attending selected, and the More menu open showing Edit Columns, Group By and Export with Travelers (CSV), Travelers (Excel), Bookings (Excel), Gross Sales Report, Rooms (Excel) and Rooming list (PDF)

What's in the Export

The Excel/CSV file includes:

Data

Details

Traveler names and emails

Names, emails and phone numbers for all travelers, plus Booking Ref, Traveler #, Payment Option and Affiliate

Payment statuses and amounts

Paid in Full, Balance Due, No Deposit, Abandoned or Cancelled, plus total, paid, balance, past-due and refunded amounts

Registration dates

When each traveler booked

Registration question answers

Responses to custom questions

Package and room

What each traveler booked, including their room number and room code

Promo codes applied

Discount codes used at checkout

Waitlist travelers

Exported separately from the Waitlist page in the Trip Builder (CSV)

Add-on purchases

Extra items bought by travelers

Filter Before Exporting

Filter traveler data by category before exporting:

  • Payment status -- Paid in Full, Balance Due, Abandoned, Cancelled (with Attending, where the list starts, or Past Due selected, the export includes every traveler)

  • Package -- click a package in the inventory cards above the list

  • Add-on -- clicking an add-on card filters the list on screen, but this filter is not applied to the export

  • Waitlist (export from the Waitlist page in the Trip Builder)

Filters let you export targeted subsets instead of the full list.

Download Signed Documents

You can also download signed waivers and legal documents:

  1. Open the traveler from the traveler list (View Details) and click the Signed Documents tab

  2. Each traveler's signed documents are listed there

  3. Download the PDF of their digital signature

Important Notes

  • Exports include the travelers matching your package and search filters and a Paid in Full, Balance Due, Cancelled or Abandoned status filter -- set them before clicking Export. With Attending (where the list starts) or Past Due selected, the export includes every traveler, cancelled ones too; an add-on filter is not applied

  • Waitlist travelers are exported separately -- open your trip in the Trip Builder and go to the Waitlist page to export waitlist data

  • The export file can be opened in Excel, Google Sheets, or any CSV-compatible tool

  • Export data regularly for offline backup of bookings and payments

Troubleshooting

Problem

Solution

Export button not responding

Large exports may take a few seconds to generate and there is no loading indicator, so give it a moment before clicking again. If an "Export failed" message appears, retry.

File is empty or missing data

Check the traveler-list filters -- the export follows the package and search filters and the Paid in Full, Balance Due, Cancelled and Abandoned statuses. Clear them to export everyone.

Can't find the "Signed Documents" tab

Open a traveler's profile (View Details) -- Signed Documents is a tab there, separate from the export, and it only appears once the traveler has made a first payment.

Waitlist travelers not appearing in export

Waitlist data is exported separately. Open your trip in the Trip Builder and go to the Waitlist page, then use its Export button (downloads a CSV).

Frequently Asked Questions

Q: What file format is the export? A: You choose in the Export menu: XLSX (Excel) or CSV. Both open in Excel, Google Sheets, Numbers, or any spreadsheet application. All data is organized in columns with headers.

Q: Can I export data for multiple trips at once? A: No. The export is per trip -- open each trip and export it separately.

Q: Does the export include payment details for each traveler? A: Yes. The export includes each traveler's payment status (Paid in Full, Balance Due, No Deposit, Abandoned or Cancelled), the booking's total, amount paid, remaining balance, past-due and refunded amounts, and which promo code was applied. Amounts are listed once per booking, on the first traveler's row. It's useful for financial reconciliation and tax reporting.

Q: Can I download signed waivers in bulk? A: Currently, signed documents are downloaded one traveler at a time from each traveler's Signed Documents tab.

Related Articles


Did this answer your question?