> For the complete documentation index, see [llms.txt](https://docs.gaiodataos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gaiodataos.com/tools/tasks/etl/csv-local.md).

# CSV Local

<figure><img src="/files/ozxg9jiWK2r8sTVRd9By" 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