Filter rows based on a selection list.

Extract rows with a selection list.

Remove rows based on a list selection.

Align two tables online.

Find tables intersection.

Filter rows based on a list selection.

Extract rows by column values matching between two tables.

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:

info@molbiotools.com


DISCLAIMER: This free software comes without any warranty. The author of the software bears no responsibility for any loss or damage that may arise from its use for any purpose.

×

QUICK HINTS