> Markdown versions of all pages of this connector library are available by appending `.md` to the page URL. For the full index of connectors, see [llms.txt](https://connectors.appmixer.com/llms.txt).

# CSV connector

- Connector: `appmixer.utils.csv`
- Version: 2.0.9
- Components: 13 (0 triggers, 13 actions)

CSV component allows you to read and manipulate CSV files.

- Connector page: <https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9>
- Documentation: <https://docs.appmixer.com/connector-configuration/utils/csv>
- Source code: <https://github.com/clientIO/appmixer-connectors/tree/dev/src/appmixer/utils/csv>
- Download package: <https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/download>

## Authentication

**Type:** Other

## Actions (13)

- [Add Row](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.AddRow.md) (`appmixer.utils.csv.AddRow`): Append a new row to the end of a CSV file.
- [Add Column](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.AddColumn.md) (`appmixer.utils.csv.AddColumn`): Add a new column to a CSV file.
- [Create C S V](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.CreateCSV.md) (`appmixer.utils.csv.CreateCSV`): Create a new CSV file with an initial text content.
- [Add Rows](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.AddRows.md) (`appmixer.utils.csv.AddRows`): Append multiple rows to the end of a CSV file.
- [Delete Columns](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.DeleteColumns.md) (`appmixer.utils.csv.DeleteColumns`): Delete columns in a CSV file.
- [Delete Rows](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.DeleteRows.md) (`appmixer.utils.csv.DeleteRows`): Delete all the rows that match the provided filter.
- [Export C S V](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.ExportCSV.md) (`appmixer.utils.csv.ExportCSV`): Read a CSV file and output its text content.
- [Get Cell](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.GetCell.md) (`appmixer.utils.csv.GetCell`): Find the first row that matches the provided filter and return the row value under the specified column.
- [Get Row](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.GetRow.md) (`appmixer.utils.csv.GetRow`): Find the first row that matches the provided filter.
- [Get Rows](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.GetRows.md) (`appmixer.utils.csv.GetRows`): Get rows from a CSV file.
- [Import C S V](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.ImportCSV.md) (`appmixer.utils.csv.ImportCSV`): Import a CSV file.
- [Rename Column](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.RenameColumn.md) (`appmixer.utils.csv.RenameColumn`): Rename a column in a CSV file.
- [Update Rows](https://connectors.appmixer.com/connector/appmixer.utils.csv/2.0.9/component/appmixer.utils.csv.UpdateRows.md) (`appmixer.utils.csv.UpdateRows`): Update all the rows in a CSV file that match the provided filter.

## Changelog

### 2.0.9

- Security: upgraded csv-parse to 7.0.3 (GHSA-8cw4-87c7-c6xx, prototype replacement via the columns option). No change to how the CSV headers are read.

### 2.0.8

- Output examples for the CSV components.

### 2.0.7

- AddRow/AddRows: Refactored for safer async behavior: fixed error propagation, added null-checks, wrapped lock.extend() in try/catch, added a destroyed flag to avoid race conditions, improved empty-file handling, and introduced periodic lock-extension when less than 40s remain. Additional fixes include preventing double resolution in getRows, ensuring pipeline errors propagate in loadFile, correcting the close handler and using formatRow() in editCSV, renaming shadowed variables in updateRows, and making addColumn accept index 0. Added new escapeCell() method implementing RFC 4180-compliant CSV escaping to prevent CSV injection.

### 2.0.6

- Lower maxWait for quota to 60 seconds to avoid unnecessary timeouts. Affects AddRow component.

### 2.0.5

- Fixed an issue with the AddRow component that could result in an error when the input row was an array.

### 2.0.4

- Fixed an issue when loading a CSV file could throw 'Maximum call stack size exceeded' error.

### 2.0.3

- (breaking change) Fixed incorrect error message when using Filters or Values in these components: AddRow, UpdateRows, DeleteRows, GetCell, GetRow, GetRows. You will need to re-enter the values for these fields again.
- CreateCSV: make the `initialContent` required to prevent run-time exception.
- Added a warning for the AddRows component when all the added rows are empty.
- Optimized the performance of the AddRows component.
- Updated description of some components to make them more informative.
- Fixed an issue with GetCell that could result in an error when no rows are found using a filter.
- Fixed an issue when CSV processor could throw a Lock error.

### 1.3.2

- AddRows: use the textarea for rows input, improve error handling, add maximum execution time (60minutes).

### 1.3.0

- Added a new component 'AddRows' that allows you to append multiple rows to the end of a CSV file.

### 1.2.5

- Added lock mechanism to avoid race condition in 'AddRow' component.

### 1.2.4

- Fix issue with CSV module on Appmixer 5.0.0 and higher.

### 1.2.3

- Improve lock handling in the CSVProcessor.

### 1.2.2

- Fix CSVProcessor editCSV.

### 1.2.1

- Provide parseNumbers and parseBooleans options when loading CSV files.

### 1.1.1

- CSVProcessor uses new context.replaceFileStream function.

### 1.1.0

- FileId inputs changed from 'text' to 'filepicker'. Requires Appmixer 4.4.4 or higher.

### 1.0.0

- Initial version
