# Exporting Queried Data

**URL:** <https://forum.inductiveautomation.com/t/exporting-queried-data/7147>\
**Category:** General Discussion\
**Created:** [August 27, 2013, 12:09am UTC](https://forum.inductiveautomation.com/t/exporting-queried-data/7147 "2013-08-27T00:09:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![quinadler.hgst](https://avatars.discourse-cdn.com/v4/letter/q/c6cbf5/32.png) [@quinadler.hgst](https://forum.inductiveautomation.com/u/quinadler.hgst)\
**Post date:** [August 27, 2013, 12:09am UTC](https://forum.inductiveautomation.com/t/exporting-queried-data/7147/1 "2013-08-27T00:09:28Z")

</div>

Is there a way that I am not thinking of to export a set of queried data to Excel? And in doing so, I could place this script in a button? The tough part, I think, is going to be the user-friendly interface which allows the user to choose the variables that dictate which query he/she wants to be exported. Anyone have any ideas?

---

<div class="post-metadata">

**Author:** ![aidamcg](https://avatars.discourse-cdn.com/v4/letter/a/90db22/32.png) [@aidamcg](https://forum.inductiveautomation.com/u/aidamcg)\
**Post date:** [August 27, 2013, 6:44am UTC](https://forum.inductiveautomation.com/t/exporting-queried-data/7147/2 "2013-08-27T06:44:01Z")

</div>

Two things you should look at in the user manual are the column selector component under reporting and system.dataset.exportExcel from the scripting functions. The column selector will allow a user to add/remove fields from the dataset at run time. This modified dataset can then be exported to excel with script

Aidan

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [September 25, 2013, 11:39pm UTC](https://forum.inductiveautomation.com/t/exporting-queried-data/7147/3 "2013-09-25T23:39:43Z")

</div>

You can also use the Row Selector component to group your data into easy to manage slices. Both of these components require that you have the Reporting module, but you can use other tricks to select rows and columns without it.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [September 27, 2013, 6:29pm UTC](https://forum.inductiveautomation.com/t/exporting-queried-data/7147/4 "2013-09-27T18:29:11Z")

</div>

Hi,

You might also want to check out the [Kymera Office Document Module](http://marketplace.inductiveautomation.com/moduledetail?6&moduleId=73) which provides more robust functions for exporting to excel.

Regards,