# 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.gaiodataos.com/tools/tasks/etl/csv-local.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.