# XSLX to SpreadSheet Node, Encountering DATE issues

**URL:** <https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592>\
**Category:** Questions\
**Tags:** data-transformation, spreadsheet-file\
**Created:** [April 26, 2023, 9:33am UTC](https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592 "2023-04-26T09:33:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![saica](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@saica](https://community.n8n.io/u/saica)\
**Post date:** [April 26, 2023, 9:33am UTC](https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592/1 "2023-04-26T09:33:11Z")

</div>

Utilizing the newest stable N8N Cloud instance, when I import XLSX or XLS to the SpreadSheet Node, the date field is always formatting to a number value.

Example:  
Original Date in XLSX: **6/24/2023**  
When outputted in Spreadsheet Node: **45101**

I think the Spreadsheet node is converting that column to a Number type, but cannot find any sort of fix?

Thanks

 ![date](https://europe1.discourse-cdn.com/n8n/original/3X/f/b/fbb21e3abcaaf61286f142a65c202f31cb723ddf.png)

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [April 26, 2023, 2:47pm UTC](https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592/3 "2023-04-26T14:47:08Z")

</div>

Hi @saica, this is expected as this is the type of value Excel uses to represent dates.

Perhaps you want to try out [this expression](http://community.n8n.io/t/date-serial-number-to-normal-date/10891/4) I posted a while back to convert such dates?

Still seems to work from giving this a quick go with your first value:

 ![grafik](https://europe1.discourse-cdn.com/n8n/original/3X/2/b/2b66b6f045e3d1b48d4742be3dc0f4d408dfa0e2.png)

---

<div class="post-metadata">

**Author:** ![saica](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@saica](https://community.n8n.io/u/saica)\
**Post date:** [April 27, 2023, 12:10pm UTC](https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592/4 "2023-04-27T12:10:53Z")

</div>

Hi @MutedJam,

This works, but it also sets a date to empty cells. I could have another ‘set’ to remove that incorrect date, but I believe it would always be a moving target? Maybe it wouldn’t change if there is no value.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [July 26, 2023, 12:11pm UTC](https://community.n8n.io/t/xslx-to-spreadsheet-node-encountering-date-issues/25592/5 "2023-07-26T12:11:21Z")

</div>

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