# CSV Local

<figure><img src="https://1671598980-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0muDd0LkZG6CmTQvGQ4D%2Fuploads%2FlK9kfrZ8cqn1jnI4tILA%2FCSV%20Local%20-%201.png?alt=media&#x26;token=28877c85-536d-462c-81a6-5e4699ff1988" alt=""><figcaption></figcaption></figure>

The **CSV Local** task in **Gaio DataOS** allows you to automatically import CSV files that have been uploaded to a **local directory within the platform environment**.\
This is ideal for handling input files delivered manually or through integrations with external systems that deposit files into internal folders for processing.

***

## &#x20;How to Use

### **1. Open the Task**

Navigate to: **Tasks > ETL > CSV Local**

***

### **2. Fill in the Task Fields**

* **Task label:** (Optional) Name to identify the task in your flow.
* **Result table:** Name of the table to be created or updated with the CSV content.
* **Separator:** Delimiter used in the CSV (`comma`, `semicolon`, `tab`, etc.)
* **Folder:** Folder path where the CSV file was uploaded (e.g., `~/content/apps/31/imports/`)

{% hint style="warning" %}
You must **enter only the folder path**, not the file name.
{% endhint %}

***

### **3. Advanced Options**

* **Auto detect schema (column names)**\
  Automatically detects column names and data types from the first row of the file.
* **Insert mode: append records to table**\
  If enabled, new CSV records will be **appended** to the existing table.\
  If disabled, the table will be **overwritten**.
* **Delete after import**\
  Deletes the file from the folder after successful import.\
  Recommended to prevent reprocessing or cluttering the folder.

***

### **4. Save and Execute**

* Click **Save** to add the task to your flow.
* When the flow runs, the system will automatically retrieve the most recent CSV file from the specified folder and import its content based on your settings.

***

#### Use Cases

* Process files uploaded manually or via FTP/SFTP
* Integrate systems that export CSV files to internal directories
* Automate batch data ingestion (e.g., sales, inventory, customer records)
* Manage file lifecycle with automatic deletion after import