How to Export Data from Toad to Excel?

How to Export Data from Toad to Excel?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 2 mins read

In Toad, you can export the data to an Excel file and into an Excel instance. In Excel instance, it opens the Microsoft Excel and populates the data into the worksheet, and then you can save it as a file. Below I am giving step by step examples of how to export data from Toad to Excel file and Excel instance.

Export Data from Toad to an Excel File

  1. Open Toad for Oracle and connect to the database.
  2. In SQL Editor, type your SQL query for which you want to export the data to Excel and press Ctrl+Enter or F9 to execute, and you will get the result in the data grid.
  3. Then in the data grid, do the right click and from the menu choose Export Dataset option.
  4. In the Export Data window, choose Excel File from the Export Format drop-down menu.
  5. Specify the file name and path in File field.
  6. There is a lot of other options you will find in the Export Data window, for example, date format, include column headers, etc. Select as per your requirement and then click on the OK button to export.

Now you can check the file location for the Excel file created through the export.

Export Data into an Excel Instance from Toad

(First three steps are same as above)

  1. Open Toad for Oracle and connect to the database.
  2. In SQL Editor, type your SQL query for which you want to export the data to Excel and press Ctrl+Enter or F9 to execute, and you will get the result in the data grid.
  3. Then in the data grid, do the right click and from the menu choose Export Dataset option.
  4. In the Export Data window, choose Excel Instance from the Export Format drop-down menu.
  5. For Excel Instance, there is no need to specify the file name, so after selecting other checkboxes for your export click on the OK button and it will open the Excel instance and will populate the data into a worksheet.

See also: