# After exporting to csv getting different value

**URL:** <https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551>\
**Category:** Kibana\
**Created:** [July 13, 2022, 3:53pm UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551 "2022-07-13T15:53:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Muhammed\_Ashique](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammed_ashique/32/98686_2.png) [@Muhammed\_Ashique](https://discuss.elastic.co/u/Muhammed_Ashique)\
**Post date:** [July 13, 2022, 3:53pm UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/1 "2022-07-13T15:53:14Z")

</div>

I have some filed to export as csv . on elasticsearch it is have proper value. once i export into csv file this field is become rounded value.

here attached before exporting and after exporting.

![After_Exporting](https://us1.discourse-cdn.com/elastic/original/3X/1/9/196203d41a633f269a4dd5a4321fa14c5a033a03.png)

 ![Before_Exporting](https://us1.discourse-cdn.com/elastic/original/3X/0/e/0ebc36c88079fe41d1794db03ba03e92f0dbc421.png)

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [July 13, 2022, 4:23pm UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/2 "2022-07-13T16:23:00Z")

</div>

This just looks like an issue with whatever program you are using to show the CSV. If you change the format of that field to a string it should show it all. But the data looks correct from what I can see.

---

<div class="post-metadata">

**Author:** ![Muhammed\_Ashique](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammed_ashique/32/98686_2.png) [@Muhammed\_Ashique](https://discuss.elastic.co/u/Muhammed_Ashique)\
**Post date:** [July 13, 2022, 4:42pm UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/3 "2022-07-13T16:42:09Z")

</div>

How can i change the format of that field to string?

Data is not correct. while exporting to CSV itis coming rounded value as 9478400004601770, but actual value is 9478400004601775

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [July 13, 2022, 4:54pm UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/4 "2022-07-13T16:54:59Z")

</div>

Interesting. I didn't catch the last part of the number, thought you were referring to just the E Notation.

What is your mapping for `Member_ID`?

---

<div class="post-metadata">

**Author:** ![Muhammed\_Ashique](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammed_ashique/32/98686_2.png) [@Muhammed\_Ashique](https://discuss.elastic.co/u/Muhammed_Ashique)\
**Post date:** [July 14, 2022, 3:57am UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/5 "2022-07-14T03:57:24Z")

</div>

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd4fe9f32cdebe8cf06f1e638437b94e0bef18ca.png)

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [July 14, 2022, 11:19am UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/6 "2022-07-14T11:19:23Z")

</div>

I did a test using `7.17.3` for this. Can you see if I am doing anything different? Or possibly do the same steps I did to see if it works on your end?

My only thoughts is possibly you are looking at a different record due to your dates on on your timestamps being different from your discover screenshot and your csv screenshot. One is Jul 13 and the other is Jul 12.

```auto
PUT rounding
{
  "mappings": {
    "properties": {
      "test": {
        "type": "keyword"
      }
    }
  }
}

POST rounding/_doc
{
  "test": "9478400004601775"
}

```

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/6/668c6e86a25c1f9b04310765feda3330ffdbb835.png)

Exported to CSV from Discover and opened CSV in an editor

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/e/ae4b5946479476d9a665e3930bc41025d8729fe2.png)

---

<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:** [August 11, 2022, 11:19am UTC](https://discuss.elastic.co/t/after-exporting-to-csv-getting-different-value/309551/7 "2022-08-11T11:19:24Z")

</div>

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