# How to make a table like Excel sheet with Kibana? **URL:** \ **Category:** Kibana\ **Created:** [July 16, 2015, 5:29am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687 "2015-07-16T05:29:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![cherah30](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cherah30](https://discuss.elastic.co/u/cherah30)\ **Post date:** [July 16, 2015, 5:29am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/1 "2015-07-16T05:29:12Z")
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 ---
**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\ **Post date:** [July 16, 2015, 7:16am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/2 "2015-07-16T07:16:58Z")
The issue below would help your use case. It's currently aimed at Kibana 4.3. > ---
**Author:** ![cherah30](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cherah30](https://discuss.elastic.co/u/cherah30)\ **Post date:** [July 16, 2015, 12:34pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/3 "2015-07-16T12:34:30Z")
> [@magnusbaeck](#): > > 4.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](https://github.com/elastic/kibana/issues/1992)). ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [July 16, 2015, 1:07pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/4 "2015-07-16T13:07:48Z")
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/discover.html#document-data) [https://www.elastic.co/guide/en/kibana/current/data-table.html](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. ![](https://us1.discourse-cdn.com/elastic/original/2X/0/0753702b0f337d83e959447377b6c32be0d9bb93.png) ---
**Author:** ![cherah30](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cherah30](https://discuss.elastic.co/u/cherah30)\ **Post date:** [July 16, 2015, 2:08pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/5 "2015-07-16T14:08:25Z")
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? ![](https://us1.discourse-cdn.com/elastic/original/2X/0/05e92915bf6533af4836d217a8ec42c66ba4671b.png) ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [July 16, 2015, 5:43pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/6 "2015-07-16T17:43:37Z")
Yeah, export of data tables from Discover is still on the roadmap: [https://github.com/elastic/kibana/issues/1992](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: ![](https://us1.discourse-cdn.com/elastic/original/2X/5/5be4bc8fa51928fcfbb7dfb11a2850a049c2cd75.png) ---
**Author:** ![chinmoyd](https://avatars.discourse-cdn.com/v4/letter/c/e495f1/32.png) [@chinmoyd](https://discuss.elastic.co/u/chinmoyd)\ **Post date:** [December 20, 2015, 5:40pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/7 "2015-12-20T17:40:38Z")
I have installed Kibana 4.3.1. Can you please help in getting the export to CSV format from Discover or Visualization or Dashboard? ---
**Author:** ![chinmoyd](https://avatars.discourse-cdn.com/v4/letter/c/e495f1/32.png) [@chinmoyd](https://discuss.elastic.co/u/chinmoyd)\ **Post date:** [December 20, 2015, 5:48pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/8 "2015-12-20T17:48:18Z")
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? ---
**Author:** ![Khalah\_Jones\_Golden](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/khalah_jones_golden/32/7169_2.png) [@Khalah\_Jones\_Golden](https://discuss.elastic.co/u/Khalah_Jones_Golden)\ **Post date:** [December 21, 2015, 7:18pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/9 "2015-12-21T19:18:25Z")
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 ---
**Author:** ![janakg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/janakg/32/6821_2.png) [@janakg](https://discuss.elastic.co/u/janakg)\ **Post date:** [December 23, 2015, 8:30pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/10 "2015-12-23T20:30:07Z")
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? > **[Elasticsearch: CSV exporter for Kibana Discover](https://minewhat.com/blog/elasticsearch-csv-exporter-for-kibana-discover/)** > > Missing CSV export feature for Elasticsearch on Kibana Dashboard. Install this chrome plugin, go to the Kibana Discover tab and start exporting search results as CSV files. ---
**Author:** ![zetian](https://avatars.discourse-cdn.com/v4/letter/z/f14d63/32.png) [@zetian](https://discuss.elastic.co/u/zetian)\ **Post date:** [December 24, 2015, 4:45pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/11 "2015-12-24T16:45:01Z")
PowerQuery allows import of query results directly into Excel. It is a plugin in earlier versions of Excel and part of the product now. ---
**Author:** ![janakg](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/janakg/32/6821_2.png) [@janakg](https://discuss.elastic.co/u/janakg)\ **Post date:** [December 29, 2015, 7:26am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/12 "2015-12-29T07:26:03Z")
We have updated the CSV export plugin (v0.2) to work with Kibana 4.1.x > **[Elasticsearch: CSV exporter for Kibana Discover](https://minewhat.com/blog/elasticsearch-csv-exporter-for-kibana-discover/)** > > Missing CSV export feature for Elasticsearch on Kibana Dashboard. Install this chrome plugin, go to the Kibana Discover tab and start exporting search results as CSV files. ---
**Author:** ![Abhishek\_Anand](https://avatars.discourse-cdn.com/v4/letter/a/9fc348/32.png) [@Abhishek\_Anand](https://discuss.elastic.co/u/Abhishek_Anand)\ **Post date:** [July 21, 2016, 6:48pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/13 "2016-07-21T18:48:32Z")
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. ![](https://us1.discourse-cdn.com/elastic/original/2X/e/eaa4c5b65dd75ae7142755e742c6fadbe7dd9b5c.png) 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. ![](https://us1.discourse-cdn.com/elastic/original/2X/9/954fa357416626e6205b5d23c67b4eac40a1da4a.png) Quick hack, but worked for me. ---
**Author:** ![hcira77](https://avatars.discourse-cdn.com/v4/letter/h/cab0a1/32.png) [@hcira77](https://discuss.elastic.co/u/hcira77)\ **Post date:** [August 10, 2016, 7:46pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/14 "2016-08-10T19:46:40Z")
You can use this chrome plugin to export the data: [https://chrome.google.com/webstore/detail/elasticsearch-csv-exporte/kjkjddcjojneaeeppobfolgojhohbpjn?hl=en](https://chrome.google.com/webstore/detail/elasticsearch-csv-exporte/kjkjddcjojneaeeppobfolgojhohbpjn?hl=en) ---
**Author:** ![Sindhuja\_Krishnan](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@Sindhuja\_Krishnan](https://discuss.elastic.co/u/Sindhuja_Krishnan)\ **Post date:** [August 16, 2016, 11:03am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/15 "2016-08-16T11:03:33Z")
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](https://www.gangboard.com/business-intelligence-training/qlikview-training) data through bi or try to use [AWS](https://www.gangboard.com/cloud-computing-training/aws-training) for any kind of storage data ---
**Author:** ![vikas\_J](https://avatars.discourse-cdn.com/v4/letter/v/7ba0ec/32.png) [@vikas\_J](https://discuss.elastic.co/u/vikas_J)\ **Post date:** [August 16, 2016, 5:08pm UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/16 "2016-08-16T17:08:25Z")
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. ---
**Author:** ![EthanStark](https://avatars.discourse-cdn.com/v4/letter/e/d6d6ee/32.png) [@EthanStark](https://discuss.elastic.co/u/EthanStark)\ **Post date:** [June 7, 2017, 11:16am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/17 "2017-06-07T11:16:36Z")
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. ---
**Author:** ![Syed\_Qasim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/syed_qasim/32/20354_2.png) [@Syed\_Qasim](https://discuss.elastic.co/u/Syed_Qasim)\ **Post date:** [July 24, 2017, 6:34am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/18 "2017-07-24T06:34:38Z")
By default settings are available in it. ---
**Author:** ![Azhar\_Uddin1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/azhar_uddin1/32/98900_2.png) [@Azhar\_Uddin1](https://discuss.elastic.co/u/Azhar_Uddin1)\ **Post date:** [June 22, 2022, 11:47am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/29 "2022-06-22T11:47:44Z")
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** ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 4, 2022, 4:02am UTC](https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687/30 "2022-11-04T04:02:58Z")