Skip to main content
Go to the Studio
File Management

CSV file reading

CSV file reading

Reads a CSV file and returns its content as a list of values. It allows you to configure the separator used in the file to guarantee the correct reading of the data.


Options​

CSV file path​

Enter the full path of the CSV file to be read, including the name and the extension. Example: C:\Desktop\data.csv.

Separator​

Enter the character used as the column separator in the CSV file. The default separator is ; (semicolon), but it may vary depending on the file (e.g. , or |).

Returns​

  • List of files — Returns a list with all the values of the CSV file organized in rows and columns.
  • Number of files — Returns the total number of rows of the CSV file.

Rules and Conditions​

  • The CSV file path field is required.
  • The separator must match the one used in the file; otherwise, the columns will not be separated correctly.
  • To go through it row by row after the reading, use the For each CSV row or For each CSV column actions.
  • To get or set the value of a specific cell, use Get cell value or Set cell value.