Survey CSV Cleaner
Tidies survey coordinate CSVs locally by removing whitespace, blank rows and duplicate point numbers.
Paste your CSV
The delimiter is detected automatically. Runs in your browser — nothing is uploaded.
Cleaned CSV
Paste some CSV to clean it.
Before you rely on this: First-pass guide only. Verify safety-critical or regulated work against the relevant standards, your project requirements and a qualified professional.
How to use this calculator
- Paste your coordinate CSV into the box (the delimiter is detected automatically).
- Tick the cleaning options you want — trim spaces, remove blank rows, drop duplicates.
- Read the before/after counts, then copy or download the cleaned CSV.
How it works
The cleaner parses your text locally, normalises every cell, removes blank and duplicate rows, and re-emits tidy comma-separated values ready for import.
‘Keep first of each point number’ removes rows whose first column repeats — handy when the same point was exported twice. Quoting is added only where a cell contains a comma or quote.
Worked example
Messy export. Pasting rows with extra spaces, a blank line and one repeated row returns a clean two-line CSV: the blank and the duplicate are dropped and every value is trimmed.
Frequently asked questions
Is my data uploaded?
No. All parsing happens in your browser — the file never leaves your device, and nothing is stored on a server.
Will it reorder or change my numbers?
No. It only trims whitespace and removes blank/duplicate rows; the values and their order are preserved. Check the row counts to confirm what was removed.
Is this official course material?
No. It is free study support mapped to surveying course levels — not official North Metropolitan TAFE content or advice. Always follow your lecturer and the official assessment brief, and check your own working.
Related tools
- Point List Duplicate and Gap Checker
- Coordinate Import Template Generator
- CSV to JSON Converter
- Point List Renumber Tool
- Coordinate CSV Schema Builder
- Point Code Parser
Explore more in Surveying, Coordinates, GIS & CAD.
Cite this tool
Zerdly. (2026). Survey CSV Cleaner. Retrieved from https://www.zerdly.com/tools/survey-csv-cleaner/
Tip: Enter any known values to calculate the remaining results.
All calculations run in your browser. Your inputs are never saved or transmitted.