Can I Export Data from Kibana in CSS?¶
With Elasticsearch 7.10.2 (with an image version no earlier than 7.10.2_24.3.3_x.x.x), Kibana supports one-click data export in CSV.
Important
A maximum of 10 MB of data can be exported. If the data you want to export exceeds 10 MB, only the first 10 MB is exported.
Any special characters such as =+-@ in exported CSV files may be identified as part of some formulas, leading to data export failures.
On the Discover page of Kibana, choose Share > Data Export in the upper right corner, and select Export CSV.
Figure 1 Exporting data¶
Wait for a few minutes. Then click Download csv in the lower right corner to download the data to the local PC.
Figure 2 Downloading data¶
With Elasticsearch 7.6.2, 7.9.3, and 7.10.2 (the image version is earlier than 24.3.0), the SQL Workbench plug-in is required for exporting data on Kibana.
In SQL Workbench of Kibana, you can run Elasticsearch SQL statements to query data or click Download to export data. You can export 1 to 200 records. By default, 200 records are exported.
Figure 3 SQL Workbench¶