Clean and deduplicate Salesforce CSV exports.
Profile accounts, contacts or other exported records, standardise predictable text differences, and review duplicates before any re-import. This tool works with CSV files and does not connect to or write to Salesforce.
1. Choose a CSV to clean
Your file opens directly in the local app. Contents stay in this browser; no account needed.
Up to 20 MiB, 100,000 rows and 500 columns.
- Choose CSV
- Profile and choose cleanup rules
- Review and download a new CSV
Export only the fields you need
Create a Salesforce report or data export with stable record IDs and the fields required for review. Keep the untouched export as your reference and follow your organisation's data-handling policy.
Standardise without changing identity
Trim spaces, normalise text case and convert empty values consistently. Apply each rule to selected columns and check the updated profile before adding a deduplication step.
Use durable duplicate keys
Prefer Salesforce record IDs or approved business identifiers over names alone. Exact selected-key deduplication follows the columns you choose, while fuzzy name matches remain non-destructive suggestions.
Validate before re-import
Export creates a new CSV, not a Salesforce update. Compare row counts, sample records and required fields, then use your governed Salesforce import or merge process if the result is approved.
Frequently asked questions
Will cleaning change records in Salesforce?
No. The tool works with a CSV export and downloads a separate result. Preserve Salesforce record IDs, review required fields and counts, and use your approved import or merge process separately.
Is my CSV uploaded when I clean it locally?
No. Local cleaning processes the CSV in this browser without an account. Temporary Loam mode is a separate option and uploads a copy only after you confirm it in the application.
Which files can I clean?
Local mode accepts one CSV up to 20 MiB, 100,000 rows and 500 columns. Export other formats as CSV first. Download your cleaned result before refreshing or closing the tab.
Does cleaning overwrite my original CSV?
No. Rules change a preview that you can undo or reset. Export downloads a separate cleaned CSV and processes the complete accepted file.