Activity › Forums › Salesforce® Discussions › What is the difference between Data Import Wizard and Data Loader for importing data in Salesforce?
Tagged: Account, Data Import in Salesforce, Data Import Wizard, Data Loader, Difference, Export Data, Importing Data, Leads in Salesforce, Salesforce Custom Object, Salesforce Records
-
What is the difference between Data Import Wizard and Data Loader for importing data in Salesforce?
Posted by Anjali on August 16, 2018 at 6:02 AMWhat is the difference between Data Import Wizard and Data Loader for importing data in Salesforce?
shariq replied 7 years, 8 months ago 4 Members · 3 Replies -
3 Replies
-
Hi Anjali,
Import Wizard :
Is designed for less-technical users and smaller, simple imports of up to 50,000 records.
Can only import data of Account, Contact, Leads, Solution, and Custom Object.
For more information, go to Help & Training | Importing Data | Using the Import Wizards.
Data Loader :
For complex imports of any size.
Can upload more than 50000 records.
Can import and export data.
Can import data of any object except User.
Thanks.
- [adinserter block='9']
-
Hi
Data Loader:-
1.You can use more than 50,000 records.
2.You can insert, update,upsert,delete,export the data.
3.It can not be ignored the duplicate records.
4.You can not schedule the data.Import wizard:-
1.You can use upto 50,000 records.
2.You can delete the records.
3.It can be ignored the duplicate records.
4. You can schedule the data.Thanks
-
Hi,
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.
Hope this helps.
Log In to reply.