# Csv file export with 1 million records(approx 1 gb size) in kibana reporting

**URL:** https://discuss.elastic.co/t/csv-file-export-with-1-million-records-approx-1-gb-size-in-kibana-reporting/222892
**Category:** Kibana
**Created:** [March 10, 2020, 9:17am UTC](https://discuss.elastic.co/t/csv-file-export-with-1-million-records-approx-1-gb-size-in-kibana-reporting/222892 "2020-03-10T09:17:34Z")
**Posts on this page:** 1
**Showing post:** 6

<div class="post-metadata">

### Author: ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)
#### Post date: [March 13, 2020, 7:21pm UTC](https://discuss.elastic.co/t/csv-file-export-with-1-million-records-approx-1-gb-size-in-kibana-reporting/222892/6 "2020-03-13T19:21:15Z")

</div>

```
input {
   elasticsearch {
      hosts => ["host1:9200", "host2:9200"]
      index => "index-2020"
      user => "elastic"
      password => "xxxx"
   }
}

filter {
mutate { remove_field => ["field1","field2","@timestamp","@version"] }
}

output {
   csv {
      fields => ["myfield1","myfield2","myfield3"]
      csv_options => { "col_sep" => "," }
      path => "/data01/csv_files/test.csv"
    }
  stdout { codec => rubydebug }
}

```

Pretty much same what previous use said

[https://discuss.elastic.co/t/how-to-export-csv-in-kibana-7-5-with-more-then-1-million-row/214526/4](https://discuss.elastic.co/t/how-to-export-csv-in-kibana-7-5-with-more-then-1-million-row/214526/4)

---

_[View the full topic](https://discuss.elastic.co/t/csv-file-export-with-1-million-records-approx-1-gb-size-in-kibana-reporting/222892)._