How to Download Data from SQL Developer
Learn how to download data from SQL Developer by exporting query results to CSV, Excel, JSON, or other formats. Works with Oracle, MySQL, PostgreSQL, and all supported databases.
Export Query Results to CSV
4 simple steps
Run Your Query
Execute your SELECT statement to display the data you want to export. The results will appear in the grid below.
Right-Click on Results
Right-click anywhere in the results grid. A context menu will appear with several options.
Select Export Format
Click Export and choose your format:
- CSV (Comma Separated)
- Excel (.xlsx)
- JSON
- XML
- SQL INSERT statements
Save the File
Choose where to save the file, give it a name, and click Save. That's it!
Export Options Explained
Choose the right format for your needs
CSV
Best for: Opening in Excel, importing into other databases, general data transfer. Universal format that works everywhere.
Excel (.xlsx)
Best for: Sharing with non-technical users, creating reports. Preserves formatting and supports multiple sheets.
JSON
Best for: Web applications, APIs, JavaScript processing. Preserves data types and nested structures.
SQL INSERT
Best for: Migrating data to another database, creating backups, sharing data that needs to be re-imported exactly.
Tips for Large Exports
Exporting millions of rows? Keep these in mind
Use LIMIT for Testing
Before exporting a huge table, test with LIMIT 100 to make sure
the format looks right. Then remove the limit for the full export.
Export in Batches
For very large tables (millions of rows), consider exporting in batches
using LIMIT and OFFSET to avoid memory issues.
Check Encoding
If your data contains special characters (accents, emojis, etc.), make sure to use UTF-8 encoding when exporting.