CSV Is Still How CRMs Move Bulk Data
Whether you use HubSpot, Salesforce, Pipedrive, Zoho, or a niche CRM, bulk creates and updates usually travel as CSV (or Excel that becomes CSV). Migrations, list uploads, and territory changes all depend on clean rows and honest field maps.
A good CRM CSV is less about clever formulas and more about unique keys, normalized emails, and owners that already exist in the system.
Pick the Object Before You Edit
Do not mix objects in one file unless the CRM’s importer explicitly supports it.
| Object | Typical unique key | Watch outs |
|---|---|---|
| Contacts / People | Personal vs work email; duplicates | |
| Companies / Accounts | Domain or external ID | Name-only matches create dupes |
| Deals / Opportunities | Deal ID or external ID | Pipeline/stage picklists |
| Leads | Email or lead ID | Lifecycle rules on insert |
| Activities | Often not CSV-friendly | Prefer native import tools |
Step-by-Step: Safe CRM Import
A repeatable path that survives reviews.
- Export a small sample from the CRM to capture exact property names.
- Build your sheet to match those headers—not your internal names only.
- Normalize emails (trim, lowercase) and phones to one format.
- Resolve owners to the CRM’s user IDs or emails as required.
- Deduplicate on the business key before upload.
- Save UTF-8 CSV; preview in the Online CSV Editor.
- Import a pilot segment; verify records; then load the rest.
Mapping and Picklists
Free-text status values become rejected rows. Align dropdowns, countries, and lifecycle stages to the CRM’s allowed values. When migrating between CRMs, build an explicit map: old_value → new_value.
Real-World Examples
Ops patterns that work.
Event list upload
Marketing cleans a conference CSV, maps to contact properties, tags the source, and imports after deduping against existing emails.
CRM platform switch
RevOps exports accounts and contacts, maps fields, pilots 100 accounts, then runs the full migration weekend.
Territory reassignment
Account owner column updated in CSV and imported with “update only” so no new duplicates are created.
Common Mistakes
These create messy CRMs for years.
- Importing without a unique key (name-only contacts).
- Creating duplicate companies for every spelling variant.
- Wrong owner emails that leave records unassigned.
- Excel destroying leading zeros on account numbers.
- Updating with a stale export and overwriting newer CRM edits.
Best Practices
Keep the database trustworthy.
- One object per file unless documented otherwise.
- Deduplicate before import.
- Version files (contacts_import_2026-07-25.csv).
- Prefer update-by-ID when refreshing existing records.
- Log row counts and error CSVs from the importer.
Why Use Convert CSV Online?
Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Clean CRM exports, convert Excel lists to UTF-8 CSV, and spot mapping issues before you upload. Client-side workflows work on Windows, macOS, and Linux browsers.
Pilot visually
If emails and owners look wrong in the Online CSV Editor, they will look wrong in the CRM.
Conclusion
CRM CSV imports succeed with clear objects, stable keys, normalized contact fields, and pilot loads. Export the CRM’s own headers, map deliberately, and never skip dedupe.
FAQ
How do I import contacts into a CRM with CSV?
Match the CRM’s property headers, normalize emails, dedupe, save UTF-8 CSV, and run a small pilot import before the full list.
What unique key should I use for CRM CSV?
Email for contacts is common; domain or external ID for companies; CRM record IDs when updating existing rows.
How do I avoid duplicate CRM records?
Deduplicate the file first, then use the importer’s update-vs-create rules keyed on email or ID.
Can I import deals and contacts in one CSV?
Only if your CRM’s importer supports associations in one file. Otherwise import companies/contacts first, then deals.
Should CRM CSV be UTF-8?
Yes. UTF-8 preserves international names and notes across modern CRMs.
How do I clean a CRM export before re-import?
Use the Online CSV Editor to fix headers, blanks, and duplicates, then export a fresh UTF-8 CSV.
References
Convert your CSV in the browser
Preview, clean, and convert CSV files free with Convert CSV Online—no installation and no account required for everyday conversions.