> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/gui-tools/import-and-export.md).

# Import & Export

## **Import Data**

**To import data from a CSV file to a table**:

* Navigate to **`File`** > **`Import`** > **`From CSV...`**
* Or right click on the table on the left sidebar and choose **`Import`** > **`From CSV...`**

![](/files/-LrtIFzcAzy47psYbpv2)

{% hint style="info" %}
You can import a CSV file and choose to create a new table if it doesn't exist.
{% endhint %}

**To import data from a SQL dump file**:

* Navigate to **`File`** > **`Import`** > **`From SQL Dump...`**
* Or right click on the left sidebar and choose **Import** > **`From SQL Dump...`**

![](/files/-LrtILCS4Xd154YIQQHt)

## **Export Data**

You can export data from the current database to a CSV, JSON, or SQL file.

* Select table(s), navigate to **`File`** > **`Export`**
* Or select table(s), right click and choose **`Export...`**
* Specify the file output and click **`Export...`** button so save it on your disk.

![](/files/-LrtIP46CsqxUUxMv-gL)