> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vectorshift.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV Reader Node

> Read a CSV file

<img src="https://mintcdn.com/vectorshift/YP4-JQlrCs6FGFt3/images/platform/pipelines/data-transformation/csv-reader.png?fit=max&auto=format&n=YP4-JQlrCs6FGFt3&q=85&s=7c637b6dfe78809611edf2416bde4b22" alt="CSV Reader" width="605" height="273" data-path="images/platform/pipelines/data-transformation/csv-reader.png" />

This node reads the data from a CSV/Excel file and outputs data in each column as a list.

## Node Inputs

1. File: The CSV file you want to read.
   * Type: `File`

## Node Parameters

1. File Type: The type of file you want to read. The available types are: CSV and Excel. The default is CSV.

## Node Outputs

Dynamic Outputs: All the headers for columns will be treated as individual outputs with the types as `List<Text>`.

## Considerations

* For CSVs, the file must have headers in the file.

## Example

The below example shows a pipeline that takes in a CSV file and outputs the data from a column as a list.

1. CSV Reader Node: Reads the CSV file.
   * File: `File.csv` file created in the [CSV Writer Example](/platform/pipelines/data-transformation/file/csv-writer#example)
   * File Type: `CSV`
2. Output Node: Displays the data in each column as a list
   * Output: `{{csv_reader_0.fruit_a}}`

<img src="https://mintcdn.com/vectorshift/YP4-JQlrCs6FGFt3/images/platform/pipelines/data-transformation/csv-reader-example.png?fit=max&auto=format&n=YP4-JQlrCs6FGFt3&q=85&s=3385e3766ed515ad438051ee2803d735" alt="CSV Reader Example" width="1907" height="834" data-path="images/platform/pipelines/data-transformation/csv-reader-example.png" />

CSV Utilized

<img src="https://mintcdn.com/vectorshift/PSG1OGMwi51Mi0EL/images/Screenshot2025-04-13at8.53.51PM.png?fit=max&auto=format&n=PSG1OGMwi51Mi0EL&q=85&s=26e0d93ea7a82a82c0ce42980f826550" alt="Screenshot2025 04 13at8 53 51PM Pn" width="1466" height="690" data-path="images/Screenshot2025-04-13at8.53.51PM.png" />
