First-Class Salesforce Data Loader

Mapping Features

Skyvia allows not only column-to-column mapping but also lookups, constants, and mathematical and string expressions that can save your time when preparing your data to import.

Unlike Apex Data Loader, our online data loader for Salesforce does not require you to provide IDs for parent objects or owners. You can use their names or any other identifying field instead with Skyvia’s lookup mapping function. If a target object has an External Id field, you can use this field too with Skyvia's external ID mapping.

Skyvia's expression mapping allows performing various transformations on data: combining two source columns to a single target field or vice versa, performing mathematical calculations, etc.

Data Relations

When importing several CSV files with related data together, for example, such as Accounts and Contacts, Opportunities and OpportunityLineItems, Skyvia allows you to easily build corresponding relations in target data. For this Skyvia offers the relation mapping that allows you to specify a foreign key relation between the source files. The corresponding target relation is built automatically. You don’t need to import accounts first, then get and add their IDs to the contacts file — Skyvia does all this for you.

You can also use other kinds of mapping to specify the parent IDs — external ID mapping or Lookup. In this case you need to make sure that parent objects are imported before child ones.