When importing data into Tribe, it is common to have multiple pieces of information stored in a single column, such as a full name or a complete address. Automatically splitting this data saves time, reduces manual corrections, and helps keep your CRM data consistent. You might use this when your Excel file is not structured in the same way as Tribe fields. By following this guide, you will learn how to split common data types into separate fields during the import process.
Table Of Contents
What Does Automatic Splitting Do?
What Data Can Be Split Automatically?
Step By Step Instructions
Tips Or Best Practices
What Does Automatic Splitting Do?
Automatic splitting allows Tribe to divide data from a single import column into multiple separate fields. This is useful when your source file combines information that is stored separately in Tribe. The splitting happens during the import, so no changes are needed in Excel beforehand.
What Data Can Be Split Automatically?
Tribe supports automatic splitting for common data combinations used in CRM records. These include:
Street, house number, and house number addition
First name, middle name, and last name
If this information is stored in one column in your import file, the split options help map it correctly to Tribe fields.
Step By Step Instructions
Start an import as usual and upload your Excel file.
Select the Tribe field where you want to store the first part of the data, such as First Name or Street.
Choose the split option for that field, such as Get First Name From Full Name or Get Street Name From Address.
Select the source column from your Excel file in the From Field dropdown that appears.
Repeat these steps for the remaining related fields, such as Middle Name and Last Name, or House Number and House Number Addition.
Continue with the rest of the import and complete it as normal.
Note: The split options only work when the selected Tribe fields belong to the same data group, such as name fields or address fields.
Tips Or Best Practices
Use splitting when your Excel file contains combined data and you want to avoid manual editing later.
Check that the data in your source column follows a consistent format for best results.
Review the field mapping carefully before completing the import to confirm each part is linked correctly.
Quick Summary
Automatic splitting helps divide combined data into separate Tribe fields during import. It supports common combinations such as names and addresses, without requiring Excel formulas. Using this feature keeps your data structured and ready for use immediately after import.