# Tables | Import new line (\\n) data from xlsx

**URL:** <https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 16, 2020, 7:10pm UTC](https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996 "2020-09-16T19:10:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [September 16, 2020, 7:10pm UTC](https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996/1 "2020-09-16T19:10:16Z")

</div>

I imported an xlsx file to an empty table. The imported values of a column in the table are starts with "_x000D_" value, but in the original xlsx file these are new lines.

From the following forum:

> <https://github.com/jmcnamara/libxlsxwriter/issues/189>
>
> I am using the latest version (well, our fork https://github.com/hooktstudios/libxlsxwriter) and via the ruby wrapper (https://github.com/Paxa/fast\_excel).
> When I insert strings from my...

  
"...  
This behaviour is mentioned a [few places on the internet as well](https://www.google.com/search?&q=_x000D_+excel) such as [here](https://stackoverflow.com/questions/36167807/access-newline-becoming-x000d) or [here](https://answers.microsoft.com/en-us/office/forum/office_2010-word/field-code-inserts-x000d-in-office-2010-word/9b384b43-89c0-4861-b359-858f0be3f694?auth=1) or [here](https://forum.opencart.com/viewtopic.php?t=103108).\*  
..."

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 16, 2020, 8:48pm UTC](https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996/2 "2020-09-16T20:48:52Z")

</div>

I tried to reproduce this by:

1. Running this query and exporting it to an XLSX file:  
select EMPNO, CHR(13) || CHR(10) || ENAME as ename, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO  
from emp

2. Importing that file back into the table

...but after that the table looked as I expected, with an actual line feed. I also tried with just CHR(13) instead of CHR(13) || CHR(10).

How can I create a file to reproduce the problem?

---

<div class="post-metadata">

**Author:** ![urban.tamas](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@urban.tamas](https://forums.toadworld.com/u/urban.tamas)\
**Post date:** [September 16, 2020, 9:03pm UTC](https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996/3 "2020-09-16T21:03:03Z")

</div>

I send you offline a sample xlsx and the structure of the table.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 17, 2020, 1:28pm UTC](https://forums.toadworld.com/t/tables-import-new-line-n-data-from-xlsx/50996/4 "2020-09-17T13:28:51Z")

</div>

Tamas and I have been communicating by email, but incase anyone else sees this:

It is broken in Toad 13.3 (and possibly earlier versions), but it is fixed starting in Toad 14.0.