# Excel export problem

**URL:** <https://discuss.elastic.co/t/excel-export-problem/200739>\
**Category:** Kibana\
**Created:** [September 23, 2019, 7:00pm UTC](https://discuss.elastic.co/t/excel-export-problem/200739 "2019-09-23T19:00:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mr\_searchng](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@mr\_searchng](https://discuss.elastic.co/u/mr_searchng)\
**Post date:** [September 23, 2019, 7:00pm UTC](https://discuss.elastic.co/t/excel-export-problem/200739/1 "2019-09-23T19:00:36Z")

</div>

In the export part of the graphics in the same column kibana doing.  
both raw and formatted var. both give the same output.  
what is the difference

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [September 24, 2019, 1:24pm UTC](https://discuss.elastic.co/t/excel-export-problem/200739/2 "2019-09-24T13:24:46Z")

</div>

Depends on the type of fields and aggregation you are displaying on the data table visualization.

For example: if you are displaying your data as aggregated by a timestamp, on the `raw` CSV output the timestamp column will export all timestamp in millis or on the original date format of your documents. On the other hand the formatted output will present the same information displayed on the visualization.

The `formatted` output will always use the formatting option configured on the index-pattern used. Instead the `raw` output will always use the raw value coming from the data source/document

---

<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 22, 2019, 1:24pm UTC](https://discuss.elastic.co/t/excel-export-problem/200739/3 "2019-10-22T13:24:48Z")

</div>

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