Email list cleanup
A contact list with First Name, Last Name and Email columns (a CRM or newsletter export), before you import or mail it.
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 | First Name | Last Name | Company | |
|---|---|---|---|---|
| 2 | maya | patel | Maya.Patel@Example.com | Brightline Studio |
| 3 (removed) | Maya | Patel | maya.patel@example.com (has spaces at its edges) | Brightline Studio Ltd |
| 4 (removed) | ||||
| 5 (removed) | JONAS | WEBER | Weber Logistics | |
| 6 | Lucía | Gómez | lucia.gomez@example.com | Gómez & Hijos |
| 7 | tom | becker | TOM.BECKER@EXAMPLE.COM (has spaces at its edges) | Becker Bikes |
Result
| Row | First Name | Last Name | Company | |
|---|---|---|---|---|
| 2 | Maya (changed) | Patel (changed) | maya.patel@example.com (changed) | Brightline Studio |
| 6 | Lucía | Gómez | lucia.gomez@example.com | Gómez & Hijos |
| 7 | Tom (changed) | Becker (changed) | tom.becker@example.com (changed) | Becker Bikes |
3 rows × 4 columns after the fixes · was 6 × 4 · 10 cells 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.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Trim spaces in every columnOn the sample: 2 cells changed
- lower-case "Email"On the sample: 2 cells changed
- Title-case "First Name", "Last Name"On the sample: 6 cells changed
- Keep only the rows where "Email" is not blank; the other rows are removedOn the sample: 1 row removed
- Remove duplicates: rows with the same "Email" (ignoring case, ignoring extra spaces, blank keys never match), keeping the first of each groupOn the sample: 1 row removed
Your file needs these columns, spelled exactly: First Name, Last Name, Email. If one is missing or renamed, the workflow tells you which step it breaks and does not run.
Two rows are one contact when their email matches, ignoring capitals and spaces. The desktop template Remove duplicate contacts also matches rows with no email by name and phone; that needs a formula, which the browser does not have, so here rows with no email are removed instead.
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.