Exporting the discover data (Saved Search) in CSV

Elastic Stack Kibana
1

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

1 Like
2

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
filter.png1213×534 29.3 KB

3

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

4

You need to have X-Pack installed on your machine to get CSV exporting.

5

Thanks a lot for the info marius
Could you please brief me about the X-Pack?

6

You can get more info here:
https://www.elastic.co/products/x-pack
https://www.elastic.co/guide/en/x-pack/current/xpack-introduction.html

7

Thanks a lot
have a great day ahead

8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.