# Export Filtered Dataset to CSV

**URL:** <https://forum.inductiveautomation.com/t/export-filtered-dataset-to-csv/93363>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 17, 2024, 11:10pm UTC](https://forum.inductiveautomation.com/t/export-filtered-dataset-to-csv/93363 "2024-07-17T23:10:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rupali\_Sarathy](https://avatars.discourse-cdn.com/v4/letter/r/c4cdca/32.png) [@Rupali\_Sarathy](https://forum.inductiveautomation.com/u/Rupali_Sarathy)\
**Post date:** [July 17, 2024, 11:10pm UTC](https://forum.inductiveautomation.com/t/export-filtered-dataset-to-csv/93363/1 "2024-07-17T23:10:51Z")

</div>

In my Perspective project, a dataset is generated based on a user input, which can then be exported to a CSV.

However, I also allow the user to "filter" the dataset by allowing them to select which columns they want visible. Essentially, this just makes the selected columns "NOT visible".

When exporting to CSV, the WHOLE dataset is exported, including the hidden columns. Is there any way to exclude these hidden columns?

---

<div class="post-metadata">

**Author:** ![simeonw](https://avatars.discourse-cdn.com/v4/letter/s/4da419/32.png) [@simeonw](https://forum.inductiveautomation.com/u/simeonw)\
**Post date:** [July 18, 2024, 2:11am UTC](https://forum.inductiveautomation.com/t/export-filtered-dataset-to-csv/93363/2 "2024-07-18T02:11:43Z")

</div>

If it is a dataset (not any array of data), then you can use the built-in system function for filtering columns:

> **[system.dataset.filterColumns | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-filterColumns)**
>
> Takes a dataset and returns a view of the dataset containing only the columns found within the given list of columns.

It should then be straight forward enough to export it using _system.dataset.exportCSV_