Table Operations allow the user to modify tabular data by removing rows or columns.

Rearange table by moving columns under each other. Create R-ready data.

HTML Table Generator.

Your browser does not support SVGs

Table Operations

molbiotools.com

quick hints useful linx send feedback user guide
Display quick hints Useful links Send feedback! User guide

Input Data

Output Data
Delimiter: Quoted values
Table Preview HTML code

ACTIONS

Reading data (necessary)

Delimiter:

First row is a header Convert decimal commas to decimal points

Removing rows by number

Remove row number:

Remove every -th row
Start with -th row Optional
Stop before -th row Optional

Removing columns by number

Remove column number:

Remove every -th column
Start with -th column Optional
Stop before -th column Optional

Removing rows by content

Remove rows containing:
Remove rows NOT containing:
In any column
In the column number:
Match case
Match whole words only
Match entire cell contents
Interpret as a regular expression

Removing columns by content

Remove columns containing:
Remove columns NOT containing:
In any row
In the row number:
Match case
Match whole words only
Match entire cell contents
Interpret as a regular expression

Removing rows by duplicate values


By values in the column number:
Only identical rows
Match case
Keep the first one
Keep the last one
Remove all

Removing, replacing, prefixing and appending values

In the row number:

Leave empty for all.

In the column number:

Leave empty for all.

Find:
First characters (number of)

Leave empty to prefix values.


Last characters (number of)

Leave empty to append values.


This value:
Match case
Match whole words only
Match entire cell contents
Interpret as a regular expression
with:

Leave empty for removal.

Sorting table

by values in the column number:
In alphabetical order
By numerical values (decimal separator must be dot)

Rearranging table by moving columns under each other

after every-th column

Apply (count) from the column number:


Copy values from the first columns alongside cells (before)
Copy column header values alongside cells (after)

Sorting values into columns by categories

Inverse operation of the above. All values are initially in one column.

from the column number:

into columns by categories listed in the column number:

Additional operations


all empty cells with:
all cells containing:
Match case
Interpret as a regular expression
all non-empty cells

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. Click "Update Preview" to apply changes.

Maximum number of rows in preview:

Maximum number of columns in preview:

Your browser does not support SVGs


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