We are getting 'Cannot specify both an external ID reference Owner and a salesforce id, OwnerId' error while upserting account record. Any idea?

  • Remove one or the other from the imported file. What is it specifically that you are having trouble with?
    – Eric
    Jan 4, 2017 at 6:44
  • If possible please add a screenshot of your csv file, with the relevant columns only. Most probably you are specifying Owner & OwnerId both in the file. Jan 4, 2017 at 6:45

1 Answer 1


I believe this is as simple as the error message is giving you. You cannot specify an External ID field and the Salesforce ID in Updates or Upserts from Dataloader - because imagine if in your data the Salesforce ID referenced one record, but the External ID actually was on a different record; which one would it upsert? It would have no choice but to blow up.

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