Skip to content

Generate a Validated CRM Contact Import CSV Template

Prepare error-free CSV import files for Salesforce, HubSpot, or Pipedrive with standardized ISO country codes, split name fields, UTM attribution, and dedupe keys.

Copy the prompt and paste it into the AI assistant you already use.

Data hygiene checks before running any CRM CSV import

  1. 01

    Anchor deduplication on lowercase email and root domain

    Trim whitespace, lowercase email strings, and strip `https://www.` from company URLs so imports update existing records instead of spawning duplicates.

  2. 02

    Lock country and state columns to exact CRM picklist values

    Standardize `US` vs `United States` and two-letter state codes beforehand—one mismatched string aborts strict Salesforce state/country picklist uploads.

  3. 03

    Format dates strictly in `YYYY-MM-DD` ISO-8601

    Never import regional `04/05/2026` dates that flip April and May across US and European admin locales; ISO-8601 parses cleanly everywhere.

  4. 04

    Preserve explicit opt-in source and timestamp columns

    Log lawful basis, acquisition event name, and consent date on every imported row so marketing automation stays compliant with privacy rules.

How it works in practice

Messy trade-show spreadsheet problems from marketing ops

Importing 1,400 FinTech Summit scans into Salesforce. Raw sheet has single `Full Name` column, mixed countries (`UK`, `Great Britain`, `United Kingdom`), `Phone` missing `+` prefixes, and notes mixed with booth demo requests. Need clean CSV headers + validation rules.

Standardized Salesforce Campaign Member CSV schema

Headers: `email,first_name,last_name,company,website_domain,job_title,country_iso2,state_code,phone_e164,lead_source,campaign_id,booth_intent_tier,gdpr_opt_in_date,rep_notes` Validation Rules: - `country_iso2`: Normalize `UK/Great Britain` -> `GB`; enforce `state_code` only when `US`/`CA`. - `website_domain`: Extract root domain (`stripe.com`) excluding free webmail (`gmail.com` -> blank). - `booth_intent_tier`: Picklist [`Hot - Demo Requested`, `Warm - Scanned`, `Partner/Press`].

Stops dirty event lists from breaking CRM routing workflows or creating thousands of duplicate accounts.

Common questions

Why strip free webmail domains like `gmail.com` from company domain fields?

CRMs like HubSpot auto-associate contacts into one giant company record by domain; leaving `gmail.com` merges hundreds of unrelated buyers together.

Should CSV files be saved as standard CSV or UTF-8 CSV?

Always export as UTF-8 encoded CSV (without BOM issues) so accented European or global names never turn into garbled question-mark characters.

Why test a 5-row sample CSV before uploading 5,000 leads?

Importing five test rows first verifies custom field mappings, owner assignment workflows, and Slack notifications before touching production scale.

Learn more

Related guides and background articles for this task