Skip to main content

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.