[All import guides](/en/import)

# 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](https://help.salesforce.com/s/articleView?id=xcloud.essentials_data_import_fix_errors.htm&type=5)

### Invalid email format

> Enter an email address that matches the format myemail@company.com

[Salesforce help centre](https://help.salesforce.com/s/articleView?id=xcloud.essentials_data_import_fix_errors.htm&type=5)

## 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](https://help.salesforce.com/s/articleView?id=xcloud.essentials_data_import_fix_errors.htm&type=5)
*   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](https://help.salesforce.com/s/articleView?id=xcloud.essentials_data_import_fix_errors.htm&type=5)
*   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](https://help.salesforce.com/s/articleView?id=000390017&type=1)
*   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](https://help.salesforce.com/s/articleView?id=xcloud.import_limits.htm&type=5)

## Before and after

12,480 leads

crm\_leads\_export.csv

BeforeAfter

Company Email Signed Country

Acme GmbH 1 Lena@ACME.example2 07.03.20263 DE

Acme GmbH4 lena@acme.example 7 Mar 2026 DE

Nord AS ole.berg@nord.example 2026-03-09 NO

Brio Studio anna.rossi@brio.example 2026-03-10 IT

Kaya Retail james.kaya@kaya.example 2026-03-11 GB

Moreau et Fils chloe.moreau@moreau.example 2026-03-12 FR

Delta Logistics tom.bakker@delta.example 2026-03-13 NL

Before

## 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](/guide-shots/salesforce/en/flow-desktop-poster.webp)

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.

## Moving to another system

*   [Salesforce to HubSpot: map the columns, import the CSV](/en/import/hubspot/from-salesforce)

## Free tools for this file

*   [Change the date format in Excel or CSV](/en/tools/change-date-format)

[Try this sentence free](/en/signup?plan=free&guide=salesforce)

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.
