Skip to main content

Split name and address into separate columns (Parsed vs. Unparsed fields)

Choose the Parsed version of Contact Name and Property Address in the export Fields selector to split them into separate columns (First Name, Last Name, street, city, state, ZIP, county).

Written by AJ

By default, an export gives you the full contact name in one cell and the full property address in one cell. If you want them broken out into separate columns — First Name, Last Name, and the address split into street, city, state, ZIP, and county — you choose the Parsed version of those fields when you set up your export.

Parsed = split into separate columns. Unparsed = everything in one cell. Pick Parsed when you need First/Last name and the address components in their own columns.

How to get split columns

  1. In the Property Prospecting Grid, select your records, then click Export (Select → Export).

  2. Choose your export format (for example, Property List or Contact List).

  3. Scroll down in the export window and click Fields.

  4. In the field list, find Contact Name and Property Address. Each one has two versions:

    • Unparsed — the full name or full address in a single column.

    • Parsed — split into separate columns (Contact Name → First Name and Last Name; Property Address → street, city, state, ZIP, and county).

  5. Select the Parsed version of Contact Name and/or Property Address. If you don't also want the combined column, leave the Unparsed version unchecked.

  6. Add any other fields you want in the same list (year built, beds, baths, square footage, and more), drag to reorder your columns, then click Export.

Add the contact's own address (Contact List)

In a Contact List export, you can also include each person's primary address, which can be different from the property address.

1. In the export window, choose Contact List.

2. Turn on Person primary address.

3. Under Person address format, pick Full address (one column) or Parsed parts (Line 1, Line 2, City, State and Zip in separate columns). It starts out matching your other address format setting.

4. Click Export.

If a person has no address on file, or part of it is missing, those columns are left blank

Your CSV will follow the exact columns and order you chose, with the name and address already split out — no need to separate them afterward in a spreadsheet.

Did this answer your question?