Skip to main content

​
Overview

Koala Data Explorer allows you to export your query results to common file formats for further analysis, sharing, or reporting.
Right-click anywhere in the results grid to open the export menu for one-click CSV, JSON, Excel, or Export Selected actions.

​
Available Export Formats

​
Free Version

  • CSV: Comma-separated values
  • JSON: JavaScript Object Notation
  • Excel (.xlsx): Excel workbook format with unlimited rows (subject only to Excel’s native limits)

​
How to Export

​
Export Steps

  1. Execute your query to get results
  2. Click the “Export” button in the results toolbar or right-click inside the grid and choose an export option
  3. Select your desired format (CSV, JSON, or Excel)
  4. Choose save location
  5. File is saved
You can also right-click inside the grid to open the export context menu for quick CSV/JSON/Excel export.

​
Export Button Location

The Export button appears in the results panel toolbar after you run a query and get results.

​
Export Formats

​
CSV Export

Comma-Separated Values format:
  • Universal compatibility with spreadsheet applications
  • Plain text format
  • Includes column headers
  • Configurable delimiter (comma, semicolon, tab)
Example CSV output: 
employee_id,first_name,last_name,email
100,Steven,King,SKING@oracle.com
101,Neena,Kochhar,NKOCHHAR@oracle.com

​
JSON Export

JavaScript Object Notation format:
  • Structured data format
  • Good for API integration
  • Array of objects format
Example JSON output: 
[
  {
    "employee_id": 100,
    "first_name": "Steven",
    "last_name": "King",
    "email": "SKING@oracle.com"
  },
  {
    "employee_id": 101,
    "first_name": "Neena", 
    "last_name": "Kochhar",
    "email": "NKOCHHAR@oracle.com"
  }
]

​
Excel Export (Paid)

Excel (.xlsx) format:
  • Professional formatting
  • Proper data types
  • Ready for business use
  • See Excel Export Guide for detailed information
  • Unlimited export size for paid users; Koala streams data until Excel’s native sheet limit

​
Export selected rows

  • Highlight one or more rows and choose Export Selected from the context menu.
  • Useful for sharing filtered subsets without re-running the query.
  • Right-click → Export also shows CSV/JSON/Excel options scoped to your current selection.

​
Export Options

​
Basic Options

When exporting, you can configure:
  • Include headers: Column names in first row
  • File location: Where to save the export
  • Delimiter (CSV only): Comma, semicolon, or tab

​
Row Limits

Exports respect the configured row limits:
  • Free version: Maximum 50 rows
  • Paid version: Unlimited Excel exports; CSV/JSON follow your configured maxRows value if set

​
Use Cases

​
CSV Export

  • Spreadsheet analysis: Open in Excel, Google Sheets
  • Data exchange: Universal format for sharing
  • System integration: Import into other applications

​
JSON Export

  • API development: Structured data for applications
  • Web development: JavaScript-friendly format
  • Data processing: Programmatic data handling

​
Excel Export (Paid)

  • Business reporting: Professional formatted reports
  • Presentations: Ready-to-share spreadsheets
  • Analysis: Use Excel’s built-in tools

​
Best Practices

​
Before Exporting

  1. Limit your data: Use appropriate row limits
  2. Select needed columns: Avoid SELECT * for large tables
  3. Clean your query: Remove test data or filters

​
Choosing Format

  • CSV: For general data sharing and analysis
  • JSON: For technical/development use
  • Excel: For business reports and presentations

​
File Management

  • Descriptive names: Include date and query purpose
  • Organized storage: Keep exports in project folders
  • Regular cleanup: Remove old export files

​
Troubleshooting

​
Export Issues

​
”No data to export”

  • Ensure your query returned results
  • Check that query execution completed successfully

​
”Export failed”

  • Check file permissions at save location
  • Ensure sufficient disk space
  • Try a different save location

​
”Excel export not available”

  • Excel export requires the paid version; verify your license
  • Ensure the query finished and results are visible before exporting
  • If the button stays disabled, check workspace policies that may force CSV/JSON only

​
”File too large”

  • Reduce row count in your query
  • Use CSV instead of Excel for very large datasets
  • Apply more restrictive WHERE clauses

​
Performance Tips

For large exports:
  1. Use row limits: Add WHERE ROWNUM <= 50000 when you want faster Excel saves
  2. Select specific columns: Avoid unnecessary columns
  3. Choose appropriate format: Use CSV for automation or extremely large datasets; Excel for analysis and presentation

​
File Compatibility

​
CSV Files

  • Excel: Opens directly
  • Google Sheets: Import capability
  • Text editors: Readable as plain text
  • Database tools: Universal import format

​
JSON Files

  • Code editors: Syntax highlighting and formatting
  • Web browsers: Can view formatted JSON
  • Programming languages: Native support in most languages

​
Excel Files (Paid)

  • Microsoft Excel: Native format
  • Google Sheets: Import and convert
  • LibreOffice Calc: Open and edit
  • Numbers (Mac): Import capability

​
Next Steps

Excel Export Details

Learn about Excel export features

Viewing Results

Working with query results