# Data Format in csv reports generated in Kibana

**URL:** <https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523>\
**Category:** Kibana\
**Created:** [August 30, 2019, 12:38pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523 "2019-08-30T12:38:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![BastianC](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bastianc/32/52204_2.png) [@BastianC](https://discuss.elastic.co/u/BastianC)\
**Post date:** [August 30, 2019, 12:38pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523/1 "2019-08-30T12:38:24Z")

</div>

Hi, I would like to export data as csv for further analysis outside the elastic stack. When doing this from the Discover page in Kibana, I noticed that all values in the generated csv are formatted as strings, i.e. number-type fields are represented like this:  
"12.345","-736","13,123,948"

Is there an option to avoid quotation marks for number-type fields (integer, long, float, etc.)?  
It's fine for me to use the corresponding Elasticsearch API directly ("\<elasticsearch\_url\>/api/reporting/generate/csv?jobParams=(...)", if needed.

Best Regards,  
Bastian

P.S.: I'm using version 7.3.1 of the elastic stack under the basic license.

---

<div class="post-metadata">

**Author:** ![mikecote](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mikecote/32/58549_2.png) [@mikecote](https://discuss.elastic.co/u/mikecote)\
**Post date:** [August 30, 2019, 4:06pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523/2 "2019-08-30T16:06:29Z")

</div>

Hi @BastianC,

The CSV export function will format the data according to what is configured with the Index Pattern. By default, it uses the numeral.js format of `0,0.[000]` which causes the export number fields to be wrapped in quotes.

If you edit the number fields under Index Pattern Management and change their numeral.js format to `0`, the exported CSV should return numbers without quotes.

Screenshot of what I did locally to change the format:

 ![55%20PM](https://us1.discourse-cdn.com/elastic/original/3X/6/7/6738a65a44c88059edac8efbaac0bc7466372a98.png)

Let me know if that does the trick,  
Mike.

---

<div class="post-metadata">

**Author:** ![BastianC](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bastianc/32/52204_2.png) [@BastianC](https://discuss.elastic.co/u/BastianC)\
**Post date:** [September 1, 2019, 5:45pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523/3 "2019-09-01T17:45:32Z")

</div>

Works like a charm, thanks a lot! Do you also know of a possibility to automate this, in order to reduce the extra effort when creating fields, or even new index patterns?

---

<div class="post-metadata">

**Author:** ![mikecote](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mikecote/32/58549_2.png) [@mikecote](https://discuss.elastic.co/u/mikecote)\
**Post date:** [September 9, 2019, 1:41pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523/4 "2019-09-09T13:41:04Z")

</div>

Hi @BastianC,

For global changes, you should be able to set those under "Advanced Settings". I have attached a screenshot below of the menu option next to "Index Patterns". I believe changing the "Number format" will change the format globally or at least to newly created index patterns.

![18%20AM](https://us1.discourse-cdn.com/elastic/original/3X/0/8/08a5097cff7ae4d28077370b071fc49753a98052.png)

Hope this helps,  
Mike.

---

<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:** [October 7, 2019, 1:41pm UTC](https://discuss.elastic.co/t/data-format-in-csv-reports-generated-in-kibana/197523/5 "2019-10-07T13:41:06Z")

</div>

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