# Trouble with timestamp not showing properly in exported CSV

**URL:** <https://forum.inductiveautomation.com/t/trouble-with-timestamp-not-showing-properly-in-exported-csv/9414>\
**Category:** Ignition\
**Created:** [December 8, 2014, 6:35pm UTC](https://forum.inductiveautomation.com/t/trouble-with-timestamp-not-showing-properly-in-exported-csv/9414 "2014-12-08T18:35:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [December 8, 2014, 6:35pm UTC](https://forum.inductiveautomation.com/t/trouble-with-timestamp-not-showing-properly-in-exported-csv/9414/1 "2014-12-08T18:35:08Z")

</div>

I have a table of data:

JDE\_Label, LPN\_Label, timestamp…

C1234567800002, 11824022, Dec 8 2014 1:21 PM  
C1234567800003, 11824024, Dec 8 2014 1:18 PM

When exported to CSV then imported back to Excel the timestamp column looks like

2014-12-8 0:00  
2014-12-8 0:00

Where did my time go? Is there something additional I need or a different format for the original timestamp column??

`table = event.source.parent.getComponent('Table').data
system.dataset.exportExcel("verify_data.xls", 1, table)`

Thanks

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 8, 2014, 7:49pm UTC](https://forum.inductiveautomation.com/t/trouble-with-timestamp-not-showing-properly-in-exported-csv/9414/2 "2014-12-08T19:49:31Z")

</div>

exportExcel ouputs an XML file. Since that’s just a formatted text, we can take a closer look. ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

Open the file in a text editor. Notepad will do, but Notepad++ is my favorite child.  
Here’s a shot from one of mine. My example comes out in 24h time, but you can compare and see if the full datetime is at least getting that far.

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/aa3ce835d051c7455044c910d9fc9492cd40e5ef.png)