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:

Removing rows with a selection list

Reference column in A:

Extracting rows by reference columns match

Reference column in A:

Reference column in B:

Merging tables by reference columns difference

Reference column in A:

Reference column in B:

Aligning two tables

Reference column in A:

Reference column in B:

Row order:

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

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 or provider of the software bears no responsibility for any loss or damage that may arise from its use for any purpose.

DATA PRIVACY: All user data input into the apps are processed locally within the browser. No data are ever sent to the molbiotools.com server.

QUICK HINTS

Data input

Paste delimiter-separated values in the "Input A" and "Input B" fields or open csv or tsv files. You can copy-paste data from MS Excel (they are tab-separated when copied to clipboard).
Select proper Delimiter A in the "Reading data" section and press the "Read Data A" button. Do the same for data B.
Check the table in "Table Preview" field. The values should be properly distributed in table cells. If you see all values in the first cell, probably a mistaken delimiter has been set. Correct the delimer choice and click "Read Data A" (or "Read Data B) again. Visual inspection of the input data could provide a clue about the delimiter.

Data export and saving

After the required operation has been done, the data can be saved into a file by pressing the "Save to File" button in the "Output Data" field header. The values will be separated by a delimiter chosen from the dropwdown menu. If needed the data can be saved with quoted values.
The output data can also be copied into system clipboard and pasted in a spreadsheet software e.g. MS Excel. To select all data, click in the Output Data area and press Ctrl+A on the keyboard. Copy data by Ctrl+C and paste them elsewhere with Ctrl+V. MS Excel may require pre-selecting all cells in an empty table to properly distribute the copied data in cells.
The preview table is not editable, nor the data can be copied from it. Its purpose is only the inspection of input data and changes made by the program to the data.