Activity › Forums › Salesforce® Discussions › Difference between Data Import Wizard and Data Loader in Salesforce?
Tagged: Data Import in Salesforce, Data Import Wizard, Data Loader, Data Loader IO, Salesforce Data Loader
-
Difference between Data Import Wizard and Data Loader in Salesforce?
Posted by Shubham on July 25, 2017 at 10:53 AMIf we able to use both ,Then which one we prefer and Why ???
Parul replied 7 years, 8 months ago 4 Members · 3 Replies -
3 Replies
-
Hello Shubham,
Import Wizard:
For simple imports of up to 50000 records.
It supports all custom objects and only few standard objects like Account, Contact, Leads, Solution.
It supports schedule export.
Delete operation is not available.
We cannot export data.
It doesn’t require installation.
While importing, duplicates can be ignored.
Data Loader:For complex imports of any size more than 50000 records.
It supports all standard and custom objects.
It doesn’t support schedule export.
Delete operation is available.
We can export data of all custom & standard objects, and can import all custom & standard objects except User standard object.
It requires installation.
While importing, duplicates cannot be ignored. - [adinserter block='9']
-
Hi,
Import Wizard is designed for less-technical users and smaller, simple imports of up to 50,000 records. It is a step by step process and displays error messages to alert the potential record duplications (“dupes”).
Apex Data Loader is used for complex imports of any size. It doesn’t display error messages to alert the potential problems. This tool includes several features that help in making large data imports easier.
Hope this helps.
-
Import Wizard:
For simple imports of up to 50000 records.
It supports all custom objects and only few standard objects like Account, Contact, Leads, Solution.
It supports schedule export.
Delete operation is not available.
It doesn’t require installation.
While importing, duplicates can be ignored.
Data Loader:For complex imports of any size more than 50000 records.
It supports all standard and custom objects.
It doesn’t support schedule export.
Delete operation is available.
It requires installation.
While importing, duplicates cannot be ignored.Thanks
Log In to reply.