We don't believe that you should pay to get your initial data into ChurchTrac Online. We will import your first spreadsheet of basic People and Family data from an Excel or .CSV file, for free.
Please set up your spreadsheet using the following columns in the following order. You don't have to include every column below-- but if you do skip a column, insert a blank column in its place. If you use ChurchTrac 9 (the desktop edition), do not use these instructions. Instead, you'll want to go back and follow the instructions for importing your data from ChurchTrac 9. The following columns/fields can be included in your spreadsheet for import. Be sure that the data in your spreadsheet matches the items in this list (Columns with an asterisk (*) are required fields.
The following columns (I-P) are shared FAMILY fields, so they should contain identical data for each family member; including spouse and children:
The following columns (Q-R) are per INDIVIDUAL name:
The following columns (S-Z) can contain either INDIVIDUAL or FAMILY data:
Important! If you don't know the value of a field, just leave it blank! Do not include a placeholder (like N/A, ? or Unknown).
Note 1: If two people share the same name, add something to the First Name field to distinguish between the two individuals (duplicate names will be skipped). For example, you can add Jr., Sr., or a middle initial to the First Name field to avoid duplicate names.
Note 2: The import process will automatically attempt to determine family relationships and assign individuals to the correct family. We'll automatically assign individuals with the same Family Name to the same family based on (Column I). Otherwise, we'll attempt to guess which family an individual belongs to based on their Home Address (Column L) and/or Home Phone (Column P). If an existing family relationship cannot be determined, a new family will be created, and its Family Name will be generated based on the first individual in that family in your spreadsheet. Additionally, other shared Family fields, like Formal (Column J) and Informal Greeting (Column K), will be created using the entries from the first family member in your spreadsheet.
Note 3: One of your User-Defined columns can contain an additional phone number, such as a work phone number. If so, we'll import this column as a Phone Number field and not as a User-Defined field. For example, create date fields as [Date], Boolean fields as [Yes/No], option fields as [Selection List], and so on. If you don't have the YEAR for all the dates, the format needs to be MM,DD,YYYY or MM,DD (using commas in between digits). If you have more than 10 user-defined fields to import, please contact us.
Once you have set up your spreadsheet according to these instructions, create a Support Ticket and attach the file. Be sure to include the Church name and phone number for you ChurchTrac account. We'll send you a response back once the import process is complete. Data Imports usually take 1-3 business days. Here is a sample Excel spreadsheet that you can download that gives you an idea of how to format your spreadsheet: Sample Excel Template