How to Export Query Result to Excel in Oracle SQL Developer?

How to Export Query Result to Excel in Oracle SQL Developer?

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.

In this tutorial, I am giving an example to export query result to an Excel file in Oracle SQL Developer. The following are the steps:

Export SQL Query Result to Excel File in Oracle SQL Developer

  1. Open Oracle SQL Developer and connect to the database.
  2. Then press Alt+F10 key to open an SQL Worksheet.
  3. In the SQL Worksheet, type your SQL query and press Ctrl+Enter key to execute.
  4. You will get the SQL result in Query Result window.
  5. In the query result data grid window, do the right click and from the shortcut menu choose Export option.
  6. An Export Wizard window will open.
  7. In the Export Wizard window, choose Excel 2003+(xlsx) option from the Format drop-down.
  8. Specify the Excel worksheet name in the Data Worksheet Name field.
  9. Uncheck the checkbox named Query Worksheet Name if you don't want to export the SQL query in another worksheet of Excel book.
  10. Specify the file name in File field and then click on the Next button.
  11. Then click on the Finish button on the second step, and you can find your Excel file at the specified location.

See also: