> ## Documentation Index
> Fetch the complete documentation index at: https://docs.btsscorp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Exporting Data

> Export query results to CSV, JSON, and Excel formats

## Overview

Koala Data Explorer allows you to export your query results to common file formats for further analysis, sharing, or reporting.

<Tip>
  Right-click anywhere in the results grid to open the export menu for one-click CSV, JSON, Excel, or **Export Selected** actions.
</Tip>

## Available Export Formats

### 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

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

<Tip>
  You can also right-click inside the grid to open the export context menu for quick CSV/JSON/Excel export.
</Tip>

### 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:

```csv theme={null}
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:

```json theme={null}
[
  {
    "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](/koala/results/excel-export) 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

<CardGroup cols={2}>
  <Card title="Excel Export Details" icon="file-excel" href="/koala/results/excel-export">
    Learn about Excel export features
  </Card>

  <Card title="Viewing Results" icon="table" href="/koala/results/viewing-data">
    Working with query results
  </Card>
</CardGroup>