Toad World® Forums

Toad exporting data to multiple sheets in excel

Is there a way to stop exporting data to multiple tabs in toad?

Please be more specific about what you are doing in Toad, how it comes out, and how you want it to come out. Also let us know which Toad version you are using.

And how many records... if it's "tabs" in the sense of worksheet tabs within Excel (if that's your target) there may not be a way to get around this if the volume of rows being exported is high.

Is this what you are looking for?

I have had this issue. I exported quite a lot of records.

if exporting to XLS file, Toad starts a new tab after 65,000 records
if exporting to XLSX file, Toad starts a new tab after approx 1M records.
if using the "Excel Instance" export option, it depends on the version of Excel.