# Power Chart CSV Export Excel Timestamps **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [February 7, 2024, 3:16pm UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377 "2024-02-07T15:16:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\ **Post date:** [February 7, 2024, 3:16pm UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/1 "2024-02-07T15:16:27Z")
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. ---
**Author:** ![Hayden\_Watson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hayden_watson/32/48792_2.png) [@Hayden\_Watson](https://forum.inductiveautomation.com/u/Hayden_Watson)\ **Post date:** [February 8, 2024, 1:04pm UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/2 "2024-02-08T13:04:21Z")
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](https://www.exceldemy.com/convert-unix-timestamp-to-date-in-excel/) ---
**Author:** ![Aaron\_Schuleman](https://avatars.discourse-cdn.com/v4/letter/a/ee59a6/32.png) [@Aaron\_Schuleman](https://forum.inductiveautomation.com/u/Aaron_Schuleman)\ **Post date:** [January 27, 2025, 7:53pm UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/3 "2025-01-27T19:53:11Z")
I found in the PowerChart PROPS.config.export.dateFormat and then also timeFormat. You can change this setting here to whatever date and time format you wish for exporting. Then when you export from the PowerChart, the CSV file will show a meaningful date and time. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/f/af260701fa73f33ef81dea1a6c917c181cc0b02d.png) ---
**Author:** ![Salien](https://avatars.discourse-cdn.com/v4/letter/s/9d8465/32.png) [@Salien](https://forum.inductiveautomation.com/u/Salien)\ **Post date:** [October 28, 2025, 4:20am UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/4 "2025-10-28T04:20:03Z")
The default Power Chart export made our R&D department sad because it gives only the data density as shown with poor sample interval over large sample periods. I had a similar “export as stored” button but selecting the date ranges was awkward. Hero feature would be to export “as stored” a date range selected by the user in the power chart as a preview. Possibly a useful Exchange resource for someone to make if it doesn’t exist already? Looks like [Tom Leijen made a popup tool](https://inductiveautomation.com/exchange/2247/overview) for a fixed interval export. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [October 28, 2025, 11:12am UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/5 "2025-10-28T11:12:34Z")
> [@Salien](#): > > Possibly a useful Exchange resource Look at the embedded time span selector view in the Tag Report Utility resource: > [@Tag Report Utility](https://forum.inductiveautomation.com/t/tag-report-utility/95299): > > New resource just uploaded to the Exchange (pending review). Also available here: [https://www.automation-pros.com/TagReportUtility/](https://www.automation-pros.com/TagReportUtility/) I intend to publish at this link as well as in the Exchange going forward. Announcements will be in this topic. (: Highlights: Provides a Perspective Popup View that provides a user interface to system.tag.query() that entirely replicates the functionality of the Designer's Tag Report Tool. Provides a Perspective Embedded View that provides Time Span selectio… ---
**Author:** ![Alex\_Guyer1](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@Alex\_Guyer1](https://forum.inductiveautomation.com/u/Alex_Guyer1)\ **Post date:** [November 13, 2025, 6:45pm UTC](https://forum.inductiveautomation.com/t/power-chart-csv-export-excel-timestamps/85377/6 "2025-11-13T18:45:12Z")
This should be marked as the solution here.