This guide is the reference for the SteepleMate people-import files. It explains how to fill in the Row-Per-Person template column by column, and points you to the right template if your data comes from Planning Center, Breeze, Realm or another list. To follow the upload itself, see Importing Data into SteepleMate.
Two quick notes before you start:
Open Import People: Choose Administration, then Import People. (It used to be called Import Data.)
Find the Row-Per-Person box: Click the here link in the Row-Per-Person box to download the template.

1. here: Downloads the Row-Per-Person template (a spreadsheet).
2. Upload SteepleMate Person Format: Where you upload the finished file. You will use it in Step 4.
The template has a row of column headings and four example people (rows 2 to 5). Delete the example rows before you import, but do not delete or change the headings. SteepleMate uses them to check that your file is in the right format.
The columns are in this order. The first four groups are the ones most churches need.
People and families
Names
Groups, address and contact details
Personal details
Extra columns (optional)
To bring in groups or your own custom fields, add columns to the right of AG. Start each heading with a code: G: and a group name (everyone with something in that column joins the group), T: for a text field, B: for a yes or no field, D: for a date field or N: for a number field. For example, G:Youth Choir. The first row must be the heading row, and there must be no blank heading between your extra columns. If you would rather not set this up yourself, contact Support.
Open Import People: Choose Administration, then Import People, then click Upload SteepleMate Person Format.
Choose the file and Begin: Click Browse, pick your file, leave First Row Contains Column Names checked, and click Begin.
If SteepleMate thinks the file does not match the Row-Per-Person format, it stops and adds nobody. See Importing Data into SteepleMate for what the messages mean.
The Import People page has a separate template or sample for each source. Use the box that matches your file, and upload it with that box's own button. (Each box is also described in Importing Data into SteepleMate.)
Row-Per-Family: One row for each family: the head of household, a spouse, and up to six children, with their addresses, phones, emails and an optional ID from your old system. The template column headings are in capitals, for example CHILD1_FIRST. A child's last name goes in CHILD1_LAST when it differs from the family name. Gender for children is M or F. The head of household's gender follows the greeting you choose, and spouses are assumed to be female.
Planning Center: Export your people from Planning Center and upload the file as it is. It should look like the Planning Center template. This template was corrected in release 369, so download it again if you saved an older copy. You do not assign your own ID numbers. Planning Center's IDs are used. Planning Center's Membership column decides the person type: Member and Regular Attender become Church Family, In Progress becomes Visitor and everything else becomes a Contact. Medical Notes go to the person's internal notes, which the person cannot see. Each different value in School becomes a group, and everyone with that value is added to it. To add more groups, add a Groups column straight after the Updated At column (column BJ) and list each person's groups separated by semicolons, for example Youth Ages 12-18;Bilingual;Hosting.

1. here: Downloads the Planning Center template.
2. Upload PlanningCenter Format: Uploads a Planning Center file.
Breeze: Download the Breeze template and arrange your Breeze export to match it. Columns marked "Not used (leave blank)" must stay in place, empty. Breeze may export in a layout SteepleMate cannot read. If you cannot match the template, send us the export and we will import it for you.
Realm: Compare your Realm export to the Realm sample and make sure the columns line up with it. Column A must be Individual Id, column C First Name and column E Last Name. A sample file is on the Import People page, and release 369 added it.

1. here: Downloads the Realm sample.
2. Upload Realm Format: Uploads a Realm file.
Other systems: If your data is in something else, such as a custom database or a spreadsheet laid out differently, contact Support. We will look at it and tell you the best way in.

If you run into any issues or have questions during the process, don’t hesitate to contact us at support@steeplemate.com. We're here to assist you every step of the way! This may be a good moment to explore allowing us to import your data for you. Send your account manager the exported file from your previous system and allow us an hour or two to map the data and import for you.