CSV Cleaner & Deduplicator
Validate, tidy and export campaign spreadsheets safely in your browser. Handles quoted fields, commas inside cells, escaped quotes and multiline values.
Clean a CSV file or pasted text
Example uses campaign, source and conversions. Your file stays on this device. Up to 4 MB and 15,000 records.
CSV cleanup for campaign reporting
Campaign exports can contain accidental repeated rows, extra spaces and differences in field counts. This tool checks the CSV structure, keeps headers, removes duplicate data rows if selected, and downloads a cleaned file. It accepts quoted commas, doubled quotes and newlines inside quoted cells.
Spreadsheet applications can interpret imported text beginning with =, +, - or @ as formulas. The default safer export prefixes potentially dangerous cells with an apostrophe. This can intentionally change values; disable it only for a trusted non-spreadsheet workflow.
Important limits
Removing duplicate rows is exact after optional trimming, and may remove legitimately repeated conversions. Always review the preview and keep the original. The tool does not guess column meanings, merge campaigns, interpret metrics, remove personally identifiable information, or reconcile analytics data. It is not a substitute for proper consent, privacy review or measurement QA.
Frequently asked questions
Does my CSV leave the browser?
No. The file is read using browser APIs and parsed on your device. No CSV content is passed to Google Analytics events.
What happens with malformed rows?
Invalid quote syntax and inconsistent row lengths trigger a descriptive error, with no download generated. Correct the source data first.
Need more reliable campaign measurement?
iMELLO works on conversion measurement and campaign optimisation across digital channels.