Activity Forums Salesforce® Discussions Should we prefer Data Loader over Data Import Wizard and why?

  • Should we prefer Data Loader over Data Import Wizard and why?

    Posted by Manpreet on March 30, 2017 at 12:49 pm

    I heard many sfdc developers saying "use Data Loader instead of Data Import Wizard" why?

    Saurabh replied 7 years ago 3 Members · 2 Replies
  • 2 Replies
  • Suraj

    Member
    March 30, 2017 at 12:56 pm

    Hi Manpreet,

    If you want to import within 50,000 then you can use data import wizard but if your requirement is more than 50,000 go for data loader.

     

  • Saurabh

    Member
    March 30, 2017 at 1:03 pm

    Hi Manpreet,

    You can get solution of your query by going through points given below that differentiate between Import wizard and data loader and by this you will enough knowledge which one we have to use in  the given situation:

    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.

    Hope this may help you:

    Thanks

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos