Automate repetitive spreadsheet work in your browser

Automate Excel & CSV data cleanup

Keep only the columns you need, reorder and rename them, transform values, and download a new file ready for work. Sign in to save your transformation rules.

Your source file is not stored on our server.
1

Load a file

Supports CSV, TSV, TXT, XLS, and XLSX files.

3

Output columns

Sign up and purchase Pro to use 잠긴() additional features . Sign up

Drag to reorder columns. Use Add fixed-value column to create a column that does not exist in the source and fill every row with the same value.

순서 출력 Required-value check Source column Output column name Prefix Suffix 고정값 Format cleanup Value mapping Conditional transform Remove column
4

Result preview

Changes are reflected in the preview automatically.

The screen shows up to 30 rows; downloads include the full result.

Will you use the same cleanup rules on another file? Create a free account to save the current column and value settings as a reusable rule.
Sign up free

Combine multiple values into one column

Add source columns and fixed values in the order you want, then choose separators between values.

Values and order

No separator is applied before the first value. From the second value onward, choose no separator, a space, or a custom separator.

Value mapping

When a source value matches exactly, replace it with the specified result.

Selected column Values that do not match remain unchanged.
Source value Replacement value

No mappings yet. Select Add mapping to create a rule.

Conditional transform

If a source-column value matches the condition, set this output column to the specified result.

Selected column Only the first matching rule from the top is applied.
Source column 조건 Compare value Result value

No conditions yet. Select Add condition to create a rule.

Row filter

Keep only rows that match a condition, or exclude matching rows from the result.

Filter rules All filter rules are applied from top to bottom.
Action Source column 조건 Compare value

No filters configured. All source rows will be output.

Merge rows with matching values

Merge rows whose selected key columns all match, and sum the column chosen for each rule.

Grouping rules Choose the grouping and sum columns.
Choose Not used for the sum column to group only by the key column. With multiple key columns, rows merge only when all key values match. Other columns keep the first row's value, and rows with empty key values remain separate.
Feature help

How to use

Example