How To Export CSV From Toad?

How To Export CSV From Toad?

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 this tutorial, you will learn how to export the table data into a CSV file from Toad. The following are the steps.

Export Database Table Data into CSV File Using Toad

I am using the database Oracle, and the table is customers from SH schema, to explain this example.

  1. Open Toad and connect to the database.
  2. Then click on the menu Database > Editor, to open the SQL editor window.
  3. In SQL editor window, type your SQL query and press Ctrl+Enter to execute and get the results in a grid. Below is an example of an SQL query.
SELECT cust_first_name,
       cust_last_name,
       cust_city,
       cust_state_province,
       cust_main_phone_number
  FROM sh.customers
 WHERE country_id = '52775' AND cust_valid = 'A';
  1. Then right-click on the Grid in Toad and from the shortcut menu select Export Dataset option.
  2. In the Export Data window, select the options as shown in below image to export the data into CSV file from Toad. Select the option Delimited Text from the Export Format drop-down. Specify the file location and name in File field. Specify the delimiter and click OK to export.

Export data into CSV file from Toad

Check your file location for the generated CSV file.

See also: