Can I import data into a picklist field if the values don’t match?

We recommend that you import your data into an existing picklist when that picklist accurately represents your data, even if the exact values don’t match. The import wizards warn you before importing any new picklist values. However, the wizards accept any value for a picklist field, even if the value isn’t predefined. Your administrator can later edit the picklist to include the needed values. Note that import wizards don’t allow you to import more than 100 new picklist or multi-select picklist values for any field during a single import.

Important Salesforce has replaced the individual import wizards for accounts, contacts, and other objects with the Data Import Wizard. Individual import wizards open in small windows, while the Data Import Wizard opens in a full browser with dataimporter.app at the end of the URL. From Setup, enter Data Import Wizard in the Quick Find box, then select Data Import Wizard. The options you see depend on your permissions.