# Sorting upon exporting table data

**URL:** <https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111>\
**Category:** Ignition\
**Created:** [March 5, 2014, 11:27pm UTC](https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111 "2014-03-05T23:27:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasongrant15](https://avatars.discourse-cdn.com/v4/letter/j/51bf81/32.png) [@jasongrant15](https://forum.inductiveautomation.com/u/jasongrant15)\
**Post date:** [March 5, 2014, 11:27pm UTC](https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111/1 "2014-03-05T23:27:06Z")

</div>

I am trying to sort (ASC) from a table in ignition. How can I do this. My MYSQL query that displays the data is already sorting it ASC however when I pull the data up in excel it is DESC. Also, is it possible to export the data as it is being currently being displayed by the end user. For example, if the user sorts it by date and then exports it can I have it import into excel in the same way that it was being sorted?

Thanks,

Jason Foster

---

<div class="post-metadata">

**Author:** ![jasongrant15](https://avatars.discourse-cdn.com/v4/letter/j/51bf81/32.png) [@jasongrant15](https://forum.inductiveautomation.com/u/jasongrant15)\
**Post date:** [April 10, 2014, 4:30pm UTC](https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111/2 "2014-04-10T16:30:25Z")

</div>

Any idea on how this could be accomplished?

Thanks.

Jason

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [April 10, 2014, 7:58pm UTC](https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111/3 "2014-04-10T19:58:25Z")

</div>

how are you getting it from the table to Excel?

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [June 2, 2014, 9:58pm UTC](https://forum.inductiveautomation.com/t/sorting-upon-exporting-table-data/8111/4 "2014-06-02T21:58:53Z")

</div>

Table component sorting is not reflected in the underlying dataset. If it is the table’s dataset (or any system dataset) that you are trying to export, you can first sort it with system.dataset.sort ([inductiveautomation.com/supp … t\_sort.htm](http://www.inductiveautomation.com/support/usermanuals/ignition/index.html?system_dataset_sort.htm))