Wise Agent's import rules
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
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 templateRelated Guides
Relevant Templates
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.