Skip to main content
Go to the Studio
CSV

For each column in CSV file

For each column in CSV file

Goes through every column of a specific row of a CSV file, running a block of actions for each column. Ideal for processing data laid out in columns within a CSV row.


Options​

CSV file​

Select the CSV file already read by a previous CSV file reading action. The field lists the CSV files available in the flow.

For each row action​

Select the For each row in CSV file action already in use in the flow. This action uses its current row as the reference to go through the columns.

Custom range​

Lets you set manually the range of columns to go through. When enabled, it shows the fields:

CSV file initial column​

Enter the letter of the column where the iteration starts (e.g. A). By default, it starts on column A.

Final column of CSV file​

Enter the letter of the column where the iteration ends (e.g. Z). By default, it goes up to the last filled column.

Returns​

  • Current line — Returns the number of the current row being processed.
  • Current column position — Returns the position (index or letter) of the column being processed in the current iteration.

Rules and Conditions​

  • The CSV file and For each row action fields are required.
  • This action must be used inside a For each row in CSV file block.
  • When the custom range is enabled, the initial and final column fields become required.