Hub
NodeNode / Source

CSV Reader

IO Read Streamable
Drag & drop
Like
Copy short link

Reads CSV files. To auto-guess the structure of the file click the Autodetect format button. If you encounter problems with incorrect guessed data types disable the Limit data rows scanned option in the Advanced Settings tab. If the input file structure changes between different invocations, enable the Support changing file schemas option in the Advanced Settings tab. For further details see the KNIME File Handling Guide File Handling Guide .

Note: If you find that this node can't read your file, try the File Reader node. It offers more options for reading complex files.

This node can access a variety of different file systems. More information about file handling in KNIME can be found in the official File Handling Guide.

Node details

Output ports
  1. Type: Table
    File Table
    File being read with number and types of columns guessed automatically.
File System Connection (Dynamic Inport)
The file system connection.
  1. Type: File System

Extension

The CSV Reader node is part of this extension:

Related workflows & nodes

  1. 04 Data Transformation
    Rule engine String manipulation Math formula
    +1
    Exercise for transforming data. Perform data transformations with the Rule Engine, Math F…
    knime > Education > Self-Paced Courses > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 04 Data Transformation
  2. Exercise 1: Loading and Exploring Data
    Time Series Energy Usage Education
    +2
    This workflow accesses, preprocesses, and visualizes time series (energy consumption) dat…
    knime > Education > Courses > L4-TS Introduction to Time Series Analysis > Exercises > Session_1 > 01_Load_Clean_and_Explore
  3. Text Mining Course: Classification III (bonus)
    Education
    - Create document cells - Preprocess documents - Create document vectors for the set of d…
    knime > Education > Courses > L4-TP Introduction to Text Processing > exercises > 09 Classification III - bonus
  4. 01 Date and Time Manipulation
    Date Time String to date&time
    +2
    Exercise for date and time manipulation. Transform date and time values from string to th…
    knime > Education > Self-Paced Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 01 Date and Time Manipulation
  5. 03 Flow Variables
    Flow variable Table row to variable
    Exercise for creating and using flow variables. Filter data based on a previous result in…
    knime > Education > Self-Paced Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 03 Flow Variables
  6. 04 Components
    Configuration Flow variable Component
    +1
    Exercise for creating a component and using a shared component. Create a component that f…
    knime > Education > Self-Paced Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 04 Components
  7. 02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    mcmas1999 > Assignments > Lab 01 > Project 1 - mickelma > 02 Accessing Databases
  8. Workflow containing visualizations for time series
    Line Plot Line plot
    +9
    This workflow illustrates how to illustrate time series with line plot and stacked area c…
    barbora > Courses > L4-DV Codeless Data Exploration and Visualization_06.2021 > L4-DV Codeless Data Exploration and Visualization - Demos > Demos empty > Session_01b_charts_demo 2_line_empty
  9. 1
    lina3 > Public > Lab 3 > 1
  10. 01 Read Data From File
    Csv Data access Education
    +2
    Exercise for reading data from a file
    bojesphob > Public > Lab 3 > 01 Read Data from File