Help Center
help.berchtold.ai/en/contacts/import-and-export
Browse topics

Contacts & relationships

Import, export and clean up contacts

Import contacts from a CSV or JSON file, a photo or a PDF. Export them, also in the RESO format, merge duplicates, change many at once and fix bad values.

Workspace settingAvailability is controlled by your workspace. Ask your administrator about access.

Before you import

Berchtold tells contacts apart by email. A new contact must have an email address. When an imported email matches a contact, the import updates that contact. It does not make a second contact.

Make the tags and custom fields before you import. An import can't make them. To import, your role needs Bulk changes in the CRM.

Import a CSV or JSON file

Open the import

Open Contacts. In More actions, select Import contacts….

Choose the file

Choose a CSV or JSON file. The file can be 20 MB or less, with up to 5,000 contacts.

Map the columns

For each column, choose a field or Skip column. Berchtold matches a column for you when its header is the same as a field's key. Match the email column to Email. You can also match the columns that hold each contact's number in your old CRM.

Check the preview and import

The preview shows the first five rows. Select Import mapped contacts.

You can close the window after the file uploads. The import keeps going. Its results are in More actions → View import history. Select Download row report to see what happened to each row.

What the import does:

  • A row whose email, or number from your old CRM, matches a contact updates that contact.
  • A blank cell in a matched column clears that field.
  • Tags are added to the contact's tags. They do not replace them. Separate tags with semicolons.
  • Unsubscribes and list history stay as they are.
  • A row without an email can't make a new contact. The row report lists it as an error.

An import never sends email and never starts an automation.

Import contacts from a photo or a PDF

Use this for a sign-in sheet from an open house, a printed list or a business card.

  1. Open Contacts. In More actions, select Import from Image.
  2. Select Upload picture or PDF. On a phone, you can select Take a picture. Add up to 10 files: JPG, PNG, HEIC or PDF, each 10 MB or less. Then select Read contacts.
  3. Each contact that Berchtold finds shows in a table with its status. Select Edit to correct the details. Clear Include for a contact that you do not want. Show Needs review to see only the contacts with unclear or missing details. Each contact needs an email.
  4. Select the import button, for example Import 12 contacts. Results shows how many contacts were added, skipped or not added. Select Try the failed contacts again to try the ones that were not added.

This import only makes new contacts. When an email is already in the CRM, that contact is skipped. It does not change. Importing does not send email or subscribe anyone to a list.

Export contacts

Open Contacts. In More actions, select Export contacts…. Choose:

  • Contacts to export: the selected contacts, the current search or segment, or all contacts.
  • Status: active, archived or both.
  • File format: CSV, JSON or RESO Common Format (RCF).

Select Download export. You need the Export permission in CRM.

Export in the RESO format

RESO is the real estate data standard. Other real estate software can read a file in the RESO Common Format. The file follows RESO Data Dictionary 2.0.

With RESO Common Format (RCF), choose What to export:

  • Contacts: the contacts you choose, as above.
  • Properties and your listings, with their photos. Property photos gives the photos on their own.
  • Members, Offices, Team and Team members: your workspace's people and offices. A brokerage workspace has no team.
  • Saved searches and Saved homes: what your contacts saved on your websites.

The file never has MLS listings or personal data. A home from the MLS shows only its address or its MLS number. You get only what you have permission to open.

Anything that does not meet the RESO standard is left out. The window says how many were left out. Add their missing details, such as a city or ZIP code, then export again.

Find and merge duplicate contacts

Two contacts can be one person. For example, a client can have a work email on one contact and a personal email on the other.

Find possible duplicates

Berchtold compares your contacts and lists the pairs that may be one person. Open Contacts > Possible duplicates. Each pair shows why it is listed:

  • Same email: the two contacts share an email. Other emails count too. A Gmail address with dots or a +tag counts as the same address.
  • Same phone: the two contacts have the same phone number.
  • Same name at an address: the same last name at one address. The first names can be one person's, such as Pat and Patricia.
  • Same name: the same first and last name.

Two contacts with different first names are never listed, so a couple at one address is not a pair. A contact's page also says when it may be the same person as another contact.

If the two contacts are different people, select Not the same person. The pair is no longer listed for anyone in the workspace. To show it again, select Undo.

Merge two contacts

Start a merge in one of these ways:

  • On Possible duplicates or on a contact's page, select Review.
  • On a contact's page, open More actions and select Merge with another contact…. Then find the other contact.
  • On the Contacts list, select two contacts. In Bulk actions, select Merge these 2 contacts….

The merge window shows the two contacts side by side:

  1. Berchtold chooses the contact that stays. It is the one on more deals. If they tie, it is the one with more history, then the one added first. To keep the other one, select Keep … instead.
  2. Each value that is different has its own row. Select the value to keep. A filled value is selected before an empty one. A name and an address are kept whole.
  3. Check the deals. Each deal says if it stays, moves to the contact that stays, or is on both. If two deals look like the same sale, a warning shows. The merge keeps both deals, so open them and check.
  4. Select Merge.

The contact that stays keeps the deals, accounts, tags, notes, tasks and history of both contacts. The other email stays as another email. A contact has one phone number, so the other number is not kept. An unsubscribe on either contact stays. The other contact is removed. You cannot undo a merge.

To merge, your role needs Edit and Delete in the CRM. Claude, ChatGPT and Muse can do the same. They find possible duplicates and show the merge. They merge only after you confirm.

Change many contacts at once

Select contacts on the Contacts list. To select every contact that matches your search, select Select all. Then open Bulk actions:

  • Add tag… and Remove tag…
  • Assign owner…
  • Update custom field…. A blank value clears the field.
  • Subscribe to a list…. Say how the people agreed. Your workspace needs Email turned on.
  • Archive… and Restore…

Select the apply button, for example Apply to 40 contacts. Select Download bulk report to see the result for each contact.

Fix bad values after an import

Open Contacts → Needs updates. Set Issue type to Imported values or Contact details. The page lists:

  • values from an import that did not match a field;
  • main email addresses that are not valid;
  • missing names, and contacts with no email or phone;
  • values in the wrong format, for example a phone number or a postal code.

Select Review on an issue. Then save a correction or archive the old value. You can also keep the value as it is and select Mark reviewed. Review history shows past decisions. See Keep contacts and deals up to date.

A contact with import values to review shows a link to Review in Needs updates.

Updated November 11, 2026

Import, export and clean up contacts · Berchtold Help