# Issue when import.xlsx file with datetime format

**URL:** <https://community.nocodb.com/t/issue-when-import-xlsx-file-with-datetime-format/771>\
**Category:** Discord-Discussions\
**Created:** [March 17, 2023, 6:40am UTC](https://community.nocodb.com/t/issue-when-import-xlsx-file-with-datetime-format/771 "2023-03-17T06:40:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![YanothaiA](https://avatars.discourse-cdn.com/v4/letter/y/edb3f5/32.png) [@YanothaiA](https://community.nocodb.com/u/YanothaiA)\
**Post date:** [March 17, 2023, 6:40am UTC](https://community.nocodb.com/t/issue-when-import-xlsx-file-with-datetime-format/771/1 "2023-03-17T06:40:49Z")

</div>

I try to import excel file that has 2 column → Name and Birthdate. In the BirthDate column the data has format yyyy-mm-dd hh:mm:ss.  
And When I import to NocoDB there’s an error show in the image below

 ![image](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/787238235e54a7982a8fd98ef13cd64c27e7e401.png)

I change datetime format in various type such as dd/mm/yyyy hh:mm:ss but nothing works. If I import in singleLineText format in noco. The data in table is changed that there’re “T” between date and time and “.000Z” in the suffix. Please guide me how to fix it.