# Exporting the discover data (Saved Search) in CSV **URL:** \ **Category:** Kibana\ **Created:** [March 28, 2018, 6:21am UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864 "2018-03-28T06:21:23Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![kishore\_narni](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kishore\_narni](https://discuss.elastic.co/u/kishore_narni)\ **Post date:** [March 28, 2018, 6:21am UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/1 "2018-03-28T06:21:24Z")
Hi all, I am very new to kibana and started learning the basics. Currently I am working in kibana 6. My requirement i have to create a search in which we can sort or filter on any column we and export the search data to CSV or Excel. I am finding the option for sorting & exporting in visualization, but my requirement here is i have to provide the sorting, filtering and exporting option on a saved search. Basically when the user opens the saved search he should to able to sort or filetr on any column he want and export the data to CSV. Any suggestion or help on this will be really helpful to me. Thanks in advance ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [March 28, 2018, 12:31pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/2 "2018-03-28T12:31:34Z")
Hello, For filtering the users can just click on the small magnifying glass with the + for filtering for that value or the one with the - for filtering out the value. You can see it in the image below, they show up on mouseover on the value. ![filter](https://us1.discourse-cdn.com/elastic/original/3X/4/a/4a2ff41c83552aaffcf40a895ce09a2a76b25443.png) ---
**Author:** ![kishore\_narni](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kishore\_narni](https://discuss.elastic.co/u/kishore_narni)\ **Post date:** [March 28, 2018, 6:37pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/3 "2018-03-28T18:37:49Z")
Hi marius, Thanks a lot for the reply. Now i am clear with the filtering and sorting part. My Main concern export the search data into CSV file. In the Kibana configured on my client machine iam able to find this export data option in visualization & dashboard but not in discover. I have to export the data i got in discover. I have gone through various forums and some other youtube tutorials i have seen one option called reporting through which they are generating CSV file, but iam unable to see that option in the kibana configured on my client machine. Could you please help me on this ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [March 28, 2018, 6:40pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/4 "2018-03-28T18:40:27Z")
You need to have X-Pack installed on your machine to get CSV exporting. ---
**Author:** ![kishore\_narni](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kishore\_narni](https://discuss.elastic.co/u/kishore_narni)\ **Post date:** [March 28, 2018, 6:48pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/5 "2018-03-28T18:48:47Z")
Thanks a lot for the info marius Could you please brief me about the X-Pack? ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [March 28, 2018, 7:01pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/6 "2018-03-28T19:01:34Z")
You can get more info here: [https://www.elastic.co/products/x-pack](https://www.elastic.co/products/x-pack) [https://www.elastic.co/guide/en/x-pack/current/xpack-introduction.html](https://www.elastic.co/guide/en/x-pack/current/xpack-introduction.html) ---
**Author:** ![kishore\_narni](https://avatars.discourse-cdn.com/v4/letter/k/b4bc9f/32.png) [@kishore\_narni](https://discuss.elastic.co/u/kishore_narni)\ **Post date:** [March 28, 2018, 7:02pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/7 "2018-03-28T19:02:22Z")
Thanks a lot have a great day ahead ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 25, 2018, 7:02pm UTC](https://discuss.elastic.co/t/exporting-the-discover-data-saved-search-in-csv/125864/8 "2018-04-25T19:02:29Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.