How to make a table like Excel sheet with Kibana?

Elastic Stack Kibana
1

I apologize for my beginner question.
starting from "Discover" part of kibana, I could select some fields, filtering, ...etc, then I recorded the resultat of my research.
Now, I would like to show the result of my search in a table (like a simple excel sheet).
It seems easy as needed, but I do not find a way to do it in Kibana.

Would you have an idea?

Thanks in advance

2 Likes
2

The issue below would help your use case. It's currently aimed at Kibana 4.3.

3

Thanks Magnus ... I have already installed version 4.3 but I can not find how to export the result of a search in csv. I don't understand too rashidkpc response above "Now que le server is based nodejs it shoulds be fairly easy to add a route with a size parameter That has loads savedSearch object icts and export results to CSV" (Export Documents as CSV · Issue #1992 · elastic/kibana · GitHub).

4

Version 4.3 is not yet available - the latest shipping version is 4.1.1.

Are you asking for a CSV export or a way to represent results in data table in the Kibana UI itself?

For building data tables in Kibana itself, you can do that both in Discover and in Visualize:
https://www.elastic.co/guide/en/kibana/current/discover.html#document-data
https://www.elastic.co/guide/en/kibana/current/data-table.html

For CSV export, you can actually export result sets behind individual visualizations. This doesn't export all the raw data, just the summary responses, but may be sufficient for some use cases.

5

Thanks Tanya.
As summarized in the image below, I rather search a way to export my result above in a csv file (if we had more Pdf and Excel is even better).
Is there a way to make it in Kibana? ElasticSearch?

Pasted image1187×447 84.1 KB

6

Yeah, export of data tables from Discover is still on the roadmap: https://github.com/elastic/kibana/issues/1992

However, if you can create a useful summary of that data in Visualize, you can export that today:

Screen Shot 2015-07-16 at 10.41.49 AM.png2518×1304 207 KB

7

I have installed Kibana 4.3.1. Can you please help in getting the export to CSV format from Discover or Visualization or Dashboard?

8

I am looking for an option to export all the fields in the search (in Discover tab ), not just the summary option. Is it possible in Kibana?

9

Hey Chinmoy,

You still can't export individual documents in a csv like how you see in Discover, however if you open up the spy panel, you shall see an export button at the bottom.

If you really want to just export documents or certain fields from documents, why don't you directly query ES?

Peace,
Khalah

10

We have written a chrome plugin, it injects the CSV export functionality in Kibana Discover tab. We know Kibana team is trying to solve this problem in a holistic way, so we thought this quick hack might help users like us. Let us know, what you think?

1 Like
11

PowerQuery allows import of query results directly into Excel. It is a plugin in earlier versions of Excel and part of the product now.

12

We have updated the CSV export plugin (v0.2) to work with Kibana 4.1.x

1 Like
13

I got a quick hack to this problem. I think there are better ways but for some quick exports of limited number of rows (<500).
You can just select whatever you see in the Discover tab.

Screen Shot 2016-07-21 at 2.47.40 PM.png818×429 65.3 KB

It goes to the clipboard in csv format, so now when you paste it in MS Excel, it automatically formats it in seperate rows and columns.
Screen Shot 2016-07-21 at 2.47.28 PM.png1166×442 66.3 KB

Quick hack, but worked for me.

1 Like
14

You can use this chrome plugin to export the data: https://chrome.google.com/webstore/detail/elasticsearch-csv-exporte/kjkjddcjojneaeeppobfolgojhohbpjn?hl=en

1 Like
15

I totally missed the export button at the bottom of each visualization. As for read only access...Shield from Elastic search might be worth exploring. That's why am don't want to set the data like this here i prefer to export Qlikview
data through bi or try to use AWS for any kind of storage data

16

I have a search table added into a dashboard. Is it possible to export the contents in this search table from the dashboard view rather than going to Discover view to export the same.

17

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.

18

By default settings are available in it.

29

hey guys I am also looking to export data into Excel sheet
I was thinking it would be better to have a button export and can select what fields needed to be exported inside a custom plugin