# How to export Kibana search query results to CSV file with more than one million records
**URL:** https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412
**Category:** Kibana
**Created:** [April 3, 2022, 4:00am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412 "2022-04-03T04:00:47Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@fymaterials](https://discuss.elastic.co/u/fymaterials)
#### Post date: [April 3, 2022, 4:00am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412/1 "2022-04-03T04:00:47Z")
I used Kibana to query the index, and use export under resource tab to export query results. How can I export query results if there are million records?
---
### Author:  [@matw](https://discuss.elastic.co/u/matw)
#### Post date: [April 11, 2022, 6:44am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412/2 "2022-04-11T06:44:33Z")
Hi
In Kibana you can export your data in Discover to CSV, what's the resource tab you're referring to?
Thx and best,
Matthias
---
### Author:  [@fymaterials](https://discuss.elastic.co/u/fymaterials)
#### Post date: [April 14, 2022, 3:29am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412/3 "2022-04-14T03:29:18Z")
Yes, in discover, Click Share -\> Click Export to CSV
But if the results has millions of records and resulting big csv file, it is over the discover export limit. Any solution to this?
Feng
---
### Author:  [@hocho](https://discuss.elastic.co/u/hocho)
#### Post date: [April 14, 2022, 7:39am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412/4 "2022-04-14T07:39:27Z")
Hello,
From what I know Kibana have a byte limit and is not based on number of documents.
I believe this can help you =\>
> **[Reporting settings in Kibana | Kibana Guide \[8.11\] | Elastic](https://www.elastic.co/guide/en/kibana/current/reporting-settings-kb.html#reporting-csv-settings)**
> [@Kibana Document download limit at 10,000](https://discuss.elastic.co/t/kibana-document-download-limit-at-10-000/300010/3):
>
> In advanced settings , there is no option to select the number of rows to be downloaded. By default , when i save a search and download it is still 10,000 documents.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 12, 2022, 7:40am UTC](https://discuss.elastic.co/t/how-to-export-kibana-search-query-results-to-csv-file-with-more-than-one-million-records/301412/5 "2022-05-12T07:40:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.