# Exporting to CSV missing values in fields

**URL:** <https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389>\
**Category:** Kibana\
**Created:** [June 29, 2021, 9:48pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389 "2021-06-29T21:48:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jasieltego](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasieltego/32/77950_2.png) [@jasieltego](https://discuss.elastic.co/u/jasieltego)\
**Post date:** [June 29, 2021, 9:48pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/1 "2021-06-29T21:48:19Z")

</div>

Hi All,

Wondering if I can get some help. Currently from Kibana I'm running some Discover Reports, I can see all the fields and information in Kibana, however when I export it to CSV, 4 columns out of 6 have no values at all, but the values show in Kibana Interface. Anyway how to fix this.  
Thanks

---

<div class="post-metadata">

**Author:** ![JLeysens](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jleysens/32/67404_2.png) [@JLeysens](https://discuss.elastic.co/u/JLeysens)\
**Post date:** [June 30, 2021, 1:33pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/2 "2021-06-30T13:33:45Z")

</div>

Hi @jasieltego ! Would you please provide the version of the stack you are running?

---

<div class="post-metadata">

**Author:** ![jasieltego](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasieltego/32/77950_2.png) [@jasieltego](https://discuss.elastic.co/u/jasieltego)\
**Post date:** [June 30, 2021, 4:54pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/3 "2021-06-30T16:54:28Z")

</div>

Hi @JLeysens , I went to Kibana and DevTools and ran a GET command , it states Version number is 7.13.2  
I don't know if this is just the version for Elastic Search or the whole stack.  
Let me know if this is not the information you requested

---

<div class="post-metadata">

**Author:** ![JLeysens](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jleysens/32/67404_2.png) [@JLeysens](https://discuss.elastic.co/u/JLeysens)\
**Post date:** [June 30, 2021, 7:37pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/4 "2021-06-30T19:37:46Z")

</div>

There are probably a few things we will need to look at:

- Does this happen for a specific index pattern (or set of objects)? If you limit your discover search to a single object (perhaps scope the search to that object ID) and generate the CSV does it still only have 4 out 6 columns empty?
- Are you able to access the Kibana logs to see what is happening while the CSV report is being generated? It might contain errors that could give us a clue.

---

<div class="post-metadata">

**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:** [June 30, 2021, 7:49pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/5 "2021-06-30T19:49:28Z")

</div>

Hi, if you are seeing that **object fields** are not appearing in the CSV report, it sounds like you are experiencing this issue: [[Reporting] Not able to generate CSV report on object fields; Discover is able · Issue #25068 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/25068).

This was fixed in 7.13, but it requires the "Read fields from \_source" setting to **be unchecked** :

- ![111235995-14394280-85af-11eb-8708-f82b1d700d14](https://us1.discourse-cdn.com/elastic/original/3X/7/b/7b4c5b39943bed3150cbd9fc0e091004a4f91d40.png)

If this issue is not related to object fields, I would like to see the info from Jean-Louis' questions. In addition to looking for clues with those, it would help if you shared the [POST URL](https://www.elastic.co/guide/en/kibana/current/automating-report-generation.html#_create_a_post_url) that is available in the same panel as the "Generate CSV" button. Please make sure it does not contain senstive information before sharing.

Thanks!

---

<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:** [July 28, 2021, 7:50pm UTC](https://discuss.elastic.co/t/exporting-to-csv-missing-values-in-fields/277389/6 "2021-07-28T19:50:02Z")

</div>

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