Toad World® Forums

Excel Format on TOAD 12.6

I am using TOAD 12.6 for oracle. I am running a SQL query and saving the output from Data Grid on excel format.

TOAD excel format saves the file in Microsoft Excel97-2003. This format has a limitation of 65K rows per sheet.

My query generates 85K, so I end up having sheet 1 and sheet 2 on my excel output file.

I have excel 2013 that has 1 million rows limitation per sheet.

Does anybody know how to make TOAD save output file on excel 2013 or similar to eliminate the limitation of 65K rows from older excel versions?

Thank you.

If you are saving to Excel file, make sure to put in XLSX as the file extension, not XLS.