Replace values of Account Owner by IDs
Copy ID from browser:
Prepare Excel: find and replace the current names with the user IDs
Start the Data Import Wizard
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.