# Excel Export

**URL:** <https://forums.toadworld.com/t/excel-export/19419>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 10, 2013, 12:00pm UTC](https://forums.toadworld.com/t/excel-export/19419 "2013-07-10T12:00:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cburl](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@Cburl](https://forums.toadworld.com/u/Cburl)\
**Post date:** [July 10, 2013, 12:00pm UTC](https://forums.toadworld.com/t/excel-export/19419/1 "2013-07-10T12:00:57Z")

</div>

For some reason when I export to excel, my data ends up in 2 excel worksheets. There’s about 80 rows so but i have excel 2010 and it handles much more rows than 80k.

---

<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:** [July 10, 2013, 12:09pm UTC](https://forums.toadworld.com/t/excel-export/19419/2 "2013-07-10T12:09:55Z")

</div>

There are a few ways to export data to excel. Can you specify exactly what you are doing?

**From:** Cburl [[mailto:bounce-Cburl@toadworld.com](mailto:bounce-Cburl@toadworld.com)]

**Sent:** Wednesday, July 10, 2013 2:01 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] Excel Export

**[Excel Export](http://gyk.r.mailjet.com/redirect/0cgmhs3bwbjyh3x47r5df1/www.toadworld.com/products/toad-for-oracle/f/10/t/14961.aspx)**

Thread created by Cburl

For some reason when I export to excel, my data ends up in 2 excel worksheets. There’s about 80 rows so but i have excel 2010 and it handles much more rows than  
80k.

To reply, please reply-all to this email.

[Stop receiving emails](http://gyk.r.mailjet.com/redirect/977zhy3j6q2b2p2wytyvy5/www.toadworld.com/products/toad-for-oracle/f/10/t/14961.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/np5htz0rctb366y51rkjlj/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://gyk.r.mailjet.com/redirect/487thny5zblds3k52zg70q/www.toadworld.com/products/toad-for-oracle/f/10/t/14961.aspx?AbuseContentId=34e9791e-c625-4a95-a7a3-b8a8d0a33e7d&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/3b4bc3f0/421nS9.gif)

---

<div class="post-metadata">

**Author:** ![Cburl](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@Cburl](https://forums.toadworld.com/u/Cburl)\
**Post date:** [July 10, 2013, 12:12pm UTC](https://forums.toadworld.com/t/excel-export/19419/3 "2013-07-10T12:12:34Z")

</div>

sure. I run my query then go to the data grid. I then right click and select export dtasheet.

---

<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:** [July 10, 2013, 12:24pm UTC](https://forums.toadworld.com/t/excel-export/19419/4 "2013-07-10T12:24:56Z")

</div>

And then in the dialog that appeared, did you choose “Excel file” or “Excel Instance”?

If you chose “Excel Instance”, and excel was already running, Toad will create a new sheet and then put the data on the new sheet. If you want Toad to start  
the dataset in a particular cell in Excel, click in the cell in Excel, and in Toad, in the “export” dialog, check “Start at active cell”.