# Elastic/Kibana data exportaion (over 1b hits)

**URL:** https://discuss.elastic.co/t/elastic-kibana-data-exportaion-over-1b-hits/366402
**Category:** Elasticsearch
**Created:** [September 11, 2024, 10:14am UTC](https://discuss.elastic.co/t/elastic-kibana-data-exportaion-over-1b-hits/366402 "2024-09-11T10:14:54Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [September 11, 2024, 4:28pm UTC](https://discuss.elastic.co/t/elastic-kibana-data-exportaion-over-1b-hits/366402/2 "2024-09-11T16:28:05Z")

</div>

Hi @yzaritskyi,

Welcome back. There is a 10MB limit by default for exporting from Kibana. It can be configured via the [`xpack.reporting.csv.maxSizeBytes`](https://www.elastic.co/guide/en/kibana/current/reporting-settings-kb.html#reporting-csv-settings) setting in kibana.yml for your cluster [as per this thread](https://discuss.elastic.co/t/reporting-generate-csv-maximum-limit/134692). But I would tread carefully there as it can impact performance if set too high.

[This thread](https://discuss.elastic.co/t/is-it-possible-to-generate-or-export-a-csv-from-kibana-dev-tool/343027) gives a couple of options that you could try, including:

1. Writing a script using a language client and a CSV utility, such as Python. There is a [StackOverflow thread here](https://stackoverflow.com/questions/46682018/export-elasticsearch-results-into-a-csv-file) that shares that example.
2. Using Logstash with an [Elasticsearch filter processor](https://www.elastic.co/guide/en/logstash/current/plugins-filters-elasticsearch.html#plugins-filters-elasticsearch-query) and the [CSV output plugin](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-csv.html).
3. Split your query into multiple to export the records across multiple CSV files.

Let us know if any of those options work for you.

---

_[View the full topic](https://discuss.elastic.co/t/elastic-kibana-data-exportaion-over-1b-hits/366402)._
