Table operations - Table editing tools

A versatile table editing toolbox, which can: remove rows/columns by number, remove rows by content, remove columns by content, remove rows by duplicate values, merge columns, remove/replace/prefix/append values, sort, rearrange, categorize, transpose, fill, condense, repeat... you name it!

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

Want to manipulate 2 tables at the same time? Try our two-table editing tool.

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:
Remove rows by numeric value:
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:
Remove columns by numeric value:
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

Merging columns

Merge columns number:

Concatenation separator:

Place the merged column after:

Merged column header:

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
Replace entire cell contents, not just the match
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 two columns.

from the column number:

into columns by categories listed in the column number:

Adding a column with repeated values

Comma-separated values:
Repeat each value x.

How many times?

Repeat the whole set x.

How many times?

Place the new column after the column number:

Column header:

Additional operations


all empty cells with:
by removing all empty cells
all cells containing:
Match case
Match whole words only
Match entire cell contents
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.

Maximum number of rows in preview:

Maximum number of columns in preview:

REMOVE ROWS BY NUMBER

Enter a single number, numeric range (e.g. 5-12), comma-separated numbers, or a combination thereof (e.g. 1,3-5,7,12,15).

Close

REMOVE COLUMNS BY NUMBER

Enter a single number, numeric range (e.g. 5-12), comma-separated numbers, or a combination thereof (e.g. 1,3-6,8,12,15).

Close

MERGE COLUMNS

Enter a single number, numeric range (e.g. 5-12), comma-separated numbers, or a combination thereof (e.g. 8,3-6,1). The columns don't have to be adjacent to each other and will be merged in the order specified.

Close
×

QUICK HINTS