Power Chart CSV Export Excel Timestamps

Ignition
,
1

I have a few CSV files that I've exported from my power chart. I'd like to make a chart in excel from this data. However, I'm not sure how to go about converting the time values. They're in scientific notation unix (?) time.

2

I use one of two options:

  • Create my own export button on my pages, that way I can have the power chart display a max number of samples to make it run better, but export 'as stored', and can also just configure it to export the data with datetimes converted, or;

  • Convert it in the excel sheet using some kind of equation with the excel DATE function, like on here: How to Convert Unix Timestamp to Date in Excel (3 Methods) - ExcelDemy