Produce reports and exporting to Excel

  1. 4. To export this information into an Excel document, select 'Tools' along the top navigation bar. and 'Export to Excel'.
  1. 5. You can then save to file or open the excel document for viewing and further reporting.
  1. 6. Once exported to Excel, to view a travellers full itinerary, click on the 'Record Locator'. You can now filter to search for more specific information as seen below.

Start Date 25/11/2019 Completed Travel Active Travel

End Date 25/12/2019 Travel in the next 3 days Other future travel

Report Date (UTC) 2019-11-25 16:35:10 2019-11-25 16:35:10

Departure Date UTC Departure Time UTC RecordLocator Traveller Departure Country

2019:12:19 16:50:00 L4J2JL DOE/JOHN LHR London United Kingdom

2019:12:11 20:15:00 VZ23FK DOE/JOHN LHR London United Kingdom

2019:12:11 20:15:00 VZ23FK DOE/JOHN LHR London United Kingdom

2019:12:11 20:15:00 VZ23FK DOE/JOHN LHR London United Kingdom

2019:12:11 20:15:00 VZ23FK DOE/JOHN LHR London United Kingdom

2019:12:11 20:15:00 VZ23FK DOE/JOHN LHR London United Kingdom

2019:12:04 22:25:00 4B493K DOE/JOHN CAN Guangzhou China

2019:12:04 14:45:00 ZF2ZGE DOE/JOHN AKL Auckland New Zealand

2019:12:04 14:45:00 ZF2ZGE DOE/JOHN AKL Auckland New Zealand

2019:11:27 01:25:00 HBRKZA DOE/JOHN BOS Boston United States

2019:12:20 15:45:00 WBWPP8 DOE/JOHN SYD Sydney Australia

2019:11:24 21:00:00 I9HTV4 DOE/JOHN LHR London United Kingdom

2019:12:03 01:00:00 VOLUEN EUR New York United States