Open the full cell value
UsefulDockCSV workspace
Files stay on this device简体中文

FROM FILE TO VERIFIED RESULT

Clean a CSV with changes you can review

Trim selected CSV columns and headings or remove fully empty rows. Preview the impact and download a separate CSV or TSV.

Free · No account
or drop files · 10 MB per file

Import settings apply only to files opened next; existing datasets stay unchanged. No-header files receive column_1, column_2, and so on while keeping the first record. Exports include those column names.

Clean

Trim only the headers and columns you select, or remove blank rows.

Interactive example · fictional data

Remove the spaces you choose

Example input · clean.csv
·sku··name·price
00123·Blue·mug·12.50
∅∅∅
00456·Red·cap·8.00

Dots show spaces; ∅ means empty. Swipe tables to see all columns.

Ready to play

This small example does not change your open files.

Or open your own files. Data is processed in this browser.

See the result, then try it

Clean

Interactive example · fictional data

Remove the spaces you choose

Example input · clean.csv
·sku··name·price
00123·Blue·mug·12.50
∅∅∅
00456·Red·cap·8.00

Dots show spaces; ∅ means empty. Swipe tables to see all columns.

Ready to play

This small example does not change your open files.

Rules, limits and questions

Extra spaces and empty rows can interfere with matching and imports. Choose the specific cleanup you intend, inspect its impact, and keep the source untouched so a cosmetic change cannot silently become a data rewrite.

Your result: A new delimited file with only the cleanup rules you explicitly selected.

Steps

  1. Open the cleanup example or your own file and inspect the starting values.
  2. Enable heading trimming, selected-column trimming or fully empty-row removal as needed. Leave identifier columns untouched unless that normalization is intended.
  3. Preview affected rows and remaining warnings. Confirm the result, then choose the output delimiter, BOM and line endings.

Download example CSVs

These files contain fictional data. You can also close help and choose “Try sample files” in the toolbar.

Expected example result

  • Removing fully empty rows changes 4 data records to 3.
  • Trimming the heading and name column changes surrounding spaces, not spaces inside Blue T-shirt.
  • The strings 00123, 00456 and 00789 keep their leading zeros.

Scope and limits

  • Cleanup does not infer missing values or repair malformed quotes by guessing.
  • Trimming can create duplicate headings or keys. Review a blocker before exporting or using the result for matching.

Questions

Are cleanup rules enabled automatically?

No. Content-changing rules begin disabled. The preview describes the rules you selected before you retain the result.

Does removing empty rows also delete rows with one blank cell?

No. A fully empty row has no populated fields. A row with a missing name but a present SKU remains a record to review.

Related tool instructions

Close help and use the workspace tools to continue with your current files. The links below open in a new tab.

Full cell value

Review input record

No files open. Refreshing clears the session.

Session limits: 8 source files, 30 MB combined input and 16 retained datasets. Output is limited to 250,000 rows and 2,000,000 cells.

Data stays in this page's memory. Original files are never overwritten. A download action starts the browser download; confirm the saved file yourself.