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.
Free Version
- CSV: Comma-separated values
- JSON: JavaScript Object Notation
Paid Version
- Excel (.xlsx): Excel workbook format with unlimited rows (subject only to Excel’s native limits)
How to Export
Export Steps
- Execute your query to get results
- Click the “Export” button in the results toolbar or right-click inside the grid and choose an export option
- Select your desired format (CSV, JSON, or Excel)
- Choose save location
- File is saved
You can also right-click inside the grid to open the export context menu for quick CSV/JSON/Excel export.
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:
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": "[email protected]"
},
{
"employee_id": 101,
"first_name": "Neena",
"last_name": "Kochhar",
"email": "[email protected]"
}
]
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
- Limit your data: Use appropriate row limits
- Select needed columns: Avoid SELECT * for large tables
- Clean your query: Remove test data or filters
- 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
For large exports:
- Use row limits: Add
WHERE ROWNUM <= 50000 when you want faster Excel saves
- Select specific columns: Avoid unnecessary columns
- 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
