> ## Documentation Index
> Fetch the complete documentation index at: https://flextable-docs-oracle-client-choice.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Import and export

> Move data in and out of FlexTable as CSV, JSON, SQL, or Excel.

## Export

Click **Export** on a result or table and choose a format:

| Format    | Use                                 |
| --------- | ----------------------------------- |
| **CSV**   | Spreadsheets, generic tooling       |
| **JSON**  | APIs, document stores               |
| **SQL**   | `INSERT` statements (SQL databases) |
| **Excel** | `.xlsx` workbook                    |

<Steps>
  <Step title="Open a table or run a query" />

  <Step title="Click Export" />

  <Step title="Pick a format and options, then choose where to save" />
</Steps>

<img src="https://mintcdn.com/flextable-docs-oracle-client-choice/tHXEy7Wr6vLxVTOF/images/06-import-export/export.png?fit=max&auto=format&n=tHXEy7Wr6vLxVTOF&q=85&s=7add24139bac56e88a0dd9152f5ad321" alt="Export dialog" width="687" height="465" data-path="images/06-import-export/export.png" />

<Tip>**Export what you see.** Filtered exports respect the filters applied in the grid; only the matching rows are written.</Tip>

## Import

Bring a file into a table:

<Steps>
  <Step title="Choose Import on the target table" />

  <Step title="Pick the source file" />

  <Step title="Map the file's columns to the table's columns" />

  <Step title="Run the import" />
</Steps>

| Format                                    |
| ----------------------------------------- |
| **CSV**                                   |
| **JSON**                                  |
| **SQL** (run a `.sql` file of statements) |

<img src="https://mintcdn.com/flextable-docs-oracle-client-choice/tHXEy7Wr6vLxVTOF/images/06-import-export/import.png?fit=max&auto=format&n=tHXEy7Wr6vLxVTOF&q=85&s=bfbf8913404a992df7fa3b3e66186128" alt="Import flow" width="1496" height="859" data-path="images/06-import-export/import.png" />

<Note>Excel is export-only, there is no `.xlsx` import.</Note>

<Card title="Whole-database backups" icon="database" href="/backup-and-restore">
  Import and export move per-table data. To copy or restore an entire database, use Backup and restore.
</Card>