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 > Archive > L1-DS KNIME Analytics Platform for Data Scientists - Basics (deprecated) > Exercises > 04 Data Transformation
    knime
  2. 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 > Archive > L2-DS KNIME Analytics Platform for Data Scientists - Advanced (deprecated) > Exercises > 01 Date and Time Manipulation
    knime
  3. 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 > Archive > L2-DS KNIME Analytics Platform for Data Scientists - Advanced (deprecated) > Exercises > 03 Flow Variables
    knime
  4. 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 > Archive > L2-DS KNIME Analytics Platform for Data Scientists - Advanced (deprecated) > Exercises > 04 Components
    knime
  5. 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
    knime
  6. Flow Variables and Components - Exercise
    Flow variable Table row to variable Component
    +1
    This workflow shows a hands-on exercise in the L2-DS Introduction to KNIME Analytics Plat…
    knime > Education > Self-Paced Courses > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02 Flow Variables and Components
    knime
  7. 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
    barbora
  8. 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
    bojesphob
  9. 1
    lina3 > Public > Lab 3 > 1
    lina3
  10. 02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    mcmas1999 > Assignments > Lab 01 > Project 1 - mickelma > 02 Accessing Databases
    mcmas1999