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.comSalesforce 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 centreEach email address must match name@example.com.
Type
Trim spaces in Email and lowercase Email
Salesforce help centreHow 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
Dates must be YYYY-MM-DD or MM/DD/YYYY.
DocTransform fixes this: type
Write Signed as YYYY-MM-DD
Salesforce help centreOr by hand
open Health → Dates written different ways, pick YYYY-MM-DD as the format → Rewrite 2 values
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
Fix it in DocTransform
By hand: 12 stepsDocTransform: 1 sentence
- 1. Upload crm_leads_export.csv into DocTransform.
- 2. Type and press Send. Check the steps it adds; Undo takes them all back.
Trim spaces in Company and Email, lowercase Email, write Signed as YYYY-MM-DD and remove rows with a duplicate Email
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. Download the cleaned file as CSV, ready for Salesforce’s importer.

- Type the change in one sentence, in your own words.
- Wait about 5 seconds while the steps are written. Stop cancels.
- Check each step and how many cells or rows it changes.
- 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
- Open crm_leads_export.csv in Excel.
- In the empty cell E2, type =TRIM(A2) to strip the stray spaces from Company.
- In cell F2, type =LOWER(TRIM(B2)) to trim and lowercase Email.
- Select E2:F2 and double-click the fill handle to fill both formulas down to the last row.
- With the filled cells still selected, press Ctrl+C.
- Click A2, then Home → Paste → Paste Special → Values → OK, so Company and Email hold the cleaned text.
- Select columns E and F, right-click and choose Delete.
- Retype each Signed date Excel left as text, such as 07.03.2026, as 2026-03-07.
- Select the Signed column, press Ctrl+1, choose Custom, type yyyy-mm-dd and click OK.
- Check each email address by eye for a missing @ or domain, and fix it directly in the cell.
- Click any cell in the data, choose Data → Remove Duplicates, tick only Email and click OK to drop the repeat lena@acme.example row.
- 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.
Moving to another system
Free tools for this file
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.