Import Members
How-To Guides
All GuidesRun a Sunday ServiceSet Up Online GivingConfigure Children's Check-InGenerate Tax ReceiptsImport MembersCreate a Small GroupSet Up Volunteer TeamsShare the Volunteer ScheduleRecord a Pastoral VisitManage PledgesCreate an Email CampaignSet Up Service PatternsRun a DepositUse a Backup CodeMerge Duplicate DonorsManage Absence AlertsSet Up Prayer GuidesOnboard New MembersManage Join RequestsBuild an Order of ServiceSet Up Worship SetlistsImport Members from Another System
FlockThis guide walks you through importing your member directory from a CSV or Excel file. You will prepare your data, upload the file, map columns to SanctuaryOS fields, review matches, handle duplicates, and verify the import.
Prerequisites
- An Excel (
.xlsx,.xls), CSV (.csv) or tab-separated (.tsv) file exported from your previous church management system, up to 10 MB - The file must include at minimum a First Name and Last Name column
- SUPER_ADMIN, LEAD_PASTOR, PASTOR or FLOCK_LEADER role
Phase 1: Prepare Your Data
Clean your export file before uploading to reduce import issues.
- Open your export file in a spreadsheet application
- Verify the following:
- Each row represents one person, not one household. If you want families grouped, give the family members the same value in a Household column and map it (see Phase 4)
- First and last names are in separate columns
- Dates are in a consistent format (
YYYY-MM-DDis preferred, butMM/DD/YYYYalso works) - Gender values are consistent (e.g., always “M”/“F” or “MALE”/“FEMALE”)
- Phone numbers include area codes
- Remove any header rows that are not column names (SanctuaryOS uses the first row as headers)
- If your file has multiple sheets (Excel), note which sheet contains the active members
Phase 2: Upload the File
- Navigate to Flock → Import
- Drag and drop your file onto the upload area, or click to browse
- SanctuaryOS reads the file and reports its size, its sheets and their row counts, and the column headers with sample data
Phase 3: Configure the Import
The Configure step decides what happens to every row before you map a single column.
- Select sheet: for an Excel workbook with several sheets, choose the one holding your members. Each sheet shows its row count.
- First row is a header: leave this on if row 1 contains column names rather than a person. Turn it off and row 1 is imported as data.
- Skip duplicate members: on by default. A row matching an existing member is skipped and that member is left untouched. Turn it off and every row is imported, duplicates included.
- Update existing members: off by default. Switch it on to update people you already have from the file instead of skipping them. People are matched on email, then envelope number, then external ID, and only the columns in the file are written; rows that match nobody are added as new people. The result reports created, updated, skipped and errors separately.
- Default membership status: the status given to any row whose own status is blank or unmapped. The choices come from your own lookup tables, and it starts on your church's default status for new people. A status in the file that is not on your list (by code or by label) is reported as an error row.
- Assign to campus: optional. Every imported member is assigned to this campus unless a campus column is mapped. A campus name in the file that matches none of your campuses is reported as an error row.
Phase 4: Map Columns
Each column in your file needs to be mapped to a SanctuaryOS field. The system auto-suggests mappings based on header names, but you should review each one. A people export from Planning Center or Breeze maps itself, column for column, including households and their IDs; see Flock Import for which columns go where.
- For each column, select the matching SanctuaryOS field from the dropdown. Available fields include:
- Identity: First Name (required), Last Name (required), Middle Name, Preferred Name, Legal Name, Suffix, Gender, Date of Birth, Marital Status
- Membership: Membership Status, Envelope #, Join Date, Baptism Date, Membership Date, Salvation Date, Anniversary
- Contact: Email, Phone, Mobile Phone, Preferred Contact, Do Not Contact
- Address: Household, Street Address, City, Province/State, Postal Code
- Profile: Occupation, Employer, School, Allergies, Emergency Contact, Emergency Phone, Statement Pref, Tags, Notes, External ID
- Your church's own custom fields appear in this list too, under their own group
- For columns you do not want to import, select Skip this column
- Verify that First Name and Last Name are mapped. The page will not let you continue until they are
Phase 5: Review and Run
- Click “Review & Import”
- The review screen restates what is about to happen: the rows to be imported, an estimate of how many look like duplicates of existing members, the options you chose, and the fields you mapped.
- Click “Import” to run it
- When it finishes you get a summary of what was created, updated and skipped, and any rows that failed with the reason. A row that looks like an existing person gets a review-and-merge link. View imported people opens the directory showing only the people this import created or updated.
Phase 6: Verify the Import
- Navigate to Flock → People
- Check the total member count. It should have increased by the number of new records imported
- Open a few imported profiles and verify fields are populated correctly (name, email, phone, address, dates)
- Check the Tags and Membership Status fields if you mapped them