Skip to main content
All CollectionsEventsCheck-inHow-To
Import Household Data from another CHMS
Import Household Data from another CHMS

Importing household and people data from a third-party church management system.

Connor Stallings avatar
Written by Connor Stallings
Updated over 9 months ago

If you are using the previous version of Check-in, check out our Legacy Support resources HERE.

Tips

  • “Household ID” is the single identifier that our importer will use to group people into a household. You can use any text or numerical ID value, as long as all household members have that same value they will be linked together. Households will NOT be automatically linked by matching address information.

  • Go to /People > /Duplicates to clean up any duplicate profiles first

  • It's OK to leave some fields blank or skip importing some data points. For example, children don’t typically have an email address. If you don’t have every child’s DOB handy, that's OK. Parents can add their children’s DOB and other information later via the Check-in kiosk.

Supported Fields

Ensure the title matches exactly.

  • First name

  • Last name

  • Email address

  • Phone number

  • Date of birth: (MM/DD/YYYY)

  • Allergies: text field - please limit to 40 characters

  • Care notes: text field - please limit to 40 characters

  • Grade: blank, pre-k, k, 1st, 2nd, 3rd, 4th, 5th, 6th, 7th, 8th, 9th, 10th, 11th, 12th

  • Graduation year (YYYY)

  • Household ID

  • Household role: Adult, Child, or leave blank

  • Household Street

  • Household Street 2

  • Household City

  • Household State

  • Household Postal Code

  • Household Country

Prepare your data:

  • Export your data from your other check-in system

  • Email is the key identifier for profiles. Please ensure these are unique if possible to prevent duplicates.

Example of Household Import CSV

Import your data:

Drag and drop your CSV to Upload your data into the Importer.

Match columns

Map your CSV columns to the Subsplash fields.

Here is an example of all columns matched up:

Preview import

Review your data to make a final check. You can scroll to the right to review more columns. If all looks good, Finish import.

When complete, you will receive an email with the import digest as well as this Import digest page.

Did this answer your question?