I'm importing a CSV file with about 2500 contacts from another system, outside of SalesForce. The wizard is matching based on name. So if I import the same spreadsheet again, the data doesn't update, but instead it creates duplicates. The data I am importing has a unique User ID field that is 8 characters long. But after reading for a while online, I found out that External ID field cannot be used for the default Contacts. What is the best way to prevent duplicates when importing bulk data? The imports would happen once a month and this is for non-profit organization, so it has to be free if 3rd party plugins will be needed. Thanks for any ideas!

1 Answer 1


Apex data loader is the best. You can do all the functions using data loader. I guess you are using Enterprise edition with NPSP so data loader will work for you.

  • I read about it and tried it on a test computer. For some reason it does not allow me to login, and I know what my username/password is. Figured maybe I'm not allowed to used that functionality. Mar 27, 2015 at 1:32
  • You need to append your security token after your password. Make sure that your org is a enterprise eddition, to know that place your mouse pointer on the tab for a little while it will show you the edition. Mar 27, 2015 at 1:37
  • So there is no other way? It's kinda of lame to get duplicates if inserting the exact same data. It should be matched the same way by the wizard. I'm sure I can figure out the Data Loader, but that requires installing on your machine and not sure if my non-tech savvy client can handle it after I hand off the system :) Mar 27, 2015 at 2:32
  • Data import wizard is much more complicated then data loader, in data loader you can save the field mapping and reuse it every other time. while in data import wizard u need to map every time we use it. for client a short training session is more than enough i suppose . Mar 27, 2015 at 4:46
  • I had to reset my token and was able to login with Data Loader. I guess it needs the user to install another app, but does what it needs. Thanks! Mar 27, 2015 at 12:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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