# 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...`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrtE1v94o6zMQ-Irdd0%2F-LrtIFzcAzy47psYbpv2%2Fimport%20csv.png?alt=media\&token=bc64a08c-45d8-465e-b024-4f2b47a8dd1f)

{% 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...`**

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrtE1v94o6zMQ-Irdd0%2F-LrtILCS4Xd154YIQQHt%2Fimport%20sql.png?alt=media\&token=d916f4a5-c897-4bc3-b795-9301a9afc67f)

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

![](https://2743975646-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LriZ7WXXZykpg6_MQsw%2F-LrtE1v94o6zMQ-Irdd0%2F-LrtIP46CsqxUUxMv-gL%2Fexport.png?alt=media\&token=a08807dc-c63b-4bb3-bb4d-0691c49a6629)