Two-table operations - Table editing tools

A tool for editing two tables at the same time, which allows you to: extract/remove rows with a selection list, extract rows by matching reference columns, merge tables by the difference between reference columns, and align two tables.

Simply paste your CSV/TSV values below and select your desired action(s).

Want to manipulate only one table? Try our single-table editing tool.

Input A

Input B

Table Preview

Output Data
Delimiter: Quoted values

Actions

Reading data (necessary)

Delimiter A:

First row is a header (will be ignored)

Delimiter B:

First row is a header (will be ignored)

Extracting rows with a selection list

Reference column in A:

Row order:

As in A
As in B
Your browser does not support SVGs

Removing rows with a selection list

Reference column in A:

Your browser does not support SVGs

Extracting rows by reference columns match

Reference column in A:

Reference column in B:

Your browser does not support SVGs

Merging tables by reference columns difference

Reference column in A:

Reference column in B:

Your browser does not support SVGs

Aligning two tables

Reference column in A:

Reference column in B:

Row order:

Sort matching rows to the top
Keep the order of A

In case of ambiguous matches, to align all rows, insert:

Empty rows (minimum alignment)
Replicated rows (all combinations)
Your browser does not support SVGs

Additional settings

In case of very large tables (many thousands of rows), the table preview (not the data) needs to be limited to pre-set maximum numbers of rows and columns to prevent slowdown or even freezing of the app. Some patience still may be needed with bigger data.

Maximum number of rows in preview:

Maximum number of columns in preview:

×

QUICK HINTS