Import
User Guide

Member Import

Flock
Access:Super AdminLead PastorPastorFlock Leader

Getting 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:

FieldTypeDescription
Will be createdCountNew people.
Will be updatedCountExisting people this file changes (with Update existing members on).
Will be skippedCountRows that change nothing, with the reason.
Need reviewCountCreated, but with the same name as someone already in Flock, so they may be the same person.
ErrorsCountRows 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

FieldTypeDescription
Assign to CampusSelectThe 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 membersToggleMatches by email or name and skips anyone who already exists. Nothing about them is changed.
Update existing membersToggleUpdates 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 statusSelectThe 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:

  1. Export the directory from the Members page
  2. Edit the file in Excel or another spreadsheet
  3. 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

FieldTypeDescription
First Name*TextLegal first name.
Last Name*TextLegal last name.
Middle NameTextMiddle name or initial.
Preferred NameTextNickname or goes-by name.
Legal NameTextFull legal name if different from first/last.
SuffixTextJr., Sr., III, etc.
GenderEnumMale or Female (M or F). Anything else is left blank, and the row’s note says why.
Date of BirthDateAccepts YYYY-MM-DD or MM/DD/YYYY format.
Marital StatusEnumSINGLE, MARRIED, WIDOWED, or DIVORCED.

Membership Fields

FieldTypeDescription
Membership StatusTextA status from your church's own list (Settings → Lookup Tables), as its code or its label.
Person CategoryTextOffered 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 #TextGiving envelope number.
Join DateDateYYYY-MM-DD format.
Baptism DateDateYYYY-MM-DD format.
Membership DateDateYYYY-MM-DD format.
Salvation DateDateYYYY-MM-DD format.
Wedding AnniversaryDateWedding anniversary in YYYY-MM-DD format. A column headed "Anniversary" still maps here.
CampusTextThe name of one of your campuses.

Contact Fields

FieldTypeDescription
EmailEmailPrimary email address.
PhonePhoneHome or primary phone number.
Mobile PhonePhoneCell or mobile number.
Preferred ContactEnumEMAIL, PHONE, TEXT, or MAIL.
Do Not ContactBooleanTRUE or FALSE.

Address Fields

FieldTypeDescription
Street AddressTextStreet number and name.
CityTextCity name.
Province / StateText2-letter code (e.g., SK, ON, AB).
Postal CodeTextCanadian postal code.

Profile Fields

FieldTypeDescription
OccupationTextJob title or occupation.
EmployerTextEmployer or company name.
SchoolTextSchool currently attending.
AllergiesTextKnown allergies.
Emergency ContactTextEmergency contact person name.
Emergency PhonePhoneEmergency contact phone number.
Statement PrefEnumEMAIL, PRINT, NONE, or HOUSEHOLD.
TagsTextComma-separated tags.
NotesTextInternal pastoral notes.
External IDTextID 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.

Related Pages