# Exporting CSV from save search in dashboard shows blank values

**URL:** <https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774>\
**Category:** Kibana\
**Created:** [December 23, 2021, 7:37am UTC](https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774 "2021-12-23T07:37:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amy\_Peng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amy_peng/32/77531_2.png) [@Amy\_Peng](https://discuss.elastic.co/u/Amy_Peng)\
**Post date:** [December 23, 2021, 7:37am UTC](https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774/1 "2021-12-23T07:37:46Z")

</div>

Hello Team,

I was using **kibana 7.13.1** and wanted to export CSV from saved search in dashboard.  
But the exported CSV file only showed timestamp and column fields name but with blank values.  
I also tried `Discover -- open -- my search -- share -- generate CSV`, it had the same problem (blank values) for those columns.

I found a similar discussion here, but my fields are mapped as `text`, which still occurred issues.

> [@Export to CSV shows blank fields](https://discuss.elastic.co/t/export-to-csv-shows-blank-fields/292218):
>
> I'm exporting data from a view created from the discover module. In the data there is a field that is filled only in some records, less than 10% of records have this field filled. When I filter or export the entire listing, the field is not filled in the csv file. If I export the list making a filter to bring only records that have the field filled in, then the csv list is exported correctly with the field filled in. Analyzing the logs of kibana and Elasticsearch no errors are presented that co…

And also, the error log only showed warning messages like below:

```auto
{"type":"log","@timestamp":"2021-12-21T08:51:42-03:00","tags":["warning","plugins","reporting","csv_searchsource_immediate","csv_searchsource_immediate","execute-job"],"pid":2049,"message":"CSV may contain formulas whose values have been escaped"}

```

There was no error log about `TypeError` as issue mentioned.

I tried exporting smaller file that didn't larger than `10mb` but the problem was still the same.  
Is there any solution about these blank values?

Thank you,  
Amy

---

<div class="post-metadata">

**Author:** ![dosant](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dosant/32/64489_2.png) [@dosant](https://discuss.elastic.co/u/dosant)\
**Post date:** [December 23, 2021, 3:07pm UTC](https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774/2 "2021-12-23T15:07:13Z")

</div>

This does look like this bug report [Saved search won't export correctly from dashboard · Issue #101333 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/101333)  
I think this should be fixed in recent versions. There were a lot of fixed in reporting recently.

Could you try to reproduce with a newer version?

---

<div class="post-metadata">

**Author:** ![Amy\_Peng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/amy_peng/32/77531_2.png) [@Amy\_Peng](https://discuss.elastic.co/u/Amy_Peng)\
**Post date:** [December 27, 2021, 6:47am UTC](https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774/3 "2021-12-27T06:47:17Z")

</div>

Hi Dosov,

Thank you for your reply. It seems a bit the same with this bug report, but my save search from discover still has problem.

I'll try to update to newer version and reproduce again, and let you know what happen.

Thanks,  
Amy

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 24, 2022, 6:47am UTC](https://discuss.elastic.co/t/exporting-csv-from-save-search-in-dashboard-shows-blank-values/292774/4 "2022-01-24T06:47:46Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.