# Issues With Time Stamp Format Upon Export to .CSV **URL:** \ **Category:** Ignition\ **Tags:** ignition80, vision, scripting\ **Created:** [August 24, 2023, 2:18pm UTC](https://forum.inductiveautomation.com/t/issues-with-time-stamp-format-upon-export-to-csv/78335 "2023-08-24T14:18:46Z")\ **Posts on this page:** 1\ **Showing post:** 7
**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:** [August 24, 2023, 3:10pm UTC](https://forum.inductiveautomation.com/t/issues-with-time-stamp-format-upon-export-to-csv/78335/7 "2023-08-24T15:10:12Z")
Using the POI libraries, you can format the dates however you want. Don't let the thread title fool you. I have scripts in there for both directions. 😉 > [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/7): > > The [Apache POI](https://poi.apache.org/apidocs/4.1/index.html) libraries are included with Ignition. At the time I was only needing to read files, so xlrd was all that was necessary. I'm just starting to dig into POI, myself, but here's a start: EDIT 2021-08-23: Updated to allow JsonDataSets. Changed to allow for a ByteArray output instead of writing to a file. EDIT 2023-01-20: Added option for date formats. Default is 'yyyy-MM-dd hh:mm:ss'. EDIT 2023-05-12: Added options for first row and column, if needed to offset from A1 def datasetT… --- _[View the full topic](https://forum.inductiveautomation.com/t/issues-with-time-stamp-format-upon-export-to-csv/78335)._