Need a hand? We've got you covered.

Frequently Asked Questions aero-right Fields Importing Data: from a file Records aero-right How do I update my existing CRM Organization records using a CSV or XLS?

How do I update my existing CRM Organization records using a CSV or XLS?

Fields Importing Data: from a file Records Updated on October 7, 2019

At some point, you may want to update your Benchmark CRM Organization records. This process will identify new organization records with matching names. When a match is found, the fields that are mapped will overwrite the existing organization records

Follow the steps below to import organizations using CSV/XLS:

  1. Log into your Benchmark CRM account.
  2. From the left navigation, select Organizations.
  3. On the Organizations page, click on the Import button.

  4. Choose the Import Organizations option.
  5. To complete, fill out the Advanced Settings. 

    Important to Note

    • On the In case of duplicate records option, select Overwrite.

    By default, the Character encoding should be set as UTF-8 (unicode).


  6. Click Save & Next.
  7. Map the fields of your CSV/XLS file to match the existing organization fields. The CRM fields are located on the left and the drop-down options that appear on the right side, are the titles of the imported CSV/XLS file.

  8. Now click Next.
  9. The CRM will notify you if there are any unmapped fields. Once you are done checking the fields, click Confirm


Verify when your organization update is complete:


  1. Once logged in your Benchmark CRM account, click on the User Menu icon.
  2. Select Settings.
  3. Locate the Data Administration box and choose Import History from the available options.
  4. Look for the file you’ve imported on the previous steps.


Note: You can reverse (rollback) any listed CSV import for up to 30 days, at which point it will automatically be confirmed. Manually confirming an import before the 30 day period prevents anyone from manually rolling back the import.
If you have additional questions regarding your Benchmark CRM account, please feel free to contact our support team via Email.

Did this answer your questions?
0 0

Can't find what you're looking for?

Send us an Email