Over time, I have come across three data loaders for Salesforce...

  • Apex Data Loader,
  • Jitterbit Data Loader, and
  • dataloader.io

to name a few.

  1. Are there any more data loaders for Salesforce?
  2. Which is your favourite data loader and why?
  3. If you had the choice of mastering only one data loader, which one would you prefer to master, and why?

Your question is pretty general and will probably get closed because of that.

For what purpose would you be choosing a data loader? The simple Import Wizard works fine for many situations.

I would recommend using the right tool for the specific job which might be a different tool depending on the situation. Don't choose the tool before the job. See Which Data Import/Export Tool Should I Use? for some general information.



Jitter bit dataloader seems more powerful among all.The reviews are great on appexchange .This tool can also be used to automate the data migration process from legacy system .The bulk API is used behind this tool and hence looks good choice since we have flexibility of changing the Batch Sizes.


I personally use the Excel Connector far more often (I'm Admin/Low Level Developer - I would personally NOT TRUST average users to use the Connector). Otherwise, I just use DataLoader. The ability to instantly both query AND update data from and to SF is just too awesome.


Edit (to answer your third question):

Excel Connector is worth mastering. You can do FAR MORE with it in my opinion since, quite simply, it's Excel and VBA and whatever you can dream up. I am NOT proficient in the .io or the other product. I can't imagine them having the extensibility of Excel, though.

Not the answer you're looking for? Browse other questions tagged or ask your own question.