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.
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.