Clean and deduplicate HubSpot CSV exports.
Prepare exported contacts, companies or deals for careful review. Profile the CSV, standardise selected fields, and inspect duplicates locally without connecting this site to your HubSpot account.
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
Start with a focused export
Export the object and properties needed for the task, including HubSpot record IDs where available. Retain the original file so the cleaned result can always be checked against its source.
Fix predictable formatting differences
Remove unwanted spaces, normalise case and represent empty values consistently. The ordered plan shows exactly which columns and rules produce the current preview.
Review duplicates with stable keys
Use exact rows or approved key columns for deterministic deduplication. Similar company or contact names appear only as suggestions because resemblance alone does not establish identity.
Use a controlled import process
The site downloads a new CSV and never writes to HubSpot. Validate required properties, record counts and associations before using your organisation's governed import or merge workflow.
Frequently asked questions
Will cleaning update my HubSpot contacts or companies?
No. This tool cleans a CSV export and does not connect to or write to HubSpot. Keep stable record IDs and verify required properties and associations before using your governed import process.
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.