Can we export all search result data in Kibana?

Question

I am trying to export all search result data in Kibana 5. But it's only exporting count of the result. Is there any way to export all data in CSV format in Kibana?

Tried so far

1. Clicked on symbol (^) at the bottom of search result visualization.
2. Tried with "Raw" and "Formatted" option both.
3. Data is exporting in CSV format (attached image below) but it's displaying total count of the search result. But it should export all 65001 result.

Getting Output:

Answer 1

This is a very longstanding feature request (going back to 2014) with Kibana; see their issue tracker. For whatever reasons they seem to be having trouble with implementing it.

If you only need a subset of your fields exported, a workaround is to create a visualization of the fields that you need and export using the buttons in the visualization section; these work as you would expect. The downside to this is that if you need very many fields you will end up with complex and/or multiple visualizations.

If you don't mind installing another thing, there is a Kibana fork called Kibi which claims to support this, among other useful things. I can't say for sure, as it doesn't run easily for me on the remote ES cluster I am working with right now, but you may have better luck.