Data Import & Export Hub
Migrate your existing data into TripDeskPro with templates, validation, and conflict resolution.
10 min read
- Click 'Data Hub' under Tools in your sidebar. You'll see the Migration Center with a getting started guide and cards for each data type: Clients, Travelers, Trips, Suppliers, Payments, and Invoices.
- Start by downloading a CSV template for the data type you want to import. Each template includes column headers and two example rows showing the expected format. Fill in your data using any spreadsheet app (Excel, Google Sheets, Numbers).
- Follow the recommended import order: Clients first, then Travelers, then Trips, then Suppliers, and finally Payments and Invoices. This ensures everything links together correctly: trips need clients to exist first, payments need trips.
- Upload your filled CSV file by dragging it onto the upload zone or clicking to browse. The system validates every row instantly: green rows are valid, yellow rows have warnings (missing optional fields), red rows have errors (missing required fields), and blue rows are duplicates that already exist in your system.
- Choose how to handle duplicates: 'Add new records only' skips any matches, 'Overwrite existing' updates matched records with your imported data, or 'Skip duplicates' leaves existing records untouched. Review the summary, then confirm to start the import.
- Export all your data anytime using the Export button on any entity card. This downloads a complete CSV of everything of that kind (all clients, all trips, and so on), useful for backups, reports, or moving to another system.