Elasticsearch: CSV exporter for Kibana Discover
Ram Ganesan
|
Dec 23, 2015
|
ANALYTICS, TECHNICAL
Why?
We use Elasticsearch + Kibana for data analysis, and we love it. Very often, we share the results of our analysis with the team. Kibana expects us to visualize data in the form of graphs and charts, but some use cases are more tuned for data-table with raw filtered query results. Surprisingly, there is no way to export CSV or create a data table in Kibana. A quick Google search gave these results, not only us; many are waiting for this feature.
https://github.com/elastic/kibana/issues/1992
https://discuss.elastic.co/t/how-to-make-a-table-like-excel-sheet-with-kibana/25687
Solution:
We did a quick hack to GTD in the startup way; we have written a chrome plugin, it injects the CSV export functionality in Kibana Discover tab.
Business Users: Go ahead install this plugin from the chrome web store.
Developers: Here is the Github link, and it is an open source project under MIT license. Please go ahead and tweak for you need. It would be great if you can provide a link back to this blog from the places you refer.
https://github.com/minewhat/es-csv-exporter
Future: We can write an elasticsearch plugin and pair it with this chrome plugin to make it powerful. We know Kibana team is trying to solve this problem in a holistic way, it takes time, so we thought this might help users like us. Let us know, what you think?