Salesforce Administrator Exam
Learning for the Admin Exam: Data Import Wizard vs Data Loader
One important part of the Salesforce Administrator Exam is to distinguish between Data Import Wizard and Data Loader to upload, download or update your data. I have created a table with the important differences:
| Requirement | Data Import Wizard | Data Loader |
|---|---|---|
| available for | User / Admin | Admin only |
| User Interface | Salesforce Setup | Setup or command line |
| Import / Export | Import / Update / find duplicates | Import / Export / download / Update / Delete |
| Schedule | no schedule | schedule Data loads |
| Limit | 50.000 records | 5 Mio records |
| Validation Rules | will fire | will fire |
| Workflow Rules | can be switched off | will fire |
| data format | .csv | .csv |
| Import | Accounts, Contacts, Leads, Solutions, Custom Objects (no Opportunities, no Cases) | supports all objects & attachments |
| Duplicates | choose fields to update or create records or both / finds duplicates | needs ID, does not find duplicates |
