# Exporting index data into csv from kibana
**URL:** https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761
**Category:** Kibana
**Created:** [November 13, 2019, 6:23pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761 "2019-11-13T18:23:16Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@sarvendras](https://discuss.elastic.co/u/sarvendras)
#### Post date: [November 13, 2019, 6:23pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/1 "2019-11-13T18:23:16Z")
Hello All,
Is there any option to export index data into csv file from kibana in latest elasticsearch 7.4
Thanks
Sarvendra
---
### Author:  [@sarvendras](https://discuss.elastic.co/u/sarvendras)
#### Post date: [November 14, 2019, 9:25am UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/2 "2019-11-14T09:25:16Z")
Thanks i got how to download csv file from saved search in doscover and that csv can be downloaded from Management\>reporting .
I have one query that what is the folder location of this csv file that is stored in kibana server?
I am asking this because we need to do some automation and for that csv location will be input for that.
---
### Author:  [@HARSHINI\_SH](https://discuss.elastic.co/u/HARSHINI_SH)
#### Post date: [November 14, 2019, 12:50pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/3 "2019-11-14T12:50:42Z")
I don't think so it will download all the raw data.Even i'm trying to download data in a give time. For downloading csv kibana has some limitations to download.
---
### Author:  [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [November 14, 2019, 4:25pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/4 "2019-11-14T16:25:18Z")
> [@HARSHINI\_SH](#):
>
> all the raw data.Even i'm trying to download data in a give time. For downloading csv kibana has s
How are you downloading? What are the errors in the logs ? What version of the stack are you on ? screenshots/logs would help.
You can try exporting any Saved Searches from Discover. After creating a Saved Search, exporting can be found under **Reporting \> Generate CSV** :
Thanks
Rashmi
---
### Author:  [@sarvendras](https://discuss.elastic.co/u/sarvendras)
#### Post date: [November 15, 2019, 6:29am UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/5 "2019-11-15T06:29:31Z")
Hi @rashmi Thanks for your time to reply.
Please help to let me know before generating csv file where kibana stores this file internally.we need that location for our Project.reason why we need this location is
we need to automate something based on this location for our fruad detection product.We are using kibana on cloud so we dont need to download csv in our local machine instead we need to push this csv from kibana server location to some other system.
Thanks
Sarvendra
---
### Author:  [@Mikhail\_Shustov](https://discuss.elastic.co/u/Mikhail_Shustov)
#### Post date: [November 15, 2019, 10:52am UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/6 "2019-11-15T10:52:55Z")
@sarvendras could your fraud detection system download generated report via Kibana API [https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html#\_use\_a\_script](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html#_use_a_script) ?
---
### Author:  [@sarvendras](https://discuss.elastic.co/u/sarvendras)
#### Post date: [November 15, 2019, 12:26pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/7 "2019-11-15T12:26:50Z")
@Mikhail_Shustov Thanks for the reply..Through this API report generation is placed on queue.But whats the actualy folder path where this filw will be downloaded.How can we check that path.
If kibana server giving option to download the csv file in reporting then kibana must be storing that file somewhere on kibana server.What is that location.
Thanks
Sarvendra
---
### Author:  [@Mikhail\_Shustov](https://discuss.elastic.co/u/Mikhail_Shustov)
#### Post date: [November 15, 2019, 5:07pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/8 "2019-11-15T17:07:36Z")
There aren't stored on the hard drive but in elasticsearch.
When you need to send a request to generate a report, as described in [https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html#\_use\_a\_script](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html#_use_a_script)
The job to generate a report will be queued. The server response contains `path` property with a URL to download the generated report.
Generation may take some time. You can find out the status of the jobs sending a request to`/api/reporting/jobs/info/{jobId}`.
When generation completed you can download the result by that aforementioned `path` URL.
---
### Author:  [@HARSHINI\_SH](https://discuss.elastic.co/u/HARSHINI_SH)
#### Post date: [November 18, 2019, 6:33am UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/9 "2019-11-18T06:33:15Z")
Hi Rashmi,
When i want to generate 1 day data to csv. I'm not able to download entire hits because it says max size reached, contains partial data. (My index data contains above 1 million hits) . what could be the alternate solution to download entire data.
---
### Author:  [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [November 18, 2019, 11:41pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/10 "2019-11-18T23:41:50Z")
am linking you to similar posts which give you a fair idea of how to achieve this: [Retrieving over a million records in Elasticsearch](https://discuss.elastic.co/t/retrieving-over-a-million-records-in-elasticsearch/41339/2)
Hope it helps ,
Thanks
Rashmi
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 16, 2019, 11:41pm UTC](https://discuss.elastic.co/t/exporting-index-data-into-csv-from-kibana/207761/11 "2019-12-16T23:41:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.