Export to csv/excel from kibana

FYI : How to download data in CSV from Kibana:

In Kibana--> 1. Go to 'Discover' in left side

2. Select Index Field (based on your dashboard data) (*** In case if you are not sure which index to select-->go to management tab-->Saved Objects-->Dashboard-->select dashboard name-->scroll down to JSON-->you will see the Index name )

3. left side you see all the variables available in the data-->click over the variable name that you want to have in csv-->click add-->this variable will be added on the right side of the columns avaliable

4. Top right section of the kibana-->there is the time filter-->click -->select the duration for which you want the csv

5. Top upper right -->Reporting-->save this time/variable selection with a new report-->click generate CSV

6. Go to 'Management' in left side--> 'Reporting'-->download your csv

To export data to csv/excel from Kibana follow the following steps:-

1. Click on Visualize Tab & select a visualization (if created). If not created create a visualziation.

2. Click on caret symbol (^) which is present at the bottom of the visualization.

3. Then you will get an option of Export:Raw Formatted as the bottom of the page.

Please find below attached image showing Export option after clicking on caret symbol.

In Kibana 6.5, you can generate CSV under the Share Tab -> CSV Reports.

The request will be queued. Once the CSV is generated, it will be available for download under Management -> Reporting