# Excel Timestamp format

**URL:** <https://forum.inductiveautomation.com/t/excel-timestamp-format/32091>\
**Category:** Ignition\
**Created:** [February 10, 2020, 11:13am UTC](https://forum.inductiveautomation.com/t/excel-timestamp-format/32091 "2020-02-10T11:13:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![avg](https://avatars.discourse-cdn.com/v4/letter/a/b9bd4f/32.png) [@avg](https://forum.inductiveautomation.com/u/avg)\
**Post date:** [February 10, 2020, 11:13am UTC](https://forum.inductiveautomation.com/t/excel-timestamp-format/32091/1 "2020-02-10T11:13:25Z")

</div>

We use this code to export data to a ‘Excel’ File:

table = event.source.parent.getComponent(‘Power Table’)  
filePath = system.dataset.exportExcel(“datosPR.xls”, 1, table.data)

In one side we have problems opening the file. Several attemps must be made in order to open the file and see the data. ¿What could be the problem?

The other problem is that the tmstamp format is wrong (like a long integer). Cells format must be changed manually. ¿What could be the problem?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 10, 2020, 4:49pm UTC](https://forum.inductiveautomation.com/t/excel-timestamp-format/32091/2 "2020-02-10T16:49:12Z")

</div>

What version of Ignition are you using? If you’re on 8.0.7+, you can use the newer [`system.dataset.toExcel`](https://docs.inductiveautomation.com/display/DOC80/system.dataset.toExcel), which outputs a “real” Excel formatted spreadsheet in `.xlsx` format.