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

[This](http://stackoverflow.com/questions/18892560/is-there-any-way-in-elasticsearch-to-get-results-as-csv-file-in-curl-api) might be useful. — Jared Dunham, Jan 14 '16 at 15:34
how can I add `export` **CSV** functionality in my custom `plugin` — Azhar Uddin Sheikh, Jul 04 '22 at 12:20

score 46 · Answer 1 · answered Jan 15 '16 at 05:17

46

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

Click on Visualize Tab & 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.

answered Jan 15 '16 at 05:17

Yuvraj Gupta

2,475
16
26

11

Do we option to export all search result data? – Roopendra Nov 17 '16 at 10:50
It will export all the search result data. If you download by clicking on Raw or Formatted, then all the search result will be downloaded. – Yuvraj Gupta Nov 17 '16 at 11:18
4

I tried it but it's not downloading all the data. I am debugging it more else I will asked separate question :) Thanks for your reply. – Roopendra Nov 17 '16 at 11:31
2

Added new [question](http://stackoverflow.com/questions/40653992/can-we-export-all-search-result-data-in-kibana) – Roopendra Nov 17 '16 at 11:42
I don't think its possible to export to csv/excel (or other form of tabular structure) even with Kibana Visualize and Dashboard. – kimbaudi Dec 11 '17 at 21:39
1

This approach allows me to save just aggregated data (e.g. count of matched records). – Karel Marik Aug 18 '20 at 09:35

Pallavi Kalambe · Answer 2 · 2018-06-12T14:41:54.840

43

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

edited Jun 12 '18 at 14:41

answered Jun 12 '18 at 14:35

Pallavi Kalambe

793
8
7

@kleptog X-Pack is not required for this. – ProgramSpree Mar 05 '19 at 10:24
4

"From version 5.0 onward, Reporting is part of X-Pack. For more information, see Reporting from Kibana in the X-Pack Reference." see [here](https://www.elastic.co/guide/en/reporting/current/getting-started.html) – Fabiano Francesconi Mar 20 '19 at 08:51
Reporting also needs to be enabled, see here: https://www.elastic.co/guide/en/kibana/6.5/reporting-settings-kb.html – tzachs Jun 19 '19 at 14:29
2

In Kibana 7.1 I do not see any "Reporting" link and not able to find any download option. Can anyone help with this? I am using AWS Elasticsearch – rupsray Mar 16 '20 at 07:44
@rupsray AWS ES is operating in "Open Source" tier of elastic subscription model. CSV reports are in Basic (free) tier. Thus, it's not enabled. https://www.elastic.co/subscriptions – ssgao Jul 31 '20 at 16:07
1

how to implement this export functionality using api – Azhar Uddin Sheikh Sep 19 '22 at 11:30

score 17 · Answer 3 · answered Dec 23 '19 at 16:56

17

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

answered Dec 23 '19 at 16:56

sandyiit

1,597
3
17
23

Do I need to install X-Pack to do that? – Oksana B Jul 25 '20 at 07:03
I dont believe so – sandyiit Jul 25 '20 at 07:27
3

@OksanaB yes you need X-Pack. It's still free though, but it's not available in non-elastic-hosted solutions, e.g. AWS. – ssgao Jul 31 '20 at 16:09

score 8 · Accepted Answer · answered Jan 14 '16 at 20:20

8

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

answered Jan 14 '16 at 20:20

jsp

2,546
5
36
63

ya..i think kibana has the worst UX ever...i am spending hours on finding a way and I am thinking of wiriting a script to scroll ES and download it my self – Nidhin David Apr 27 '21 at 08:41

Export to csv/excel from kibana

4 Answers4

Linked