Convert UTC to local time

Keep in mind, downloaded data will be shown in UTC (Coordinated Universal Time); many users convert the data to their local timezone. The timestamp format is ISO 8601 date-time format of YYYY-MM-DDThh:mm:ssZ:

YYYY = four-digit year

MM = two-digit month (01 = January, etc.)

DD = two-digit day (01 through 31)

hh = two-digit hour (00 through 23) (am/pm NOT allowed)

mm = two-digit minute (00 through 59)

ss = two-digit second (00 through 59)

Z = special UTC designator (“Z”)

For those importing data into an Excel spreadsheet, after following Step 1 here, you can then use the default date-time formats in Excel.