How To Import or Upload Contacts
Need Help Importing Your Data?
Having trouble uploading your CSV file? If you're experiencing difficulty with the import process, or you'd prefer
someone to handle it for you, just email your file to support@brokerkit.com and our team will take care of it.
What to include in your email:
- Your CSV or Excel file attached (our team can convert Excel files to CSV for you)
- The type of contacts you're importing (leads, team members, etc.)
- Any labels you'd like applied to the imported contacts
- Any special instructions or field mapping notes
- If your organization blocks file attachments or external file sharing, you can send a Google Drive, SharePoint,
OneDrive, or other file link that Brokerkit Support can access. If the link is restricted, grant access to the
support team member.
- Each row should include a matching identifier so Brokerkit can create, update, and de-duplicate contacts. Use an
email address and/or Agent ID/MLS when available. Phone numbers can be imported as contact data, but phone number
alone is not enough to reliably match and de-duplicate contacts during an import.
File Import Limits by Plan: Each Brokerkit plan includes support-assisted file imports per month (excluding data
transformation):
- Starter: 1 file import/month
- Core: 2 file imports/month
- Expansion: 3 file imports/month
- Enterprise: 5 file imports/month
For details on all plan features, see Brokerkit Pricing.
Prefer to do it yourself? Continue reading for self-service import instructions below.
CSV File Format Requirements
⚠️ Important: You must be an Admin user to access Data > Contact Import. Staff and Agent users cannot access the import
page — please ask an Admin user on your account to help you.
Your import file must be a CSV (.csv) file. If your data is in Excel (.xlsx/.xls) or Google Sheets, you need to export
it as CSV before importing.
- File type: .csv (comma-separated values) only — if you have an Excel or Google Sheets file, export it as CSV first
- Encoding: UTF-8 encoding recommended (avoid UTF-16, ISO-8859-1, or Windows-1252, which can cause silent import
failures)
- First row must be column headers — these are the field names Brokerkit maps to contact fields
- Use the official CSV template for each importer — download it from inside the importer screen before adding your
data. Required column headers vary by importer (Leads, Team Members, BrokerMetrics, MarketView Broker)
- Required fields: at minimum, each row needs an identifier — typically Office Email (or Personal Email) and/or Agent
ID so Brokerkit can match and de-duplicate contacts
- Optional fields: First Name, Last Name, License Number, License Expiration Date, Office Phone, Cell Phone, Current
Company, Office Address/City/State/Zip, Owner, Birthday, Joined On, Anniversary, Production fields, Notes, Labels
(see full field list further down this article)
- Date fields (Birthday, Joined On, Anniversary, License Expiration Date) accept MM/DD/YYYY or YYYY-MM-DD formats
- Phone numbers accept any format — Brokerkit will normalize them
- Important: Phone numbers can be imported and normalized, but they are not the primary matching identifier for
imports. Rows with only a phone number and no email or Agent ID/MLS may be skipped or require manual review because
Brokerkit needs a stable identifier to avoid duplicates.
- Labels column accepts comma-separated values (e.g. 2025-import,top-producer)
- No blank header rows or merged cells — these will cause the importer to skip rows
How to convert Excel or Google Sheets to CSV:
- Excel: File → Save As → choose CSV (Comma delimited) (.csv)
- Google Sheets: File → Download → Comma Separated Values (.csv)
- Apple Numbers: File → Export To → CSV
For detailed format requirements and common conversion issues, see Supported File Formats for Contact Import.
CSV example (Leads importer):
First Name,Last Name,Office Email,Cell Phone,Current Company,Labels Jane,Smith,jane@example.com,555-123-4567,Acme
Realty,2025-import
If your file has columns Brokerkit doesn't recognize, the importer will let you map them during the upload step or skip
them.
Demonstration of Importing contacts with one of our file importers
- See the video below for a demonstration of how to import or upload a list of contacts:
Note: We also have our Relitix integration for importing MLS agent data as recruiting leads and your agent roster into
retention. Please have a look here for details.
When importing data from an MLS, you have multiple options available to you. You can utilize the Relitix integration or explore the file import functionalities within Brokerkit, specifically for BrokerMetrics or MarketView Broker.
Follow these steps to import or upload your list of contacts with a File importer:
⚠️ Note that this option is only available for Admin users, if you are not one, please contact an Admin user to help you
out.
1. Select "Data" using the menu on the left side of your home page.
2. Select "Contact Import"
3. There are 4 importers:
1. Leads Importer
- Make sure to download the CSV template.
- This tool imports data from external documents using our leads import template. It allows you to upload
multiples leads into the Recruiting module in Brokerkit or it matches/updates agents in Retention based on
the same email or agent ID/MLS.
- It is designed to import data from external sources that are not BrokerMetrics, MarketView Broker or
Relitix. Examples include lists of newly licensed real estate agents, real estate school attendees, event
participants, and other similar records.
2. Team Members:
- Make sure to download the CSV template.
- This importer will import your agent roster as agents in the Retention module using our team member template
or match/update recruiting leads with the same email or agent ID/MLS.
- You can also export your team roster to CSV, make changes (e.g. add birthdays), and re-import it to make
bulk changes. You can delete the column you don't want to update before re-importing that list.
- For any of your agents who ended up in retention because they matched on an email or agent ID/MLS there,
move their status to Signed, and they will be shifted to retention.
3. BrokerMetrics
- This importer will import your CSV exports from BrokerMetrics as leads or match/update agents in retention
with the same email or agent ID/MLS.
- You can go here for step-by-step instructions on how to import from BrokerMetrics.
4. MarketView Broker
- This importer will import your CSV exports from MarketView Broker as leads or match/update agents in
retention with the same email or agent ID/MLS.
- You can go here for step-by-step instructions on how to import from MarketView Broker.
4. Follow the prompts and read the notes on the screen.
5. Be sure to use Labels so that you can easily find the contacts you have just imported later. You can do this by
filling out the option "Comma Separated Labels to add to leads" during the import process.
6. You can click on Continue to proceed.
7. Click on Start Importing Data once a file is selected.
8. To verify the accuracy of your import, you will receive an email detailing the number of rows that were successfully
imported as well as those that were skipped. For any skipped rows, a downloadable CSV file will be included,
providing you with the details of the skipped entries along with an explanation in the "Error" column.
9. Scan for duplicates and merge them by following the directions here.
Please ensure that the import settings are enabled to receive an email notification after completing your import in
Brokerkit.
Troubleshooting: Not Receiving the Import Notification Email?
After completing an import, Brokerkit sends you an email with the results of your import (how many rows were imported,
skipped, etc.). If you are not receiving this email, here are the most common causes:
1. You may be on our email suppression list. If you previously clicked an "unsubscribe" link on one of our internal
notification emails, your email address was added to a suppression list. This prevents you from receiving all
notification emails from Brokerkit, including import results, export downloads, and other system notifications.
2. Check your spam/junk folder. The email comes from noreply@u.getbrokerkit.com with the subject "[Brokerkit] Imported
data." It may have been filtered to spam.
3. Verify your import notification settings are enabled. See the screenshot above to confirm the setting is turned on.
If you believe you are on the suppression list, please contact our support team at support@brokerkit.com and we will
check your email address and remove it from the suppression list so you can receive notifications again.
File Size Limits
BrokerKit enforces a maximum upload size of 10 MB for import files. For the best experience, keep your import file under
1 MB. Files larger than 5 MB may be slow or fail to import and should be split into smaller files before uploading.
Tips for reducing file size:
- Remove unnecessary columns before importing
- Split large files into multiple smaller imports (use Labels to track which batch each file belongs to)
- Save or export as CSV before uploading
Things to note:
- How does the import handle Duplicated Contacts?
- The file importer prevents duplicates by matching both the agent_id and email. If a contact with the same values
already exists, it will not be imported again.
- How can I find the contacts that I have just imported?
- To find the data you imported, if you have used Labels, go to the Advanced filters section, look for the field
"Labels", and search for the label you used. Also, at the bottom of the page, ensure you have selected the
correct option:
- - All: To see all contacts
- My + unassigned: To see your contacts and the contacts without an owner
- My: To see only your contacts.
- Archiving agents
- For agents you feel are not fit, archive them rather than delete them, as this will prevent them from being
added back on the next import. It will just match and update them, and they will start in the archive.
- Bulk updating Custom Contact Status on Contacts
- To perform a bulk update of contact statuses, please navigate to the Data page, where you can download the CSV
file from the leads importer. Once you have the file, enter the email and name alongside the custom or default
status you wish to update. After completing these entries, import the file, and the listed contacts' statuses
will be updated accordingly.
- Please be aware that only contacts categorized under recruiting within the lead importer can have their statuses
updated. It is important to note that the status names are case-sensitive. For instance, if your custom status
is labeled "LEADS" and you input it as "leads" in the CSV file, the status will not be updated. Therefore,
ensure that the status names match exactly.
- How to bulk change contact's information?
- You can bulk upload or update contact information like notes, emails, office information, etc. using the Leads
Importer or Team Members Importer. To do this, first download the CSV template and use either the Agent ID or
Office Email field to identify the contact whose information you want to update.
The CSV template allows you to upload a wide range of details. Here are some examples of the fields you will
find:
- First Name
- Last Name
- Agent ID
- License Number
- License Expiration Date
- Office Email
- Personal Email
- Other Email
- Office Phone
- Cell Phone
- Other Phone
- Current Company
- Office ID
- Office Address
- Office City
- Office State
- Office Zip
- Office County
- Home Address
- Home City
- Home State
- Home Zip
- Owner
- Birthday
- Joined On
- Anniversary
- Total $ Production LTM
- Total # Production LTM
- Production Label
- $ Change
- % Change
- Notes
- Sticky Notes
- Labels
- Important: How Email Updates Work
When you import a CSV with a new email address for an existing contact:
- The new email is ADDED to the contact (not replaced)
- The original email remains as the PRIMARY email
- The contact will now have multiple email addresses on file
To replace a wrong email address:
After importing the new email address, you must manually set it as primary:
- Open the contact's profile
- Go to Personal Details section
- Click on the new email address
- Select "Set as Primary" or remove the old email address
- Opted In Status in Contact's Personal Details
- The Opted-In selector in a contact's profile indicates whether they have given consent to be contacted at the
phone number they provided. This is automatically selected for contacts who submit their information through
your landing page and explicitly agree to receive communications. If the Opted-In status is not selected, it is
likely because the contact was added through one of the four file import methods mentioned above.
Additionally, if a contact provides consent through other methods-such as a phone call, text, in-person
conversation, or another platform-you can manually update or change their Opted-In status. To do this, go to the
contact's Personal Details section and check the box.
📩 Note: This Opted In setting does not prevent you from contacting the individual. It serves as a reference for
compliance with text messaging regulations.
Troubleshooting Failed Imports
If your import failed or skipped rows, work through these steps:
1. Check the Import Result Email
After every import, BrokerKit sends an email (from noreply@u.getbrokerkit.com, subject "[Brokerkit] Import results")
with:
- Total rows processed
- Number of contacts added / updated
- Number of rows skipped and the reason for each
Open the email first — it usually tells you exactly what went wrong.
2. Common Reasons Rows Get Skipped
| Reason | What to do | |---|---| | Missing First Name or Last Name | These fields are required. Go back to your CSV and
fill them in. | | Missing or invalid Email | Every row needs at least one email. Check for typos, missing @, stray
spaces. | | Duplicate email | A contact with this email already exists. BrokerKit will update them (not skip) unless
your import is set to "skip duplicates". See [How to avoid creating duplicates while importing data]. | | Invalid phone
format | US cell phones should be 10 digits. BrokerKit strips formatting, but garbled entries like cell: (555)... won't
parse. | | Required field mapping missed | During the import wizard, make sure First Name, Last Name, and Email columns
are mapped to the right CSV columns. | | Empty rows | Trailing blank rows at the bottom of a CSV are silently skipped —
not a problem. | | Bad encoding / special characters | Save your CSV as UTF-8. Other encodings can corrupt accented
characters and cause skipped rows. |
3. Fix Errors and Re-Upload
1. Open your CSV in Excel / Google Sheets / Numbers.
2. Filter to the rows the import email flagged.
3. Correct the specific issues (missing names, invalid emails, etc.).
4. Re-export as CSV.
5. Re-run the import — BrokerKit will skip rows it already imported (by email) and add the newly-corrected rows.
4. Import Silently Finished With Zero Changes
If the import finished with no contacts added or updated, the most common causes are:
- Wrong column mapping — the wizard defaulted to wrong fields. Re-run and check each field mapping carefully.
- Wrong importer selected — if you're importing from BrokerMetrics, use the BrokerMetrics importer. For MarketView
Broker, use the MarketView Broker importer. For recruiting leads or other external lists use the Leads importer, and
for your agent roster use the Team Members importer. Using the wrong importer can result in zero rows matched.
- All rows missing required identifiers — every row in your file needs at least an email address or Agent ID/MLS to
match contacts. Check that these columns are populated for each row.
- CSV file was empty except for headers.
- File encoding issues — non-UTF-8 file encoding (such as UTF-16, ISO-8859-1, or Windows-1252) can cause the importer
to fail silently with zero rows processed. Save your file as UTF-8 CSV before importing.
5. Still Stuck? We Can Help
Import troubleshooting can be tricky — but we're here for you. Our team can import your file for you or help you figure
out exactly what went wrong.
Send us your file and we'll do it. Email your CSV or Excel file to support@brokerkit.com along with a brief note about
what you're trying to accomplish. The support team can:
- Import the file for you
- Investigate exactly which rows and fields caused errors
- Walk you through the fix if you'd prefer to handle it yourself
Need help right now? Chat with our support team and a real person can help with your import.
See also:
- [How to avoid creating duplicates while importing data]
- [Importing and Updating Contacts from REality]
- [Updating and Merging Data Into Your Retention Roster]