Hub
Pricing About
Collection

Starter collection

SpreadsheetsExcelCSVBeginners

Discover beginner-friendly examples, familiarize yourself with essential nodes, and integrate spreadsheets to start your journey with the KNIME Analytics Platform.

New to KNIME?
Get started with the Release of Version 5 of the KNIME Analytics Platform to use all the examples and nodes you need for an easy start!
Jul 19, 2024 1:29 PM
Like

Workflow examples

Below, find examples for the most common data manipulation tasks. Recommended for beginners, particularly spreadsheet users, who are new to visual workflows
Reading spreadsheets
Start your data analysis journey with KNIME: A beginner’s workflow list for reading in data.
Go to item
Workflow
Merge Files
SpreadsheetsExcelMerge
This workflow merges different unstructured data sources to come up with a new table.Since data come from different data files, w…
KNIME for Spreadsheet UsersMerge Files
7
knime
Go to item
Workflow
Non-standard format Spreadsheets
ExcelSpreadsheet
This workflow shows how to work with spreadsheets that come in a non-standard format using KNIME Analytics Platform. The aim is t…
KNIME for Spreadsheet UsersNon-standard format Spreadsheets
3
knime
Go to item
Workflow
Read Data from Different Sources
This workflow shows how to read, merge and manipulate data from different sources (Gsheet, excel file) using KNIME Analytics Plat…
KNIME for Spreadsheet UsersRead Data from Different Sources
0
knime
Go to item
Workflow
Joining Spreadsheets
SpreadsheetJoinExcel
In this workflow, we see how to use the Joiner node to clean up a dataset using KNIME Analytics Platform. Sometimes more than a V…
KNIME for Spreadsheet UsersJoining Spreadsheets
0
knime
Go to item
Workflow
Calculate Totals (Multiple Files)
ExcelSpreadsheetConcatenate
This workflow shows how to calculate the totals of multiple files using KNIME Analytics Platform. The aim is to concatenate the i…
KNIME for Spreadsheet UsersCalculate Totals (Multiple Files)
1
knime
Manipulating data in spreadsheets
Learn how to automate the combining of data from disparate spreadsheets.
Go to item
Workflow
VLOOKUP Function (Same Sheet)
VLOOKUPSpreadsheetExcel
This workflow shows how to perform a VLOOKUP function between two tables in the same sheet, using KNIME Analytics Platform. The w…
KNIME for Spreadsheet UsersVLOOKUP function (Same Sheet)
4
knime
Go to item
Workflow
CountIf and SumIf
This workflow shows how to perform a SumIf and a CountIf function in KNIME Analytics Platform. Of course, there are different way…
KNIME for Spreadsheet UsersCountIf and SumIf
3
knime
Go to item
Workflow
Pivot Table
SpreadsheetExcel
A pivot table aims to arrange a table so that other stakeholders can easily share and understand data. Let’s walk through the dif…
KNIME for Spreadsheet UsersPivot Table
1
knime
Go to item
Workflow
Join Strings (Multiple Sheets)
ExcelSpreadsheetConcatenate
+1
This workflow shows how to concatenate tables from two different sheets and combine string-type columns using KNIME Analytics Pla…
KNIME for Spreadsheet UsersJoin Strings (Multiple Sheets)
1
knime
Go to item
Workflow
VLOOKUP Function (Different Files)
ExcelSpreadsheetValue Lookup
+2
This workflow shows how to perform a VLOOKUP function on a table using a table from a different file as dictionary, in KNIME Anal…
KNIME for Spreadsheet UsersVLOOKUP function (Different Files)
1
knime
Advanced spreadsheet manipulation
Once you have the hang, the fundamentals, check out some real-world advanced examples below.
Go to item
Workflow
Charts and Spreadsheets
Value LookupPie ChartBar Chart
+3
This workflow shows how to create charts from spreadsheet data and add them to a new spreadsheet using KNIME Analytics Platform. …
KNIME for Spreadsheet UsersCharts and Spreadsheets
2
knime
Go to item
Workflow
Create and Send Report
ExcelEmailReport
Create And Send Report In this workflow, we see how to build and send a report via email using KNIME Analytics Platform. The idea…
KNIME for Spreadsheet UsersCreate and Send Report
4
knime
Go to item
Workflow
Spreadsheets and Loops
ExcelSpreadsheetLoops
Spreadsheets and Loops This workflow shows how to append additional sheets to an existing spreadsheet with a loop using KNIME Ana…
KNIME for Spreadsheet UsersSpreadsheets and Loops
2
knime
Go to item
Workflow
Time-over-Time Analysis
In this example, we perform a Time-over-Time analysis using a handful of KNIME nodes. Taking as input the Olympics Games Medals b…
KNIME for Spreadsheet UsersTime-over-Time Analysis
1
knime
Go to item
Workflow
Prediction within Spreadsheets
ExcelSpredsheetsPrediction
+1
This workflow shows how to load and prepare data for training a predictive model using some excel files. All data are stored alre…
KNIME for Spreadsheet UsersPrediction within Spreadsheets
2
knime

Nodes for data access

Accelerate your data access with KNIME’s comprehensive suite of data access nodes - the fastest, most efficient way to connect to and retrieve data from a wide range of sources.
Reading
Node / Source
Excel Reader

This node reads Excel files (xlsx, xlsm, xlsb, and xls format). It can read a single or multiple files at the same time, however reading only one sheet per file. The supported Excel types that can be… Learn more

Node / Manipulator
Google Sheets Reader

This node reads a tab (sheet) of a Google spreadsheet. The spreadsheet can be selected from the spreadsheets available on Google Drive. Optionally, a specific range can be read from the sheet. The ra… Learn more

Writing
Node / Sink
Excel Writer

This node writes the input data table into a spreadsheet of an Excel file, which can then be read with other applications such as Microsoft Excel. The node can create completely new files or append d… Learn more

Node / Manipulator
Google Sheets Writer

This node writes the input data table to a new Google Sheets spreadsheet. If you want to overwrite or append data to an existing sheet, you cannot use the Google Sheets Writer node; you must use the … Learn more

Connecting to services
Node / Source
Microsoft Authenticator

This node provides authentication to access Microsoft Azure and Office 365 cloud services. Learn more

Node / Source
SharePoint Online Connector

This node connects to a SharePoint Online site. The resulting output port allows downstream nodes to access the document libraries of the site as a file system, e.g. to read or write files and folder… Learn more

Node / Source
Google Authenticator

This nodes authenticates to Google services specified in the node settings.Authentication happens in the configuration window. Learn more

Nodes for visualizing

Node / Visualizer
Bar Chart

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

Node / Visualizer
Line Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

Node / Visualizer
Pie Chart

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

Node / Visualizer
Stacked Area Chart

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the aggregation method and enable certain controls, which ar… Learn more

Node / Visualizer
Scatter Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

Node / Visualizer
Statistics

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the columns you want to display. Only numeric and text based… Learn more

Node / Visualizer
Heatmap

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the columns to use for horizontal and vertical dimensions an… Learn more

Node / Visualizer
Histogram

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the binning method and enable certain controls, which are th… Learn more

Node / Visualizer
Density Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can enable certain controls, which are then available in the view. This… Learn more

Node / Visualizer
Box Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can enable certain controls, which are then available in the view. This… Learn more

Node / Visualizer
Table View

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the amount of rows you want to display and enable certain co… Learn more

Node / Visualizer
Parallel Coordinates Plot

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

Node / Visualizer
Scatter Plot Matrix

The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose the size of a sample you want to display and enable certain … Learn more

Node / Visualizer
Sunburst Chart

This node displays hierarchical data in a radial layout. The view can be accessed either via the “Open view” action on the executed node or on KNIME Hub. In the node configuration, you can choose inp… Learn more

Nodes for data transformation

Transform your data in sophisticated ways easily possible with KNIME
Aggregating & reshaping
Node / Manipulator
Pivot

Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, whereby the pivot values turned into columns… Learn more

Node / Manipulator
Cell Splitter

This node uses a user-specified delimiter character to split the content of a selected column into parts. It appends either a fixed number of columns to the input table, each carrying one part of the… Learn more

Node / Manipulator
Sorter

This node sorts the rows according to user-defined criteria. In the dialog, select the columns according to which the data should be sorted. Also select whether it should be sorted in ascending or de… Learn more

Node / Manipulator
Column Combiner

Combines the content of a set of columns and appends the concatenated string as separate column to the input table. The user needs to specify in the dialog the columns of interest and some other prop… Learn more

Node / Manipulator
Unpivot

This node rotates the selected columns from the input table to rows and duplicates at the same time the remaining input columns by appending them to each corresponding output row. Example: Input: Val… Learn more

Node / Manipulator
Moving Aggregator

This node calculates aggregation values for a moving window. The aggregation values are displayed in new columns appended at the end of the table. The columns to aggregate can be either defined by se… Learn more

Node / Manipulator
Table Splitter

The Table Splitter splits the input table at the row that matches a given condition. The part of the table that occurred before the matching row is forwarded to the top output table. The bottom outpu… Learn more

Node / Manipulator
Cell Extractor

Extract a single cell from the input table and output it as a 1x1 table. A flow variable containing the value of the cell will also be created. Learn more

Value creation
Node / Manipulator
Math Formula

This node evaluates a mathematical expression based on the values in a row. The computed results can be either appended as new column or be used to replace an input column. Available variables are th… Learn more

Node / Manipulator
String Replacer

This node replaces strings in a selected target column. In the configuration dialog, a pattern and a replacement text are specified. If the pattern doesn’t match, the result string equals the input s… Learn more

Node / Manipulator
String Replacer (Dictionary)

This node replaces strings in selected columns. The dictionary table provides the patterns to search for and the values to replace matches with. If no pattern matches, the result string equals the in… Learn more

Node / Manipulator
Cell Updater

Update a single cell of the input table with the value of the specified flow variable. The output table will be identical to the input table except for the single updated cell. Learn more

Merging
Node / Manipulator
Concatenate

This node concatenates two tables. The table at inport 0 is given as the first input table (top input port), the table at inport 1 is the second table, resp. Columns with equal names are concatenated… Learn more

Node / Manipulator
Value Lookup

The node has two inputs: a data table and a dictionary table. From the data table select the column that is used to look up values in the dictionary table. From the dictionary table select a column t… Learn more

Node / Manipulator
Joiner

This node combines two tables similar to a join in a database. It combines each row from the top input port with each row from the bottom input port that has identical values in selected columns. Row… Learn more

Node / Manipulator
Column Appender

The Column Appender takes two or more tables and quickly combines them by appending their columns according to the order of the tables at the input ports. It simply appends columns from the second in… Learn more

Filtering
Node / Manipulator
Row Filter

The node filters an input table according to the given filter criteria. Each criterion can target the row number, RowID, or cell value of a row. Multiple criteria can be combined Learn more

Node / Manipulator
Column Filter

This node allows columns to be filtered from the input table while only the remaining columns are passed to the output table. Within the dialog, columns can be moved between the Include and Exclude l… Learn more

Node / Manipulator
Top k Row Filter

The node behaves the same as a combination of the Sorter node followed by a Row Filter that only keeps the first k rows of the table except for the order of the rows which depends on the Output order… Learn more

Node / Manipulator
Table Cropper

Crops part of the input table based on the chosen column and row range. Learn more

Cleaning
Node / Manipulator
Missing Value

This node helps handle missing values found in cells of the input table. The first tab in the dialog (labeled “Default”) provides default handling options for all columns of a given type. These setti… Learn more

Node / Manipulator
Duplicate Row Filter

This node identifies duplicate rows. Duplicate rows have identical values in certain columns. The node chooses a single row for each set of duplicates (“chosen”). You can either remove all duplicate … Learn more

Node / Manipulator
Column Merger

Merges two columns into one by choosing the cell that is non-missing. The configuration dialog allows you to choose a primary and a secondary column. The output of the node will be a new column (or a… Learn more

Node / Manipulator
Column Renamer

Renames columns according to the renaming scheme defined in the dialog. Column names must be unique, hence it is not possible to give two columns the same name. Learn more

Type conversion
Node / Manipulator
String To Number

Converts strings in a column (or a set of columns) to numbers. If the node fails to parse a string, it will generate a missing cell and append a warning message to the KNIME Console with detailed inf… Learn more

Node / Manipulator
String to Date&Time

Parses the strings in the selected columns and converts them into Date&Time cells. The expected format can be selected from a number of commonly used formats or specified manually (see section “Type … Learn more

Date & time handling
Node / Manipulator
Date&Time Part Extractor

Extracts the selected fields from a Local Date, Local Time, Local Date Time or Zoned Date Time column and appends their values as corresponding integer or string columns. Learn more

Node / Manipulator
Date&Time Shift

The node shifts a date or time with a defined duration or granularity. The user can select the Date&Time columns to shift and the shift value. The shift value can be achieved by using either a durati… Learn more

Cheat sheet: KNIME for spreadsheet users

Use this cheat sheet, designed as a companion just for KNIME Analytics Platform Version 5, as a quick reference for the most popular nodes and their purpose.
Access cheat sheet

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits