Free Online CSV Cleaner: Fix Messy XYZ Data Files

Apps
All tools
Report
Commas, semicolons, tabs, and stray spacing all normalize to one delimiter. Header lines, notes, and broken rows are filtered when numeric rows only is on, exact duplicates collapse to one, and the result is ready for the contour app or any spreadsheet.

Every dataset arrives messy

Field data never arrives ready: the surveyor used semicolons, the logger used tabs, someone typed notes between rows, and the same point appears three times. The cleaner above takes that reality and returns a tidy file. All delimiters normalize to your choice, lines that are not pure numbers are filtered out, exact duplicates collapse to one, and decimals round to the precision you ask for. The preview shows what survived, the counters show what was removed, and the download is one click.

Messy survey data with mixed delimiters, junk lines, blank rows, and duplicates being cleaned into a tidy five row CSV table
Mixed delimiters, junk lines, and duplicates become a tidy file ready for any tool.

Like every tool here, the cleaning happens in your browser: paste from a spreadsheet or load a file, and nothing is sent anywhere.

Why the counters matter

  • Lines in versus rows out is the honesty check: when a thousand line survey shrinks to eight hundred rows, you want to know before mapping it, not after.
  • The duplicates counter catches double downloads and copy paste accidents, the quiet killers of volume calculations.
  • The column count exposes ragged files early: a row with a missing coordinate produces a column mismatch you can hunt down in the source.
  • Rounding to sensible precision keeps files small and stops false precision from surviving into reports.

Built as the front door

This cleaner exists because the mapping tools next door deserve clean input: run your points through here, then straight into the contour map generator, the earthworks calculator, or any spreadsheet, with the mess left behind.

Related Calculators and Reference