# Extract excel/csv file from database query browser

**URL:** <https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484>\
**Category:** Ignition\
**Tags:** database\
**Created:** [February 9, 2024, 4:12pm UTC](https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484 "2024-02-09T16:12:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lorenzo\_Marta](https://avatars.discourse-cdn.com/v4/letter/l/a87d85/32.png) [@Lorenzo\_Marta](https://forum.inductiveautomation.com/u/Lorenzo_Marta)\
**Post date:** [February 9, 2024, 4:12pm UTC](https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484/1 "2024-02-09T16:12:44Z")

</div>

Hi everyone,  
I need to extract an excel or csv file from database. Currently, I selected data from Database Query Browser and I saved data by coping and pasting them in an excel file. Is it possible to generate directly a file and to download it? How can I do it?  
Thanks in advance.

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [February 9, 2024, 8:00pm UTC](https://forum.inductiveautomation.com/t/extract-excel-csv-file-from-database-query-browser/85484/2 "2024-02-09T20:00:36Z")

</div>

In a script, use a named query to fetch the data, `system.dataset.toExcel()` to convert it and either `system.file.writeFile()` for vision or `system.perspective.download()` for perspective to get the file to the end user.