Skip to content

How SQL Developer Export to Excel

  • by

Export to Excel

The export function for query result is not so obvious for developers to find out. In this post, I will show how to export query result as a Excel file.

Show Query Result as Grid

To show the query result in a grid table, you have to use F9 or Ctrl+Enter to format query result in grid.

SQL Developer Query Result

SQL Developer Query Result

Right Click Mouse and Export

Move your cursor over anywhere on the grid and right click the mouse, you will see Export option.

SQL Developer Query Result - Export

SQL Developer Query Result - Export

Export Entire Table

If the data you want to export is a table, not a query result, you can directly right-click on the table and select Export in the menu.

SQL Developer - Table Menu - Export

SQL Developer - Table Menu - Export

Select Export Format

SQL Developer showed Export Wizard window for interaction. Although there're many export types for us to select, we chose Excel format in this case.

SQL Developer Query Result - Export Format - Excel (.xls)

SQL Developer Query Result - Export Format - Excel (.xls)

Select Text Encoding

I chose UTF-8 in order to match the database encoding.

SQL Developer Query Result - Export Encoding - UTF-8

SQL Developer Query Result - Export Encoding - UTF-8

Customize Filename

If you want to change the path, you can click Browse to navigate and choose a right directory to place.

SQL Developer Query Result - Export File Name - Browse

SQL Developer Query Result - Export File Name - Browse

Review Export Job Before Executing

You can expand all options to see the content of the export job.

SQL Developer Query Result - Export - Summary

SQL Developer Query Result - Export - Summary

Check Content of Excel File

We open the Excel file in an application, so they can be viewed its content below.

SQL Developer Query Result - Export - Excel File Content

SQL Developer Query Result - Export - Excel File Content

That's it!

Next, we can restore the Excel data back into table by importing data in SQL Developer whenever needed.

Leave a Reply

Your email address will not be published.