Skip to main content

Timestamps

How to convert timestamps in your CSV files

The time recorded in the CSV are standardized to Coordinated Universal Time (UTC). Those times can be converted in your spreadsheet editor. First look up the offset from UTC to your local timezone. Then  you can add a column and apply a formula to make the adjustment.

For example, in Microsoft Excel, to convert UTC to EST, use:

=A3-TIME(4,0,0)

and then extend the same formula to the entire column.

Did this answer your question?