# CSV

## Introduction

The CSV library within the Automate platform offers powerful actions for handling CSV files, providing users with the ability to read and export data efficiently.

The purpose of the CSV library is to streamline data processing workflows by enabling users to manipulate CSV files directly within Automate. This component facilitates tasks such as reading CSV data for automation and exporting CSV files to Excel for further analysis.

## What is CSV?

The CSV library in Automate allows users to interact with CSV files, a common format for tabular data storage. Users can perform actions such as reading CSV files to extract data and exporting CSV data to Excel files for reporting and analysis.

#### Key Features

* <mark style="color:orange;">**Export to Excel:**</mark> <mark style="color:orange;"></mark><mark style="color:orange;">Export CSV data to an Excel file effortlessly.</mark>
* <mark style="color:orange;">**Read CSV Data:**</mark> <mark style="color:orange;"></mark><mark style="color:orange;">Read CSV files to utilize data within automation workflows.</mark>
* <mark style="color:orange;">**Customizable Options:**</mark> <mark style="color:orange;"></mark><mark style="color:orange;">Configure CSV actions with various parameters for flexible usage.</mark>

## How To Use Action

{% embed url="<https://drive.google.com/file/d/1gbnj6l3pN68MUbbBoufrHSHJqhXOw30K/view?usp=sharing>" %}

### Export to Excel

**Description:** The Export to Excel action allows users to export CSV data to an Excel file.

**Usage:**

1. **CSV Source:**
   * Select the variable containing the CSV source data.
2. **Excel Path:**
   * Specify the path where the Excel file will be exported.
3. **Assign Excel File Path:**
   * Choose a string variable to assign the full path of the exported Excel file.

### Read

**Description:** The Read CSV Data action is used to read a CSV file and retrieve its contents for use in workflows.

**Usage:**

1. **File Path:**
   * Define the path to the CSV file to be read.
2. **Open Option:**
   * Select the desired open option:
     * **Read Only:** The file cannot be changed or saved.
3. **Contains Header:**
   * Check this option if the CSV file contains a header row.
4. **Assign CSV Source Data:**
   * Select a datatable variable to assign the CSV source data.
5. **Assign File Path:**
   * Choose a string variable to assign the file path of the CSV file.

{% hint style="info" %}

### **Hint**

* For CSV files exceeding 250 MB, consider splitting the file into smaller parts or using alternative processing approaches to maintain compatibility with Autom Mate workflows.
  {% endhint %}

{% hint style="danger" %}

### **Warning**

* **Limitation**: CSV files larger than 250 MB will not be processed by the **CSV Read** action.
* Attempting to process oversized files may result in action errors or workflow disruptions.
  {% endhint %}

***


---

# 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.autommate.com/userguide/libraries/transform/csv.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.