Duplicate and blank cleanup (any file)
Any CSV, TSV or Excel sheet: it names no column, so it runs on every file.
Processed locally in your browser. File contents are not uploaded. No account needed.
Before and after
Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.
Original
| Row | id | name | city | notes | empty |
|---|---|---|---|---|---|
| 2 | 1001 | Brightline Studio (has spaces at its edges) | Portland | renewal due in May | |
| 3 (removed) | 1001 | Brightline Studio | Portland | renewal due in May | |
| 4 (removed) | |||||
| 5 | 1002 | Weber Logistics | Hamburg | prefers email | |
| 6 | 1003 | Gómez & Hijos | Madrid | new account |
Result
| Row | id | name | city | notes |
|---|---|---|---|---|
| 2 | 1001 | Brightline Studio (changed) | Portland | renewal due in May |
| 5 | 1002 | Weber Logistics | Hamburg | prefers email |
| 6 | 1003 | Gómez & Hijos | Madrid | new account |
3 rows × 4 columns after the fixes · was 5 × 5 · 1 cell changed
· marks a space at the start or end of a value. The dots are not in the data; they show spaces you would otherwise not see.
Why
Trailing spaces make “Acme” and “Acme ” different values, so duplicates are not found and lookups and totals miss rows — the commonest complaint about exported files.
What it does
- Trim spaces in every columnOn the sample: 1 cell changed
- Remove empty rowsOn the sample: 1 row removed
- Remove empty columnsOn the sample: 1 column removed
- Remove rows that repeat an earlier row (matching every column), keeping the firstOn the sample: 1 row removed
It names no column, so it runs on any file.
How to use it
Download the workflow
A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).
Open your export
In the Data Workspace, choose your file. It is processed in your browser, not uploaded.
Import, review, run
Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.