The Historical Trip Report, which you can download as a CSV from the 'Insights' page, always shows the date/time in UTC (e.g. realizedStopArrival, realizedStopDeparture):



Is that undesirable, because this is not your local time? In Microsoft Excel you can easily change this yourself:


  1. Open Excel
  2. Go to Data tab
  3. Under "Get and transform data", click "From text file/CSV".
  4. Select the historical trip report
  5. Click on Load
  6. All times are now automatically displayed in your local time