# Export CSV limited to 500 records **URL:** \ **Category:** Kibana\ **Created:** [August 29, 2019, 9:12pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420 "2019-08-29T21:12:34Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![russellpetrichsophos](https://avatars.discourse-cdn.com/v4/letter/r/85e7bf/32.png) [@russellpetrichsophos](https://discuss.elastic.co/u/russellpetrichsophos)\ **Post date:** [August 29, 2019, 9:12pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/1 "2019-08-29T21:12:34Z")
Hello Kibana Team, I'm using Kibana 6.3.2 and I'm trying to export the results of a saved search with over 200k hits. However, when I click "Export" only the first 500 hits are included in the exported CSV:[Kibana\_ExportCsvLimitation|690x284](https://discuss.elastic.co/uploads/short-url/glc8mx0PdXCNfUdrObUMUITSnvc.png) How do I export all 200k+ results to the exported CSV? -Russell ---
**Author:** ![mikecote](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mikecote/32/58549_2.png) [@mikecote](https://discuss.elastic.co/u/mikecote)\ **Post date:** [August 30, 2019, 3:33pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/2 "2019-08-30T15:33:12Z")
Hi @russellpetrichsophos, Is your exported file size around 10MB? If so, I think the export has reached a file size limit that defaults to 10MB. There would be server logs about `max Size Reached`. You can change this limit by changing the `xpack.reporting.csv.maxSizeBytes` setting in Kibana and restarting the server. That limit exists to prevent large exports from causing performance and storage issues. Mike. ---
**Author:** ![russellpetrichsophos](https://avatars.discourse-cdn.com/v4/letter/r/85e7bf/32.png) [@russellpetrichsophos](https://discuss.elastic.co/u/russellpetrichsophos)\ **Post date:** [August 30, 2019, 6:28pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/3 "2019-08-30T18:28:42Z")
Hey @mikecote, Thanks for responding. No it's only 562kb - not even close to 10 MB. -Russell P.S. I didn't receive an email notifying me of your reply to this post. I wouldn't have noticed the update if I hadn't logged back into my Elastic account to check on this. I'm "watching" this topic. ---
**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\ **Post date:** [August 30, 2019, 8:02pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/4 "2019-08-30T20:02:59Z")
Hi Russel, the problem might be that you aren't using the official Kibana distributable from Elastic. I pulled down version 6.3.2 of the Elastic stack from Docker and CSV Export from Discover. This is what you would see if you had the official code: ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/4/54e15d8aea0f6e3753378ae61b4f09c05b43e98f.png) I believe the reason you are not seeing the `Reporting` tab and have `Export` instead is because you cluster is provided by [Logz.io](http://Logz.io) and they can not lease the Elastic commercial features (X-Pack) to you per license restrictions. Kibana Reporting with X-Pack does scan & scroll search to the Elasticsearch back-end, and concatenates the results into a CSV. As @mikecote mentioned, that potentially creates very large CSV files. ---
**Author:** ![russellpetrichsophos](https://avatars.discourse-cdn.com/v4/letter/r/85e7bf/32.png) [@russellpetrichsophos](https://discuss.elastic.co/u/russellpetrichsophos)\ **Post date:** [August 30, 2019, 9:12pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/5 "2019-08-30T21:12:22Z")
Hello @tsullivan, Thank you for your response. I'll take this information back to my team to discuss options. Thanks, -Russell ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 27, 2019, 9:12pm UTC](https://discuss.elastic.co/t/export-csv-limited-to-500-records/197420/6 "2019-09-27T21:12:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.