---
title: "Editing CSV Records in a Form"
slug: "editing-csv-records-in-a-form"
description: "Learn how the CSV Editor Form Control allows editing CSV-formatted tabular data, such as a spreadsheet. A CSV Editor can use Flow data as its Input and then output the edited values back into the Flow."
updated: 2026-07-01T19:36:56Z
published: 2026-07-01T19:36:56Z
canonical: "documentation.decisions.com/editing-csv-records-in-a-form"
---

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

# Editing CSV Records in a Form

## Overview

The **CSV Editor Form Control** allows editing CSV-formatted tabular data, such as a spreadsheet. A CSV Editor can use Flow data as its Input and then output the edited values back into the Flow.

---

## Example

1. From a **Designer Project**, select the CREATE FLOW button from the **Global Action Bar**; select **Flow**, provide a **Name,** and click CREATE.
2. From the **Flow Designer**, click the SETUP INPUT DATA button. Then, click DEFINE.
3. In the **Data Definitions** screen, NAME the **Data** "File", and select **File Data** from the TYPE drop-down. **Save** the Data Definition, then close the window.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1782934567194.png)
4. Attach a **Show Form** step from the FAVORITE STEPS category of the **Toolbox** tab to the **Start** step.
5. From the Show Form step's **Properties** tab, click PICK OR CREATE FORM, select CREATE, choose **Form**, provide a Name, then click CREATE.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1780514181349.png)
6. From the **Form Designer**, create a Form containing a **Button** component from the FAVORITES category of the **Toolbox** tab and a **CSV Editor** from **Toolbox > DATA > FILE**.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1780514442313.png)
7. Save the Form, then close the Form Designer via X.
8. Back in the Flow Designer, connect the Done path to the End step, then navigate to the Show Form step's Properties. Under INPUTS, map the **File** to **CSVEditor**.
9. Save the Flow, then if desired, close with X.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1780514479326.png)

---

## Debug

1. From the **Flow Designer**, select the **Debug** link from the top action bar.
2. In the **Debugger**, use the **Drag file here** field or the CHOOSE FILE button to select the desired **CSV** file.
3. Click **START DEBUGGING**.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1782934604053.png)
4. Make any desired edits to the CSV file.

To edit any cell, select the cell, then adjust the value and either press the enter key or click out of it.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1780514555222.png)
5. Click the **Download** button and verify the contents of the spreadsheet.

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1780514571339.png)

---

## Additional Line Separators

The Additional Line Separators Property has two options: Line Feed and Carriage Return. In CSV files, especially on Windows, carriage return (\r) and line feed (\n) characters, often combined as \r\n, are used to separate rows (or records). However, within data cells, particularly in text fields, a carriage return can cause issues when parsed, as it can be misinterpreted as the end of a row.

When the property is set to true, the CSV Editor displays linefeed values as separate rows. When the property is set to false, the CSV Editor displays linefeed values as separate lines within the same cell.

There is also an 'All' option that will enable or disable both options at the same time.

---

## Feature Changes

| Description | Version | Release Date | Developer Task |
| --- | --- | --- | --- |
| Added the "Additional Line Separator" property. | [9.9](https://documentation.decisions.com/v99/docs/version-99x-release-notes) | April 2025 | [DT-044174] |
| The Additional Line Separator property is now set to false by default. This will only impact new controls. | [9.16](https://documentation.decisions.com/v99/docs/version-916x-release-notes) | October 2025 | [DT-045286] |
| The Additional Line Separators property has been removed from the CSV Editor Form Control for Linux. | [9.22](https://portal.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/document/v99/view/370aa408-2485-430c-821a-e1ee1ffb0811) | April 2025 | [DT-046994] |