Read CSV
Reads data from a CSV file and outputs a data table
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.
Input
- File Path - Path of the CSV file to read
Output
- Table - Data read from the CSV file in data table format
Options
-
Separator - The delimiter used in the CSV file
- Comma (,)
- Semicolon (;)
- Tab (TAB)
- Space
-
Skip Rows - The number of rows to be skipped at the beginning of the CSV file
-
Open with Encoding - The encoding type of the CSV file
- UTF-8
- UTF-16
- Windows 1250
- Windows 1251
- Windows 1252
- Windows 1253
- Windows 1254
- Windows 1255
- Windows 1256
- Windows 1257
- Windows 1258
- ISO 8859-1
- ISO 8859-2
- ISO 8859-3
- ISO 8859-4
- ISO 8859-5
- ISO 8859-6
- ISO 8859-7
- ISO 8859-8
- ISO 8859-9
- ISO 8859-10
- ISO 8859-13
- ISO 8859-14
- ISO 8859-15
- ISO 8859-16
- Macintosh
- KOI8-R
-
Headers - Indicates whether the CSV file has headers or not
-
Jsonify - Transforms the header names into a JSON-friendly format by converting them to lowercase and replacing spaces with underscores.