ChurchTrac Online Church Membership Software
 Return to Support Page

Importing Data from a Spreadsheet or CSV file

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:

  • *COLUMN A: First Name (only one name per row is allowed. Do not combine "George & Martha" as one entry. Make sure there are no blank entries.)
  • *COLUMN B: Last Name (Sort the spreadsheet by this column alphabetically. But within each family grouping, put the head of household as the first name.)
  • COLUMN C: Birthday (mm/dd/yyyy) --or-- Birth Year (if you don't know the year, put the month and day in Columns D and E.)
  • COLUMN D: Birth Month (leave this column blank if Column C contains the full birthday; otherwise this column must be a number between 1-12)
  • COLUMN E: Birth Day (Leave this column blank if Column C contains the full birthday; otherwise this column must be a number between: 1-31)
  • COLUMN F: Email Address (Only one email address per row)
  • COLUMN G: Envelope Number or Member Number
  • COLUMN H: Mobile Phone Number (Only one phone number per row)
  • *COLUMN I: *Family Name (Should be in the format: LASTNAME, FirstName and SpouseName. Do not leave this blank. Don't use only LASTNAME.)
  • COLUMN J: Formal Greeting (For Example: Mr. and Mrs. George Washington. Don't leave it as only 'Mr.' or 'Mrs.')
  • COLUMN K: Informal Greeting (For Example: George and Martha)
  • COLUMN L: Home Address
  • COLUMN M: City --or-- City, State and Zip code
  • COLUMN N: State (leave this column blank if Column M contains City, State and Zip code)
  • COLUMN O: Zip Code (leave this column blank if Column M contains City, State and Zip code)
  • COLUMN P: Home Phone (only one phone number per row; see Note 1 below)
  • COLUMN Q: Member Status (Should be one word, like 'Member', 'Guest', 'Child', etc.)
  • COLUMN R: Active Use only one of the following terms: ("Active", "1","Yes") or ("Inactive", "0", "No"). If left blank, names will be imported as active. )
  • COLUMN S-Z: User Defined Fields (optional; Be sure to log in to your ChurchTrac Online account and first create User-Defined Fields in the appropiate format to match the data in these columns.)

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). ALSO, 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.

The import process will automatically attempt to determine family relationships and assign individuals to the correct family. If you include a Family Name (Column I), we'll automatically assign individuals with the same Family name to the same family. Otherwise, we'll attempt to guess which family an individual belongs to based on their Home Address (Column L) and/or Home Phone Number (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 family fields, like Formal and Informal Greeting, will be created using the entries from the first family member in your spreadsheet.

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 spread sheet 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 Online account. We'll send you a response back once the import process is complete. Here is a sample Excel spreadsheet that you can download that gives you an idea of how to format your spreadsheet: Sample Excel Template