# Export Dataset to xlsx **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [April 10, 2022, 8:19am UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068 "2022-04-10T08:19:16Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![shubhamgarg](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@shubhamgarg](https://forums.toadworld.com/u/shubhamgarg)\ **Post date:** [April 10, 2022, 8:19am UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/1 "2022-04-10T08:19:16Z")
When I try to export dataset to excel, I do not see an option to export to xlsx, other than this being the standard format now used across enterprise and personal office versions, it also allows for a much bigger single sheet export (104K rows to 65K of xls) Any clue why this is not available in Toad for Oracle 15? ---
**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:** [April 10, 2022, 3:24pm UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/2 "2022-04-10T15:24:46Z")
It’s there. Set export format to excel file. If it defaults to xls then change to xlsx. ---
**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\ **Post date:** [August 27, 2023, 6:13pm UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/3 "2023-08-27T18:13:00Z")
John - Could point me to this option location? I have a long standing multi-table data export to excel that automagically switched to .xls and I am unable to find the place to change it back to xlsx. I find a similar option in Excel \> Options \> Save module, but not in Toad for Oracle... The Excel setting is .xlsx Toad for Oracle Xpert (64-bit) Add-Ons: DB Admin Module 16.3.231.2085 ---
**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:** [August 28, 2023, 11:54am UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/4 "2023-08-28T11:54:33Z")
In Toad, all you have to do is set the export file name's extension to `.xslx` and not `.xls` From the grid, right-click and choose "Export Dataset". Or just doube-click your action if it's already set up in Automation Designer. ![image](https://global.discourse-cdn.com/quest/original/2X/0/085aa9d04028a9c4c4c282b26cfe86a26c63a0a8.png) ---
**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\ **Post date:** [August 28, 2023, 1:09pm UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/5 "2023-08-28T13:09:56Z")
There rae 22 files to be nqamed --- I do not see how to do that.. ![image](https://global.discourse-cdn.com/quest/original/2X/1/1bb0a4d7311eae02257e6cd8832b3ac03579a8ea.png) ![image](https://global.discourse-cdn.com/quest/original/2X/2/23ca5ea4bff3ac2f2bf5391e5ce4b1e45b557c3c.png) ---
**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:** [August 28, 2023, 1:36pm UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/6 "2023-08-28T13:36:35Z")
For multi-table actions, it remembers your last-used format for a single-table export. Do this: - Right-click on any small table in the schema browser, or any grid anywhere in Toad and export to Excel. - In the filename box, be sure the export file extension is `.xlsx` and not `.xls` - Run the export Then your multi-file export will switch back to `.xlsx`. I didn't know it did this. I think the idea was just meant to remember a preferred format for new actions. Seems like it should not affect existing actions, but it does. I'd call it a bug. ☹ I've logged it and will fix it soon. -John ---
**Author:** ![john.c.rose1](https://avatars.discourse-cdn.com/v4/letter/j/8edcca/32.png) [@john.c.rose1](https://forums.toadworld.com/u/john.c.rose1)\ **Post date:** [August 30, 2023, 1:24pm UTC](https://forums.toadworld.com/t/export-dataset-to-xlsx/55068/7 "2023-08-30T13:24:55Z")
Perfect !! Thank you John -