# Exporting table to .csv with formated columns?

**URL:** <https://forum.inductiveautomation.com/t/exporting-table-to-csv-with-formated-columns/108357>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 11, 2025, 9:38am UTC](https://forum.inductiveautomation.com/t/exporting-table-to-csv-with-formated-columns/108357 "2025-07-11T09:38:57Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [July 14, 2025, 9:13am UTC](https://forum.inductiveautomation.com/t/exporting-table-to-csv-with-formated-columns/108357/15 "2025-07-14T09:13:54Z")

</div>

It actually works, as seen on post:

> [@\[Feature-13610\]Export to Excel in Perspective Ignition 8](https://forum.inductiveautomation.com/t/feature-13610-export-to-excel-in-perspective-ignition-8/24177/13):
>
> table = self.parent.parent.getChild("Table Container").getChild("Table").props.data excelstr = system.dataset.dataSetToExcel(True,[table]) excelbytes = system.dataset.dataSetToHTML(1, table, "") OrderNo = self.view.params.OrderID fileName = "Purchase Request Number %s.xls" % OrderNo system.perspective.download(fileName, excelbytes)

I think it´s a combination of:  
data = system.dataset.toDataSet(header, data)  
data = system.dataset.toExcel(True, [data])

---

_[View the full topic](https://forum.inductiveautomation.com/t/exporting-table-to-csv-with-formated-columns/108357)._