Read From Csv File Step

The Read From CSV File step takes data from a CSV file and puts it into a DataTable variable. You can set your own separator, tell it if there's a header row, and say how many columns to bring in.

How to Use Read From CSV File

This step takes CSV file data and puts it into a structured DataTable. After that, you can work with the data.

Step 1: Add the Read From CSV File Step

Drag the Read From CSV File step into your process.
(Optional) Give it a Step name to label it in the editor.

Step 2: Configure Input Parameters

In the CSV file path field, type the full path to your CSV file. You need to do this.
For File has header row, pick T (true) if the first row of your CSV file has column titles. Pick F (false) if it doesn't. F is the default.
In the Delimiter field, type the character your CSV file uses to separate values. For example, a comma (,), semicolon (;), or tab (\t).

Step 3: Configure Output Parameters

In the Result DataTable field, type the name for your new DataTable variable. This variable will hold the CSV data.
- You can set how many columns to create in the DataTable. If you give a number, it will only read that many columns from the CSV file.
- If you leave this field blank, it will bring in all columns from the CSV file automatically.
(Optional) In the Column count field, name a variable to store the number of columns read from the CSV file.
(Optional) In the Row count field, name a variable to store the number of rows read from the CSV file.

Important: When you make the Result DataTable, you can set the number of columns and their names yourself. If your CSV file has more columns than you set in the DataTable, it will only bring in the number of columns you specified. It will ignore the rest.

Need Help?

Can't find what you're looking for? Join the Robotiq Community to get help from other users and the Robotiq team.