1) How do I link spouses with the spreadsheet import?
We automatically create a separate record for the spouse if the spouse name is listed under the Spouse Name Columns (Column M1-P1). As long as the spouse is listed on the same row/line as the primary contact, we will automatically link the spouse to the primary contact when we run the import.
A common mistake that we see is listing the spouse name multiple times on the spreadsheet, which results in duplicate records. Please be sure to list the spouse name only once on the spreadsheet.
2) What is the Companyname field for?
This field is used to create an Employer Record for the Primary Contact listed in columns C-F on the spreadsheet. This will automatically create a separate business record for any company names listed in this field, and be linked back to the Primary Contact as their Employer in Redtail.
If you need to import a Company without linking it to a contact, you can omit adding information to columns C-F, and add a “B” to the Type column. This will create a Business Record only, which can have its own contact information listed (phones, addresses, emails, etc.)
You can also use this field to add Trust Records to your database. Simply add the name of the Trust to the Companyname column and a “T” to the Type column, and we will create a Trust Record when we import this data.
3) Can I change any of the column header titles on the template?
Please do not change any of the pre-titled column headers on the template as this could cause issues with the import. The only column header titles you are able to customize on the template are the UD1-UD20 columns.
4) How do I import multiple keywords or tag groups?
We can import multiple keywords and/or tag groups with the spreadsheet import. You can use a semicolon to separate multiple keywords or tag groups.
5) How long does it take for my spreadsheet template to get imported once I send it in?
We can usually complete the spreadsheet import within 1 business day of receiving the file.
6) What is the minimum number of contact records for an Excel import?
We can import any number of contacts you may need - however, please keep in mind that spreadsheet imports can take up to 1 business day to be completed. This spreadsheet template usually works best for larger numbers that would take too long to manually enter into Redtail.