Data & CSV

Clean CSV cell whitespace

Trim cell edges or collapse internal whitespace without changing headings.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Apply to

Column

Whitespace cleanup

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Applies JavaScript Unicode whitespace trimming to all cells or one selected column. Collapse mode also replaces each internal whitespace run, including tabs and line breaks, with one space. Headings are preserved exactly. This deliberately changes selected cell text, so keep an original copy if whitespace is significant.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Apply to

All columns

Whitespace cleanup

Trim leading and trailing whitespace

Example result

Example result
ID	Name	Department	Amount	Date
001	Ada	Design	120	2026-01-05
002	Sam	Writing	80	2026-01-06
003	Jo	Design	150	2026-01-07
004	Lee	Writing		2026-01-08
005	Alex	Design	60	2026-01-09