Export Query Output to Excel in Oracle SQL Developer

Do you need to export your query output to Excel in Oracle SQL Developer?

If so, I’ll show you the steps to accomplish this goal.

Steps to export query output to Excel in Oracle SQL Developer

Step 1: Run your query

To start, you’ll need to run your query in SQL Developer. For example, I ran a simple query to generate the following output in SQL Developer:

 

Export Query Results in Oracle SQL Developer

Step 2: Open the Export Wizard

Once you’re done running the query in SQL Developer, you’ll see the query output at the bottom of your screen.

Right-click on any cell on the query results, and then select the ‘Export…’ option from the drop down menu:

 

How to Export Query Results in Oracle SQL Developer

 

You’ll now see the Export Wizard:

 

Export Query Results in Oracle SQL Developer

Step 3: Select the Excel format and the location to export your file

Now you’ll need to:

(1) Select the Excel format from the drop-down list. You can choose the xlsx format for recent versions of Excel (2003+), or the xls format for previous versions of Excel (95-2003). For our example, I chose the xlsx format

(2) Click on the ‘Browse…’ button to select the location where the Excel file will be saved

(3) Press on the ‘Next >’ button once you are done

 

Export Query Output to Excel in Oracle SQL Developer

Step 4: Export the query output to Excel

For the final step, click on the ‘Finish’ button to export the query output to Excel in SQL Developer:

 

Export Query Results in Oracle SQL Developer

Conclusion

We just saw how to export your query output to Excel in Oracle SQL Developer. You can choose to export your query results to either the xlsx format for newer versions of Excel, or the xls format for previous versions of Excel.

If you need to export your query output to a CSV file, you may then check the following source that explains the steps to export your query results to CSV in SQL Developer. Alternatively, you may apply the spool method to accomplish the same goal.