Export to csv excel from kibana

Question

I am building a proof of concept using Elasticsearch Logstash and Kibana for one of my projects  I have the dashboard with the graphs working without any issue  One of the requirements for my project is the ability to download the file csv excel    In kibana the only option i saw for downloading the file is by clicking on edit button on the visualization created  Is it possible to add a link on the dashboard that would allow users to download the file without going into the edit mode  And secondly I would like to disable hide the edit mode for anyone other than me who views the dashboard  Thanks

User · Answer

To export data to csv excel from Kibana follow the following steps -   Click on Visualize Tab  amp  select a visualization  if created   If not created create a visualziation  Click on caret symbol     which is present at the bottom of the visualization  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

User · Answer

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

User · Answer

FYI   How to download data in CSV from Kibana   In Kibana--  1   Go to  Discover  in left side   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   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 Top right section of the kibana-- there is the time filter-- click -- select the duration for which you want the csv Top upper right -- Reporting-- save this time variable selection with a new report-- click generate CSV Go to  Management  in left side--   Reporting -- download your csv

User · Answer

I totally missed the export button at the bottom of each visualization  As for read only access   Shield from Elasticsearch might be worth exploring

[elasticsearch] Export to csv/excel from kibana

Examples related to elasticsearch

Examples related to logstash

Examples related to export-to-csv

Examples related to kibana-4