CSV import Error Mandatory field missing for field “XXXX”
leads, estimates, and opportunity CSV files that have a character encoding option of UTF-8 are saved with ANSI encoding. The error is resolved if the special character for example ‘ä’, is removed from the CSV file.
Incorrect file encoding was used when the file was saved for import. When saving the file for import:
- Open the CSV file in Notepad.
- Select File > Save as.
- In the Encoding dropdown list, select UTF-8.
- Click Save.
- Import this file using the Import Assistant.
Mandatory field missing for field “XXXX”
The file might contain extra commas. When you open a CSV file in Excel, extra commas are not visible. However, extra commas are visible when you open the file in Notepad.
Use Notepad or a similar application to open the CSV file and look for extra commas.