# Column Missing From Toad Excel Export

**URL:** <https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 23, 2019, 2:27pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328 "2019-01-23T14:27:48Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![matthew.gossett](https://avatars.discourse-cdn.com/v4/letter/m/51bf81/32.png) [@matthew.gossett](https://forums.toadworld.com/u/matthew.gossett)\
**Post date:** [January 23, 2019, 2:27pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/1 "2019-01-23T14:27:48Z")

</div>

Hi, I am exporting from Toad into Excel and one of the columns that’s in the dataset is missing from the excel file. Any ideas as to why this issue might occur / how to resolve would be greatly appreciated.

Thanks,

---

<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:** [January 23, 2019, 2:29pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/2 "2019-01-23T14:29:35Z")

</div>

There is a “columns to exclude” dropdown in the export dataset dialog. By default it excludes CLOBs and other large/exotic datatypes. Check that. If that’s not it, I’ll need some details.

---

<div class="post-metadata">

**Author:** ![matthew.gossett](https://avatars.discourse-cdn.com/v4/letter/m/51bf81/32.png) [@matthew.gossett](https://forums.toadworld.com/u/matthew.gossett)\
**Post date:** [January 23, 2019, 2:40pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/3 "2019-01-23T14:40:00Z")

</div>

It’s not that. The column that I am trying to export is unchecked in “columns to exclude” dropdown.

---

<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:** [January 23, 2019, 2:40pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/4 "2019-01-23T14:40:54Z")

</div>

The column name and its corresponding datatype are unchecked?

---

<div class="post-metadata">

**Author:** ![matthew.gossett](https://avatars.discourse-cdn.com/v4/letter/m/51bf81/32.png) [@matthew.gossett](https://forums.toadworld.com/u/matthew.gossett)\
**Post date:** [January 23, 2019, 2:42pm UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/5 "2019-01-23T14:42:48Z")

</div>

Ok looks like it was the corresponding data type that was checked. Didn’t realize that. Thanks for your help!

---

<div class="post-metadata">

**Author:** ![wendy.poon](https://avatars.discourse-cdn.com/v4/letter/w/3da27b/32.png) [@wendy.poon](https://forums.toadworld.com/u/wendy.poon)\
**Post date:** [September 16, 2020, 1:00am UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/6 "2020-09-16T01:00:36Z")

</div>

Can I know where do I go to unchecked the corresponding data type?  
I having the same issue, I have 7 columns but only export 6 columns. Thank you!

---

<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, 11:51am UTC](https://forums.toadworld.com/t/column-missing-from-toad-excel-export/45328/7 "2020-09-16T11:51:31Z")

</div>

Is the missing column or datatype checked here?

 ![image](https://global.discourse-cdn.com/quest/original/2X/1/1fbb9b2fcce7568bbef91eb170571e0da104ff96.png)