RealtyJuggler CSV Column Titles

Contacts
Prospects
Calendar
Mail
TaskPlan
Lockboxes
Buyers
Sellers
Closings
Homes
Income
Expenses
Education

Detailed instructions on how to import your contacts into RealtyJuggler from the most popular contact management products are listed here.

You can Export your data out of RealtyJuggler by going to Main:Settings:Export. Similarly, you can Import data into RealtyJuggler by going to Main:Settings:Import

The easiest way to see the precise format of a CSV formatted file is to create a new record and then export that record out of RealtyJuggler. That way, you can see what columns go into what fields. The order of the columns is unimportant and most columns can be omitted without any problems.

Contacts CSV Column Names:

Title / Job Title
First Name
Middle Name
Last Name
Company
Business Street / Business Street 1
Business Street 2
Business Street 3
Business Street 4
Business Street 5
Business Street 6
Business Street 7
Business Address PO Box
Business City
Business State
Business Postal Code
Business Zip4
Business Country
Home Street / Home Street 1
Home Street 2
Home Street 3
Home Street 4
Home Street 5
Home Street 6
Home Street 7
Home Address PO Box
Home City
Home State
Home Postal Code
Home Zip4
Home Country
Other Street / Other Street 1
Other Street 2
Other Street 3
Other Street 4
Other Street 5
Other Street 6
Other Street 7
Other Address PO Box
Other City
Other State
Other Postal Code
Other Zip4
Other Country
Assistant's Phone
Business Fax
Work Phone / Work Phone 1
Work Phone 2
Business Phone
Business Phone 2
Callback
Car Phone
Company Main Phone
Home Fax
Home Phone / Home Phone 1
Home Phone 2
ISDN
Mobile Phone / Mobile
Other Fax
Other Phone
Pager
Primary Phone
Radio Phone
TTY/TDD Phone
Telex
Spouse
Spouse First Name
Spouse Last Name
Assistant's Name
Birthday
Anniversary
Spouse Birthday
Children
E-mail Address
E-mail 2 Address
E-mail 3 Address
E-mail 4 Address
E-mail 5 Address
Hobby
Web Page
Referred By
Notes
Notes 2
Notes 3
Notes 4
Notes 5
User 1 / Custom 1
User 2 / Custom 2
User 3 / Custom 3
User 4 / Custom 4
Categories
Categories 1
Categories 2
Categories 3
Categories 4
Contact Type
Last Contact Date

Prospects CSV Column Names:

Title / Job Title
First Name
Middle Name
Last Name
Company
Mailing Street / Business Street
Mailing Street 1 / Business Street 1
Mailing Street 2 / Business Street 2
Mailing Street 3 / Business Street 3
Mailing Street 4 / Business Street 4
Mailing Street 5 / Business Street 5
Mailing Street 6 / Business Street 6
Mailing Street 7 / Business Street 7
Mailing City / Business City
Mailing State / Business State
Mailing Postal Code / Business Postal Code
Mailing Zip4
Mailing Country / Business Country
Home Street / Property Street
Home Street 1 / Property Street 1
Home Street 2 / Property Street 2
Home Street 3 / Property Street 3
Home Street 4 / Property Street 4
Home Street 5 / Property Street 5
Home Street 6 / Property Street 6
Home Street 7 / Property Street 7
Home City / Property City
Home State / Property State
Home Postal Code / Property Postal Code
Home Zip4
Home Country / Property Country
mlsid
Home Phone / Home Phone 1
Home Phone 2
Home Fax
Business Fax
Other Fax
Work Phone / Work Phone 1
Work Phone 2
Main Phone / Company Main Phone
Pager
Mobile Phone / Mobile
Business Phone
Business Phone 2
Car Phone
ISDN
Other Phone
Pager
Primary Phone
Radio Phone
TTY/TDD Phone
Telex
Spouse
Spouse First Name
Spouse Last Name
Assistant's Name
Birthday
Anniversary
Spouse Birthday
Children
E-mail Address
E-mail 2 Address
E-mail 3 Address
E-mail 4 Address
ProspectIsBuyer
ProspectIsSeller
ProspectIsRenter
Referred By / Prospect Source
Prospect Source Description
Notes
Notes 2
Notes 3
Notes 4
Notes 5
User 1 / Custom 1
User 2 / Custom 2
User 3 / Custom 3
User 4 / Custom 4
Categories
Categories 1
Categories 2
Categories 3
Categories 4
Contact Type
Created Date or Initial Contact Date
Last Contact Date
Last Modified Date

Calendar CSV File Format:

The Calendar CSV file format the same format that Microsoft Office Outlook exports when exporting CSV format. The easiest way to see the precise format of a contacts CSV formatted file is to create a new calendar entry and then export that calendar using CSV format.

Mail Forms CSV File Format:

It is possible to import and export from-to the Mail Forms database using CSV formatted files. It is recommended that you create a sample Mail Form record (located at Main:Settings:Mail Forms), then do an export to see the precise column names and possible field values.

Task Plan CSV File Format:

It is possible to import and export from-to the Task Plans (sometimes also called Action Plans) database using CSV formatted files. It is recommended that you create a sample Task Plan (located at Main:Settings:Task Plans), then do an export to see the precise column names and possible field values.

Homes CSV File Format:

It is possible to import and export from-to the Homes database using CSV formatted files. It is recommended that you create a sample Home record (located at Main:Homes), then do an export to see the precise column names.

Lockboxes CSV Column Names:

RecordID
SerialNumber
Address
City
State
Postal Code
Country
MLSID
LockboxType
LockboxComboType1
LockboxComboField1
LockboxComboType2
LockboxComboField2
LockboxComboType3
LockboxComboField3
Notes

Buyers CSV Column Names:

The best way to see the format of a Buyers database is to create a sample record by going to Main:Buyers and then exporting the database by going to Main:Settings:Export and opening the resulting CSV file within Microsoft Excel.

Sellers CSV Column Names:

The best way to see the format of a Sellers database is to create a sample record by going to Main:Sellers and then exporting the database by going to Main:Settings:Export and opening the resulting CSV file within Microsoft Excel.

Closings CSV Column Names:

The best way to see the format of a Closings database is to create a sample record by going to Main:Closings and then exporting the database by going to Main:Settings:Export and opening the resulting CSV file within Microsoft Excel.

Income CSV Column Names:

Expenses CSV Column Names:

The best way to see the format of a Expenses database is to create a sample record by going to Main:Expenses and then exporting the database by going to Main:Settings:Export and opening the resulting CSV file within Microsoft Excel.

Education CSV Column Names:

The best way to see the format of a Education database is to create a sample record by going to Main:Education and then exporting the database by going to Main:Settings:Export and opening the resulting CSV file within Microsoft Excel.