Export to csv/excel from kibana

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.

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