DocTransform
All import guides

Salesforce won't import your leads file?

Fix the errors Salesforce shows when importing a leads CSV, then import clean every week.

Errors Salesforce shows

Required fields are missing

REQUIRED_FIELD_MISSING:Required fields are missing: [Fieldname__c]:FieldName__c --
Salesforce help centre

Invalid email format

Enter an email address that matches the format myemail@company.com
Salesforce help centre

What Salesforce's importer checks

  • Every field your org marked required must have a value.

    we point out a blank in a column you mark required: open the column ⋯ menu → Edit column… → More options → Required Field, and the Invalid filter over the grid shows each blank

    Salesforce help centre
  • Each email address must match name@example.com.

    Type

    Trim spaces in Email and lowercase Email

    How DocTransform flags it

    we point out an invalid address once you mark the column required (column ⋯ menu → Edit column… → More options → Required Field; the Invalid filter over the grid shows each); clicking the Email column header → Trim spaces, then lowercase, trims spaces and fixes case, but a badly-formed address is yours to fix

    Salesforce help centre
  • Dates must be YYYY-MM-DD or MM/DD/YYYY.

    DocTransform fixes this: type

    Write Signed as YYYY-MM-DD

    Or by hand

    open Health → Dates written different ways, pick YYYY-MM-DD as the format → Rewrite 2 values

    Salesforce help centre
  • Up to 90 fields per record; the file up to 100 MB; each record up to 400 KB; 50,000 records per import.

    Salesforce help centre

Before and after

12,480 leads

crm_leads_export.csv
CompanyEmailSignedCountry
Acme GmbH 1 Lena@ACME.example207.03.20263DE
Acme GmbH4lena@acme.example7 Mar 2026DE
Nord ASole.berg@nord.example2026-03-09NO
Brio Studioanna.rossi@brio.example2026-03-10IT
Kaya Retailjames.kaya@kaya.example2026-03-11GB
Moreau et Filschloe.moreau@moreau.example2026-03-12FR
Delta Logisticstom.bakker@delta.example2026-03-13NL

    Fix it in DocTransform

    By hand: 12 stepsDocTransform: 1 sentence

    1. 1. Upload crm_leads_export.csv into DocTransform.
    2. 2. Type

      Trim spaces in Company and Email, lowercase Email, write Signed as YYYY-MM-DD and remove rows with a duplicate Email

      and press Send. Check the steps it adds; Undo takes them all back.
      Or by hand

      Apply the fixes: select the Company and Email column headers → Trim spaces, then Email → lowercase; on Signed Health → Dates written different ways, YYYY-MM-DD → Rewrite 2 values; Email → Remove duplicates to drop the repeat lead.

    3. 3. Download the cleaned file as CSV, ready for Salesforce’s importer.
    “Trim spaces in Company and Email, lowercase Email, write Signed as YYYY-MM-DD and remove rows with a duplicate Email” typed into DocTransform; five steps applied, one duplicate row removed; Undo shown
    1. Type the change in one sentence, in your own words.
    2. Wait about 5 seconds while the steps are written. Stop cancels.
    3. Check each step and how many cells or rows it changes.
    4. The file is clean. Not what you meant? One Undo takes it all back.

    Save this fix once, then rerun it on next week’s export with one click.

    Fix it by hand in Excel or Sheets

    1. Open crm_leads_export.csv in Excel.
    2. In the empty cell E2, type =TRIM(A2) to strip the stray spaces from Company.
    3. In cell F2, type =LOWER(TRIM(B2)) to trim and lowercase Email.
    4. Select E2:F2 and double-click the fill handle to fill both formulas down to the last row.
    5. With the filled cells still selected, press Ctrl+C.
    6. Click A2, then Home → Paste → Paste Special → Values → OK, so Company and Email hold the cleaned text.
    7. Select columns E and F, right-click and choose Delete.
    8. Retype each Signed date Excel left as text, such as 07.03.2026, as 2026-03-07.
    9. Select the Signed column, press Ctrl+1, choose Custom, type yyyy-mm-dd and click OK.
    10. Check each email address by eye for a missing @ or domain, and fix it directly in the cell.
    11. Click any cell in the data, choose Data → Remove Duplicates, tick only Email and click OK to drop the repeat lena@acme.example row.
    12. Choose File → Save As, pick CSV UTF-8 (Comma delimited) as the file type and click Save.

    Questions

    Does DocTransform split my file if it's over Salesforce's limits?
    Yes, by rows. In Export Studio choose Split into files → By number of rows… and set the most rows each file may hold: you download one .zip and upload the files one at a time. It splits by rows, not by size, so it cannot promise a file stays under a size limit: check each file before you upload it.
    Will DocTransform know which fields Salesforce requires?
    No — DocTransform doesn't know Salesforce's schema. Tell it which fields are required in the Health panel, and it flags the blanks for you.
    Can I reuse this fix next time I export leads?
    Yes — save it once in DocTransform and rerun it on next week’s export.
    Try this sentence free

    Free plan, no card required.

    Salesforce, HubSpot, Shopify, QuickBooks, Mailchimp, Pipedrive, WooCommerce, Klaviyo, Google Contacts, ActiveCampaign, Brevo, Zendesk, Square, Zoho CRM, and Xero are trademarks of their owners. DocTransform is not affiliated with them.