# Export data from kibana dashboard in CSV/Excel
**URL:** https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106
**Category:** Kibana
**Created:** [September 1, 2023, 10:03am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106 "2023-09-01T10:03:45Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@HiteshSingh](https://discuss.elastic.co/u/HiteshSingh)
#### Post date: [September 1, 2023, 10:03am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/1 "2023-09-01T10:03:45Z")
I want to export the records from the kibana dashboard in CSV/Excel.
I have added a table in the dashboard from discover which contains millions of records. I want to download/export these records into CSV/Excel.
Let me know how to do this on Kibana 8.6.2
---
### Author:  [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [September 1, 2023, 10:13am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/2 "2023-09-01T10:13:36Z")
Hi @HiteshSingh,
Do you see an Edit search option in the settings menu, similar to the below?
This option takes you to the discover page, where you can use the CSV report option to export the data:
Hope that helps!
---
### Author:  [@HiteshSingh](https://discuss.elastic.co/u/HiteshSingh)
#### Post date: [September 1, 2023, 10:28am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/3 "2023-09-01T10:28:59Z")
Thanks for the screens. I tried this but was only able to export 3275 records in CSV.
I have 7.4m+ records in that table. How can we download/export all the records.
---
### Author:  [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [September 1, 2023, 10:57am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/4 "2023-09-01T10:57:46Z")
Hi @HiteshSingh,
The limit is relating to the `xpack.reporting.csv.maxSizeBytes` property in Kibana. I would recommend having a look at [this thread](https://discuss.elastic.co/t/reporting-csv-export-reached-the-max-size-and-contains-partial-data/116626/6) and see if you need to increase the limit. I would advise caution though as setting it too high will impact the performance of your Elastic cluster.
Even then I wonder if you will struggle to get the full population out given you're looking to export millions of records. If you're not comfortable exporting in batches by specifying a time range, you could try having a look at the [ODBC driver](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-odbc.html) to access the data directly from Excel.
Let us know if either of those options work out for you.
---
### Author:  [@HiteshSingh](https://discuss.elastic.co/u/HiteshSingh)
#### Post date: [September 1, 2023, 11:45am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/5 "2023-09-01T11:45:48Z")
> [@carly.richmond](#):
>
> xpack.reporting.csv.maxSizeBytes
What is the max bytes that I can set without impacting much on the performance of my Elastic cluster?
Also, how can we determine the time filter here to use it? Since, we are loading complete data at once at the same time.
Please advise.
---
### Author:  [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [September 1, 2023, 12:24pm UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/6 "2023-09-01T12:24:41Z")
> [@HiteshSingh](#):
>
> What is the max bytes that I can set without impacting much on the performance of my Elastic cluster?
It really depends on several factors, [as outlined in the documentation](https://www.elastic.co/guide/en/kibana/current/reporting-settings-kb.html#reporting-csv-settings).
The time filter applied to the data is shown in the timepicker on the Discover dashboard and can be used to narrow the range:
The filter bar to the left can also be used to reduce the row count as well to match a given query.
---
### Author:  [@Rios](https://discuss.elastic.co/u/Rios)
#### Post date: [September 1, 2023, 7:33pm UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/7 "2023-09-01T19:33:37Z")
There is an option to use Logstash. The output in [CSV](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-csv.html) is supported.
---
### Author:  [@HiteshSingh](https://discuss.elastic.co/u/HiteshSingh)
#### Post date: [September 4, 2023, 8:19am UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/8 "2023-09-04T08:19:33Z")
Hi @carly.richmond
Thanks for your information, I will work on this and check the performance.
Meanwhile I perform this, can you please also provide some inputs on [this](https://discuss.elastic.co/t/kibana-login-with-service-account/342130) thread.
---
### Author:  [@Mr.Unal](https://discuss.elastic.co/u/Mr.Unal)
#### Post date: [September 6, 2023, 2:21pm UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/9 "2023-09-06T14:21:25Z")
Hello @carly.richmond
I cannot see " **Edit Search**" option. What could be the reason for this?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 4, 2023, 2:21pm UTC](https://discuss.elastic.co/t/export-data-from-kibana-dashboard-in-csv-excel/342106/10 "2023-10-04T14:21:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.