Press "Enter" to skip to content

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

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:

Vinish Kapoor

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *