# Saving power table to excel in xlsx format

**URL:** <https://forum.inductiveautomation.com/t/saving-power-table-to-excel-in-xlsx-format/34077>\
**Category:** Ignition\
**Created:** [April 21, 2020, 2:23pm UTC](https://forum.inductiveautomation.com/t/saving-power-table-to-excel-in-xlsx-format/34077 "2020-04-21T14:23:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bwhite](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bwhite/32/7112_2.png) [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\
**Post date:** [April 21, 2020, 2:23pm UTC](https://forum.inductiveautomation.com/t/saving-power-table-to-excel-in-xlsx-format/34077/1 "2020-04-21T14:23:11Z")

</div>

Is there a function to save a power table’s data to an excel sheet with the newer xlsx format? I have tried the dataset.toExcel and that always gives the error that it is in the incorrect format. It does open in excel but the customer does not like to see the error.

---

<div class="post-metadata">

**Author:** ![Tim](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim/32/3361_2.png) [@Tim](https://forum.inductiveautomation.com/u/Tim)\
**Post date:** [April 21, 2020, 2:36pm UTC](https://forum.inductiveautomation.com/t/saving-power-table-to-excel-in-xlsx-format/34077/2 "2020-04-21T14:36:10Z")

</div>

system.dataset.exportExcel exports in .xlsx format. There were bugs related to this function prior to 8.0.10.

---

<div class="post-metadata">

**Author:** ![bwhite](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bwhite/32/7112_2.png) [@bwhite](https://forum.inductiveautomation.com/u/bwhite)\
**Post date:** [April 22, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/saving-power-table-to-excel-in-xlsx-format/34077/3 "2020-04-22T15:07:42Z")

</div>

Thank you. That worked much better. I had tried that earlier, but I hadn’t upgraded to 8.0.10 yet.