flowingTable - Table Editor

crossorigin="anonymous">

Drag a file here or click

File has a header

File Type:

Welcome! We are constantly improving. Your feedback is welcome. Please report any issues or suggestions on our Contact Page.

Welcome to flowingTable!

To get started, import a table using the side menu or drag a file here.

Cell Content

substitute: Replace text or rename columns.
handle missing: Remove or fill empty values.

Handle Missing Values

Remove rows with empty values
Fill empty values with

In columns (optional):

Insert Column:

Rows & Columns

select: Select or remove rows/columns.
filter: Keep rows based on a condition.
sort: Sort the table by a column.
rename column: Rename a column header.
Create/Modify Column (Formula): Create new columns from existing ones.
add column: Add a new column with specified values.
Filter by Text Pattern (Regex): Keep rows matching a text pattern.
remove duplicates: Remove duplicate rows/cols.
sample: Get a random sample of rows.

Select Rows/Columns

Columns:

Remove columns

Rows:

Remove rows

Mutate (Create Column)

Insert Column:

Insert Function:

Table Structure

merge: Join two tables based on a key.
stack: Append one table to another.
transpose: Flip rows and columns.
aggregate: Group data by columns and summarize.
Summarize into Columns (Pivot): Transforms a column's values into new headers, grouping data.
Ungroup Columns (Unpivot): Transforms column headers into a single 'category' column and another 'value' column.

Aggregate

Group by columns:

Insert Group Column:

Summarize column: With function:

Pivot Table

Index columns:

Insert Index Column:

Columns column:

Insert Columns Column:

Values columns:

Insert Values Column:

Melt (Unpivot)

ID Columns:

Insert ID Column:

Value Columns (optional):

Insert Value Column:

Welcome to flowingTable!

Cell Content

Substitute

Handle Missing Values

Rows & Columns

Select Rows/Columns

Filter

Sort

Rename Column

Mutate (Create Column)

Add Column

Grep (Regex Filter)

Remove Duplicates

Sample

Table Structure

Merge Tables

Stack Tables (rbind/cbind)

Transpose Table

Aggregate

Pivot Table

Melt (Unpivot)

Welcome to flowingTable!

Cell Content

Substitute

Handle Missing Values

Rows & Columns

Select Rows/Columns

Filter

Sort

Rename Column

Mutate (Create Column)

Add Column

Grep (Regex Filter)

Remove Duplicates

Sample

Table Structure

Merge Tables

Stack Tables (rbind/cbind)

Transpose Table

Aggregate

Pivot Table

Melt (Unpivot)

Import to New Flow