Import Builder/Guides/Wise Agent import errors
Real estate

Wise Agent Import Errors and How to Fix Them

Wise Agent imports contacts from a CSV file and checks every column heading before it loads anything. These are the problems that leave headings unmatched, duplicate contacts, scramble dates and lists, or lose a do-not-contact flag, and how to fix each one.

Wise Agent's import rules

Column headings Wise Agent accepts, shown by a green check
A file name without spaces or symbols
An import method chosen on purpose: insert new, update existing or allow duplicates
Several values in one cell separated by semicolons
Dates month first, as in Wise Agent's example
One phone number or email per column

Where the file goes

Open Contacts, then Import, and upload the file. The same page has a link to Wise Agent's example file. After the upload you check each heading's status, choose how existing contacts are handled, and decide whether to format names and addresses, assign the contacts to a team member, and set one category and source for all of them.

Common errors and their fixes

Column headings show a red X

Cause: After you upload, Wise Agent marks every heading with a status. A green check means it accepts the heading. A red X means the heading isn't one of its own, which is common in a file exported from another CRM.

Fix: Rename the columns to Wise Agent's headings before you upload, or map each red-X column to a field with the dropdown under Accepted Columns. Its example file lists the accepted headings.

The upload fails because of the file name

Cause: Wise Agent's help says the name of the imported file can't contain symbols or spaces.

Fix: Rename the file to something like agent-contacts.csv before you upload it.

The same contacts appear twice

Cause: Wise Agent has three import methods. Allow Duplicates adds every contact in the file, even if it already exists.

Fix: Use Insert New/Update Existing to add new contacts and update the ones you already have, or Only Insert New if you don't want existing contacts touched. Neither creates duplicates.

Existing contacts weren't updated

Cause: Only Insert New adds contacts that aren't in your list, and leaves existing ones exactly as they are, so a corrected phone number or address in the file is ignored.

Fix: Choose Insert New/Update Existing when the file has changes to contacts you already have.

Several values in one cell are read as one

Cause: Categories, Extra E-mails, Important Dates and Custom Fields take several values in one cell, separated by semicolons. The example writes them as friends; clients, label1:email1@example.com;label2:email2@example.com and Important Meeting:12/12/2021;Company Dinner:12/15/2021.

Fix: Separate values with a semicolon, and write each important date, extra email or custom field as a label, a colon and its value.

Names and addresses are capitalised oddly

Cause: Contacts from forms, old CRMs and phones arrive in capitals, lowercase or with stray punctuation.

Fix: Tick Format Names and Addresses on the import screen, which corrects capitalisation, punctuation and common errors. Look over a few contacts afterwards.

One category and source applied to every contact

Cause: The import screen lets you set a Category and a Source for everything in the file. That suits a file from one place, and not one that mixes contacts from several sources.

Fix: For a mixed file, give each row its own Categories and Source values, such as Zillow or an open house, and check how a few of them look after the import.

Contacts end up with the wrong team member

Cause: The import screen assigns the contacts to one inside team member, and the example file has an Assigned To column that holds a full name.

Fix: Import one agent's contacts at a time, or fill in Assigned To with each person's full name and check a few contacts afterwards.

Dates come out the wrong way round

Cause: The example file writes dates month first, such as 6/15/2017 and 7/21/1975. A file from outside the US, or one a spreadsheet has reformatted, can be day first, so 3/9 means 3 September, not 9 March.

Fix: Convert all dates to month, day, year before you upload. See the date formatting guide.

Postal codes lose their leading zero

Cause: A spreadsheet reads 02134 as a number and shows 2134. The file has postal code columns for home, business and other addresses.

Fix: Format those columns as text before you save the CSV. See leading zeros in CSV files.

Phone numbers pasted two to a cell

Cause: Wise Agent has separate columns for home, business, mobile, fax and other numbers, and the example puts one number in each. Two numbers in a cell, or a note after one, can be read wrongly.

Fix: One number per column, in the layout the example shows, such as (555) 555-2134. Put anything extra in Notes.

A company with a comma splits the row

Cause: In a CSV, a comma starts a new column. The example quotes a company such as "Widgets, Inc." so it stays in one cell.

Fix: Export from a spreadsheet, which adds the quotes for you, rather than typing the file by hand. See the commas guide.

Do-not-contact flags lost in the move

Cause: The example file has a DNC column, written as Y. If it isn't brought across from the old system, contacts who asked not to be contacted arrive as ordinary contacts.

Fix: Export every column from the old CRM, and carry the do-not-contact flag into DNC before you import.

After importing

Open a handful of contacts and compare them with your file: the phone numbers, the address, the category and source, and any important dates or custom fields. A wrong heading mapping shows up there before it spreads across a whole database.

If a file keeps failing, Wise Agent says its team will format and import a CSV for you if you email it to help@wiseagent.com.

Checklist before you import

Every heading shows a green check, or is mapped
File name has no spaces or symbols
Import method chosen: insert new, update existing or allow duplicates
Semicolons between categories, extra emails, important dates and custom fields
Dates month first
Postal codes kept as text
One phone number and one email per column
Do-not-contact flags carried into DNC
A few contacts checked after the import

Collecting contacts from several agents?

Send each agent a form instead of a spreadsheet. The Wise Agent contacts template uses all 63 headings of Wise Agent's example file and checks phone numbers, emails and web links as they are typed. Switching from another CRM? Read moving contacts to a new real estate CRM.

Try the Wise Agent template

Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Wise Agent. Wise Agent is a trademark of its owner. Import rules as described in Wise Agent's help center and example file, November 2026.