Converting System Log CSV Export Timestamps in Okta to a Specific Timezone

A System Log Comma-Separated Values (CSV) export uses Zulu Time timestamps in the YYYY-MM-DDTHH:MM:ss.sssZ format. Spreadsheet formulas convert those timestamps to a preferred local timezone after the export is downloaded and opened in a spreadsheet application.

• Okta Identity Engine (OIE)
• Okta Classic Engine
• System Log
• CSV Export

A System Log CSV export uses Zulu Time timestamps, so the exported values do not match a preferred local timezone until a spreadsheet formula applies the required offset.

How are System Log CSV export timestamps converted to a specific timezone?

Convert the exported timestamp values in a spreadsheet application to display the preferred timezone.

1. Download the CSV file from the System Logs.
2. Import the file into Microsoft Excel or Google Sheets.
3. Create a new column, for example timestamp_local, in the file.
4. Enter this formula to convert the time to the desired timezone:

=(DATEVALUE(LEFT(F2,10))+TIMEVALUE(MID(F2,12,12)))+TIME(8,0,0)

NOTE: Modify these formula elements to match the required timezone conversion:

• Replace F2 to reflect the actual timestamp column.
• Replace + to reflect whether the offset is positive or negative. For example, GMT+8 uses a plus sign (+), and GMT-8 uses a minus sign (-).
• Replace 8 with the specific time offset. For example, GMT+8 uses 8, and GMT+11 uses 11.