1 ×

CSV Reader

DeprecatedKNIME Base Nodes version 4.3.3.v202105242122 by KNIME AG, Zurich, Switzerland

Reads CSV files. Use this node if the workflow is used in a server or batch environment and the input files structure change between different invocations. In particular, this includes a variable number of input columns. Upon executing the node will scan the input file to determine number and types of the columns and output a table with the auto-guessed structure.

Note: If you are only using the desktop version of KNIME and your workflow is not meant to be used in a batch or server environment use the File Reader node. The file reader node has more configuration options and guesses meaningful default settings as it scans the input file during node configuration (in the dialog).


CSV Reader

Custom connection timeout
Optional timeout in seconds for connections when reading remote files. When no value is provided, an application-wide default timeout will be used (usually 1s).
Column Delimiter
The character string delimiting columns. Use '\t' for tab character.
Row Delimiter
The character string delimiting rows. Use '\n' for new line character.
Quote Char
The quote character.
Comment Char
A character indicating line comments.
Has Column Header
Select this box if the first row contains column name headers.
Has Row Header
Select this box if the first column contains row name headers (no duplicates allowed).
Support Short Lines
Select this box if some rows may be shorter than others (filled with missings).

Limit Rows

Skip first lines
If enabled, the specified number of lines are skipped in the input file before the parsing starts.
Limit rows
If enabled, only the specified number of data rows are read. The column header row (if selected) is not taken into account.
Scan limit
If enabled, only the specified number of input lines are used to analyze the file (i.e to determine the column types). This option is recommended for long files where the first n lines are representative for the whole file.

CSV Reader Encoding

To read a csv file that contains characters in a different encoding, you can select the character set in this tab (UTF-8, UTF-16, etc.), or specify any other encoding supported by your Java VM. The default value uses the default encoding of the Java VM, which may depend on the locale or the Java property "file.encoding"

Output Ports

File being read with number and types of columns guessed automatically.

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Base nodes from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.