CleanMySheet guide

Clean CRM contacts from a spreadsheet export

The CRM Cleanup bundle is a named recipe: trim, unify empties, split names, format phones to international form (+91 98765 43210), lowercase emails, then exact dedup. Lock ID columns. Replay next month with a .cleanmysheet.json recipe.

CRM pack will be suggested after scan.

Drop CSV or Excel here

Tap to choose a file. Parsing stays on this device.

Parsing stays on this device. Optional: drop a .cleanmysheet.json recipe with it.

Open the cleaner

Steps

Export contacts from your CRM as CSV/XLSX
Drop the file on CleanMySheet
Apply CRM Cleanup (or search CRM)
Review fuzzy pairs if the scan found near-duplicates
Import the cleaned CSV back

HubSpot, Salesforce, Zoho, Sheets

Any tabular export works. We do not connect live to those APIs in this version; you stay on files, which is safer for Strict mode.

Related guides

Split names in a CSV (Last, First and First Last)
Split Full Name into First Name and Last Name. Handles Last, First and First M Last. Only name columns are touched.
Format phone numbers in CSV or Excel
Normalize phones to +91 98765 43210 international form. Optional US parens/dashed presets stay in the catalog.
Format emails in a spreadsheet (trim + lowercase)
Lowercase and trim email columns, then optionally extract the domain for segmentation. Runs locally.
Remove duplicate rows from a spreadsheet
Delete exact duplicate rows and review fuzzy matches (John Smith vs Jon Smith). CleanMySheet keeps the first row and never auto-deletes near-duplicates.

Clean CRM contacts from a spreadsheet export

Steps

HubSpot, Salesforce, Zoho, Sheets

Related searches this page answers