Import
Getting Started
IntroductionNotificationsMy AccountMy ChurchA Child's BibleOn Your PhoneInstall SanctuaryOSFlock
OverviewMembersMember ProfileHouseholdsDashboardCampaignsChildren's ProfilesEngagementImportMerge DuplicatesOnboardingReportsPeople ReportsSteward
OverviewDashboardSessionsNew SessionSession DetailDepositsNew DepositDeposit DetailDonorsDonor ProfilePledgesRecurring GivingOnline GivingGiving PagesImportBulk ActionsStatementsFundsDonor JourneyReportsGather
OverviewDashboardCalendarCheck-In PickerCheck-In ConsoleSelf Check-In KioskAttendance RecordsRecord DetailChildren's Check-InChildren's ConsoleOrder of ServiceRun SheetEventsAbsence AlertsReportsSongsServe
OverviewDashboardTeamsTeam DetailVolunteersVolunteer DetailScheduleTeam SchedulingMy UpcomingSongsSetlistsSetlist DetailAvailabilityMy AvailabilityScreeningConfirmationsVolunteer RequestsReportsCircles
OverviewDashboardGroupsGroup DetailPublic Group FinderLeadersJoin RequestsTake AttendanceAttendanceLapsed MembersUnassignedSmall Group ChatsReportsMember Import
FlockGetting Here
Navigation: Flock → People → Import button, or directly at /flock/import
Overview
The Import Wizard lets you bring member data into SanctuaryOS from CSV or XLSX files. It uses a multi-step process: upload your file, configure it, map columns to SanctuaryOS fields, review exactly what the import will do, and run it. The system includes smart auto-mapping that guesses field assignments based on column headers, and supports both system fields and tenant-defined custom fields.
Import Steps
Step 1: Upload File
Drag and drop a CSV or XLSX file, or click to browse. For XLSX files with multiple sheets, you can select which sheet to import; the columns and the mapping follow the sheet you pick. The parser extracts column headers and sample data (first 5 rows) for the mapping step. A CSV saved as UTF-8 is read correctly with or without a byte-order mark, so accented names such as Peña and Émile arrive intact.
Step 2: Configure
Choose the sheet (for a workbook with several) and the import options below.
Step 3: Map Columns
Each column from your file is displayed with its header name and sample values. Use the dropdown to map each column to a SanctuaryOS field. The auto-mapper pre-fills common mappings based on header names (e.g., “First Name” maps to firstName, “Env #” maps to envelopeNo).
Columns you do not want to import can be set to “Skip this column”. You can also save your column mapping as a template for future imports.
The auto-mapper reads each header in this order: an exact SanctuaryOS field (its label or its key), then an exact custom field (its name or key), then your church's name for its Person Category, then the keyword rules (“DOB”, “Env #” and so on). A column becomes the membership status only when it is headed “Status” or “Member Status”, so a custom field such as “Volunteer Status” maps to that field.
While a required field is not mapped, Next stays disabled and the page names what is missing (“Map Last Name to continue.”). With Update existing members on, First Name and Last Name are not required to map: a row that matches someone is updated without them. A row that would add a new person still needs both.
Moving from Planning Center or Breeze? Upload their people export as it is: every column maps itself. Home address street, city, state and zip go to Address, City, Province and Postal Code; Home and Mobile phone to Phone and Mobile Phone; Household ID / Household Name (Planning Center) and Family (Breeze) group people into households; Remote ID, Person ID and Breeze ID become the External ID; Medical Notes goes to Allergies. Columns that would overwrite a right value are skipped: the second street line, work phone and work email, Household Primary Contact, Family Role and Birthdate Month/Day. Check the mapping as usual before you review.
SanctuaryOS also remembers how you mapped a file's columns. The next time you upload a file with the same headers, the columns are mapped the way you mapped them last time, and the page says so.
Step 4: Review & Import
Click Review first. Review runs the whole import against your members and then throws it away, so nothing is saved, and shows exactly what Import will do:
| Field | Type | Description |
|---|---|---|
| Will be created | Count | New people. |
| Will be updated | Count | Existing people this file changes (with Update existing members on). |
| Will be skipped | Count | Rows that change nothing, with the reason. |
| Need review | Count | Created, but with the same name as someone already in Flock, so they may be the same person. |
| Errors | Count | Rows that will not be imported, with the reason. |
Download findings (Excel) gives a workbook with three sheets: Summary, Issues only and All rows. Each row lists its row number, outcome, reason, the existing person it matched, and the values from your file. A large file shows a progress bar while it is reviewed and imported.
Import stays disabled until a review has been run, and the button reads Import (review first) until then. A review belongs to the exact file and settings it was run on: change the mapping or an option and the page asks you to run Review again. The import then does exactly what the review showed. A file is imported once; to import it again, upload it again.
Step 5: Complete
The result reports four separate numbers: Created, Updated, Skipped and Errors, with a readable reason for each skipped or failed row. Rows the importer suspects are duplicates of an existing person get a review-and-merge link. View imported people then opens the directory showing only the people this import created or updated. Download results (Excel) gives the same three-sheet workbook for what was imported.
An import is all or nothing if something goes wrong part way: either the whole file is imported (with bad rows reported as errors) or nothing is.
Import Options
| Field | Type | Description |
|---|---|---|
| Assign to Campus | Select | The campus new people are assigned to, unless a Campus column is mapped. A Campus value in the file that matches none of your campuses is reported as an error row, never silently reassigned. |
| Skip duplicate members | Toggle | Matches by email or name and skips anyone who already exists. Nothing about them is changed. |
| Update existing members | Toggle | Updates people who already exist instead of skipping them. Matches on email, then envelope number, then external ID. Only the columns in the file are written; a column that is not in the file is left as it is. Rows that match nobody are added as new people. |
| Default membership status | Select | The status given to rows with no status of their own. The choices are your church's own statuses, and it starts on your church's default status for new people. |
Export, Edit and Import Back
The member export has exactly the columns of the import template, including Campus and your custom fields. To change many people at once:
- Export the directory from the Members page
- Edit the file in Excel or another spreadsheet
- Import it with Update existing members switched on
Only the values you changed are written. Re-importing an unedited export changes nothing.
Membership Status and Your Plan
- Membership Status is checked against your church's own status list. You can type either the code or your church's label (for example “WSAM/LGAM”). An unknown status is an error row, never quietly changed. A row with no status gets your church's default status for new people, or none if you have not chosen a default.
- An import is never refused for your plan. If it takes your church past the active people your plan covers, the plan moves to fit at your next bill, and nothing extra is charged before then (see Subscription Management).
Supported Fields
The import wizard supports mapping to all standard SanctuaryOS person fields, organized by category:
Identity Fields
| Field | Type | Description |
|---|---|---|
| First Name* | Text | Legal first name. |
| Last Name* | Text | Legal last name. |
| Middle Name | Text | Middle name or initial. |
| Preferred Name | Text | Nickname or goes-by name. |
| Legal Name | Text | Full legal name if different from first/last. |
| Suffix | Text | Jr., Sr., III, etc. |
| Gender | Enum | Male or Female (M or F). Anything else is left blank, and the row’s note says why. |
| Date of Birth | Date | Accepts YYYY-MM-DD or MM/DD/YYYY format. |
| Marital Status | Enum | SINGLE, MARRIED, WIDOWED, or DIVORCED. |
Membership Fields
| Field | Type | Description |
|---|---|---|
| Membership Status | Text | A status from your church's own list (Settings → Lookup Tables), as its code or its label. |
| Person Category | Text | Offered only when your church has Person Category entries, under the name your church gave it. One of your entries, by its label or its code. A value that is not one of your entries is reported in Review as an error on that row; nothing is guessed. |
| Envelope # | Text | Giving envelope number. |
| Join Date | Date | YYYY-MM-DD format. |
| Baptism Date | Date | YYYY-MM-DD format. |
| Membership Date | Date | YYYY-MM-DD format. |
| Salvation Date | Date | YYYY-MM-DD format. |
| Wedding Anniversary | Date | Wedding anniversary in YYYY-MM-DD format. A column headed "Anniversary" still maps here. |
| Campus | Text | The name of one of your campuses. |
Contact Fields
| Field | Type | Description |
|---|---|---|
Email | Primary email address. | |
| Phone | Phone | Home or primary phone number. |
| Mobile Phone | Phone | Cell or mobile number. |
| Preferred Contact | Enum | EMAIL, PHONE, TEXT, or MAIL. |
| Do Not Contact | Boolean | TRUE or FALSE. |
Address Fields
| Field | Type | Description |
|---|---|---|
| Street Address | Text | Street number and name. |
| City | Text | City name. |
| Province / State | Text | 2-letter code (e.g., SK, ON, AB). |
| Postal Code | Text | Canadian postal code. |
Profile Fields
| Field | Type | Description |
|---|---|---|
| Occupation | Text | Job title or occupation. |
| Employer | Text | Employer or company name. |
| School | Text | School currently attending. |
| Allergies | Text | Known allergies. |
| Emergency Contact | Text | Emergency contact person name. |
| Emergency Phone | Phone | Emergency contact phone number. |
| Statement Pref | Enum | EMAIL, PRINT, NONE, or HOUSEHOLD. |
| Tags | Text | Comma-separated tags. |
| Notes | Text | Internal pastoral notes. |
| External ID | Text | ID from your previous church management system. |
Custom Fields
If your tenant has defined custom fields in Settings, they also appear as mapping targets in the import wizard. Custom fields are matched by name against your column headers.
Actions
Download Template
Click the Download Template link to get a pre-formatted XLSX file with all supported column headers and drop-down lists. The Membership Status drop-down lists your church's own labels. The file opens in Excel without any repair warning. Use it as a starting point for preparing your import data.
Save Mapping Template
After mapping columns, click Save Mapping to store the column-to-field mapping for reuse. This is useful if you regularly import from the same external system with the same column layout.
Load Mapping Template
When mapping columns, you can load a previously saved template to automatically apply the same column assignments.
Try with Sample Data
Try with sample data walks you through the wizard with a sample file. Nothing is imported, and the result panel says the sample run finished and nothing was imported, with no counts.