Data import wizard: example

Created by Sjoerd van der van der Heijden, Modified on Tue, 26 Oct, 2021 at 9:15 AM by Sjoerd van der van der Heijden

Transpose

Replace values of Account Owner by IDs

https://help.salesforce.com/articleView?id=000336419&type=1&mode=1

Copy ID from browser:

Michael: 0052p000009MXLK

Hidde-Jan: 0052p000009MXLF

Prepare Excel: find and replace the current names with the user IDs

Start the Data Import Wizard

Select “Investor”

Select the type of file (comma or tab separated). In this example, our CSV file was Tab separated.

Map the fields accordingly

Match Account Owner

The matching looks good when there are no red fields anymore.

We are about to import 6 fields.

This Salesforce Classic screen gives you an overview of the results of the import.

To make sure the contacts that we connected to the accounts become the Main Contact, we need to update the newly added records again. Therefore, we first generate a report with accounts and their account IDs, with which we can later on match in the data import wizard.

Add the field Account ID

Export the report

Work with the index match or Vlookup function to match the corresponding IDs to the accounts.

Match account by Account ID

Match contact by Contact Name

Match the Excel columns to the Venturelytic field names and proceed. You now have successfully updated the fields of Main Contact and Current or Potential LP.