# Column missing in Excel export

**URL:** <https://forums.toadworld.com/t/column-missing-in-excel-export/33503>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [June 16, 2015, 10:32am UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503 "2015-06-16T10:32:29Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgolpashin](https://avatars.discourse-cdn.com/v4/letter/d/5fc32e/32.png) [@dgolpashin](https://forums.toadworld.com/u/dgolpashin)\
**Post date:** [June 16, 2015, 10:32am UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/1 "2015-06-16T10:32:29Z")

</div>

Hi,

I have comment field that appears in the data grid, but when I try to export the records to Excel format, that column is excluded.

fyi - The comment field has page breaks (   
  
 ) within the data due to users copying and pasting from email.

I’ve tried using replace(comment\_field,’  
’,’ ')

…but still not outputting.

Any suggestions?

thanks,

DG

---

<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:** [June 16, 2015, 11:05am UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/2 "2015-06-16T11:05:01Z")

</div>

No, this is the first I’ve heard of such a thing. Some suggestions:

If you are saving to .xls then try .xlsx.

If you are saving to .xlsx then try .xls.

If those don’t help, try the “Excel Instance” format instead.

---

<div class="post-metadata">

**Author:** ![dgolpashin](https://avatars.discourse-cdn.com/v4/letter/d/5fc32e/32.png) [@dgolpashin](https://forums.toadworld.com/u/dgolpashin)\
**Post date:** [June 16, 2015, 4:09pm UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/3 "2015-06-16T16:09:18Z")

</div>

I have tried exporting to .xls and .xlsx without any luck.

Gonna try .csv next.

---

<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:** [June 17, 2015, 5:38am UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/4 "2015-06-17T05:38:17Z")

</div>

How about “Excel Instance”?

---

<div class="post-metadata">

**Author:** ![doof4152](https://avatars.discourse-cdn.com/v4/letter/d/3ab097/32.png) [@doof4152](https://forums.toadworld.com/u/doof4152)\
**Post date:** [June 18, 2015, 2:50pm UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/5 "2015-06-18T14:50:21Z")

</div>

Same issue here; substringed a clob into 100 char fields t01-t04, exported to excel; fields do not appear; all other fields, including another clob also subtringed are in the excel

---

<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:** [June 19, 2015, 5:24am UTC](https://forums.toadworld.com/t/column-missing-in-excel-export/33503/6 "2015-06-19T05:24:43Z")

</div>

If someone will send me a table DDL and some insert statements so I can reproduce it, I’ll try to fix it.