What is the difference between Data Import Wizard and Data Loader for importing data in Salesforce?

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.

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.