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.
- 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 dataWait 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.
For details about the Elasticsearch SQL statements used, see Elasticsearch SQL.
Figure 3 SQL Workbench
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot