OfficeOnceClean up a pasted table
Clean spaces, duplicates and columns in CSV, TSV or XLSX, then export CSV or TSV.
Input example
Name Team Extension
Alex Kim Planning 101
Jamie Lee Sales 102
Jamie Lee Sales 102Result example
| Name | Team | Extension |
|---|---|---|
| Alex Kim | Planning | 101 |
| Jamie Lee | Sales | 102 |
How to use
How it works
- Paste a table or choose CSV, TSV or XLSX; check the sheet and encoding.
- Preview column selection, duplicate keys, splitting and joining.
- Save or copy CSV/TSV in UTF-8 or UTF-16.
Supported formats
- TSV
- CSV
- XLSX
Good to know
- Up to 5MiB, 10,000 rows and 100 columns. Select among up to 20 XLSX sheets. Postal-code leading zeros are retained.
- Existing XLSX cell values are imported; formulas and macros are not executed. Formula-like exported cells are protected as text.
- Files and inputs are not sent to a server. Optional autosave keeps originals, work and results in this browser for 30 days; you can disable or delete them.
Loading the tool. Turn on JavaScript to use the workspace.