# Export to excel xlsx

**URL:** <https://forum.inductiveautomation.com/t/export-to-excel-xlsx/9400>\
**Category:** Ignition\
**Created:** [December 2, 2014, 5:09pm UTC](https://forum.inductiveautomation.com/t/export-to-excel-xlsx/9400 "2014-12-02T17:09:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aaronkneeland](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@aaronkneeland](https://forum.inductiveautomation.com/u/aaronkneeland)\
**Post date:** [December 2, 2014, 5:09pm UTC](https://forum.inductiveautomation.com/t/export-to-excel-xlsx/9400/1 "2014-12-02T17:09:20Z")

</div>

Is it possible to export to excel in an xlsx format so I don’t get a formatting error every time I open the saved xls file? Currently using this script

```auto
table = event.source.parent.getComponent("main table")
 
filePath = system.dataset.exportExcel("data.xls", 1, table.data)
 
if filePath != None:
 
   system.net.openURL("file://"+filePath)
```

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [December 2, 2014, 11:51pm UTC](https://forum.inductiveautomation.com/t/export-to-excel-xlsx/9400/2 "2014-12-02T23:51:31Z")

</div>

You would need to import a third party library to do this. I have spoken with some customers in the past that have used the xlsxwriter library. You can read more into it here

[pypi.python.org/pypi/XlsxWriter](https://pypi.python.org/pypi/XlsxWriter)

the script you are using should work fine, you just have the warning to contend with as you have already seen. The alternative would be using the system.dataset.exportCSV function. This is very similar to the script you already tried. You could then open the CSV in Excel without any warnings.