The CSV Reader step Parses a file defined by comma separated values.

1. Click on the highlighted icon as illustrated in the image below.

2. Select or search for the CSV Reader. Click on the Reader tab and select CSV, as shown in the page below.

The image below illustrates the configuration in the CSV reader step.

Field Delimiter - Determines characters separating fields.

Row Delimiter - Determines characters indicating the end of a row. "CR LF" is selected by default when the CSV reader step is added.

Text Qualifier Character - Specifys the values that should be treated as text. This field is blank by default when the CSV reader step is added.

Comment Character - Indicates that there is a comment in a row, and that row will be skipped. The "#" character is selected by default when the CSV reader step is added.

Escape Character - Indicates that the field or row should be ignored. This field is blank by default when the CSV reader step is added.

The configuration illustrated below are enabled when the checkbox next to them is selected.

Field Names in Header Field - Fetches the header field names from the CSV file and automatically sets the field names. The checkbox is selected by default when the CSV Reader step is added.

Skip Header Rows Field - Indicates the number of rows to skip before the header row. Type the desired number and it will skip any rows that may be above the header in the CSV file. If the ‘3’ is inputted, the first 3 rows will be skipped; therefore making the fourth row as the headers. The default number is 0 when the CSV Reader step is added.

Expand Field Names Checkbox - Creates sub-object fields using a dot “.” character. The checkbox is selected by default when the CSV Reader step is added.

Auto Convert Values Checkbox - Automatically converts values in the CSV file to JSON values. The checkbox is not selected by default when the CSV Reader step is added.

Enforce Field Number Checkbox - Ensures that each row has the same number of fields. The checkbox is not selected by default when the CSV Reader step is added.

Trim Checkbox - Trims all leading and trailing spaces on the right and the left of the field of the CSV file. The checkbox is not selected by default when the CSV Reader step is added.

Left Trim Checkbox - Trims all leading spaces on the left of the field of the CSV file. The checkbox is not selected by default when the CSV Reader step is added.

Right Trim Checkbox - Trims all trailing spaces on the right of the field of the CSV file. The checkbox is not selected by default when the CSV Reader step is added.

Ignore Empty Rows Checkbox - Ignores all empty rows of the CSV file.

String Encoding Field - Determines the code that will be used to encode strings. It is set to Utf28 by default when the CSV step is added. Other options are ASCII or Latin1.

The Max Row Size Field - Determines the maximum length a row can be.

The image below shows the data in a CSV worksheet.

To view the data from a worksheet using the CSV Reader step, please follow these instructions:

1. Click on the play button on the CSV Reader step as highlighted in the image below.

2. Click the outlined area in the image below to upload a CSV file.

3. Click the Test button as shown in the image below.

The image below illustrates how the data will look once it has been returned by the CSV Reader step.