Until now I was a happy Datloader.io user as it allowed me on a Mac to insert from CSV and have this wonderful auto mapping feature where a Lookup or Master Detail relation can be pointed to an external Id field.

But...I just reached Dataloader.ios limits. No csv files bigger than 50 MB and with more than 40 MB the Dataloader.io reports an App crash.

The only offline dataloader for Mac that is a little bit more enhanced than Lexiloader seems to be Jitterbit's free Dataloader.

But I have a hard time figuring out how to resolve a lookup relationship with external id fields instead. Is that possible? And how?

  • The good old lexi-loader also can upsert with external ids. Such a helpful one Commented Feb 25, 2013 at 16:17

1 Answer 1


When you get to what appears to be the end of the New Upsert Wizard, you will be prompted to "Map & Finish" on a button. Click that, and you'll see a screen where you complete your mapping (see pic below).

Any related objects that have available External Id fields will appear at the top of the right hand list of object fields with a "+" to expand. Expand that to get to your related External Ids.

Mapping to related External Id Fields in Jitterbit

From there drag the field on left to field on right (not tried the other way, but it might work), and you should be set.

  • I love Jitterbit. I've demoed it to people who are shocked that it's free. Commented Feb 26, 2013 at 13:19
  • True. But last I checked the free offering was on a very old API version. Don't know if they have updated it recently.
    – pchittum
    Commented Apr 23, 2015 at 8:28

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .