Salesforce import error: “Required fields are missing”
Why the Salesforce Data Import Wizard rejects leads or contacts, and how to fill or map the required fields.
The message you see
Required fields are missing: [LastName, Company]Fastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Leads need Last Name and Company; some rows leave them empty.
- Your column is called “Surname” or “Organisation” and wasn't mapped.
- Full names sit in one column instead of First/Last Name.
How to fix it
- 1Rename or map your columns to Last Name and Company.
- 2Split full names into first and last name.
- 3Fill or remove rows where a required field is empty, then check again.
Related guides
HubSpot
HubSpot import error: “Make sure each column with data has a header”
ShopifyShopify CSV import: “Illegal quoting on line …”
Google SheetsPhone numbers turn into dates or lose their leading zero in Sheets/Excel
Still stuck? Ask SheetFix Support