

Moving to SteepleMate from a spreadsheet or another church system? You can load your people and families yourself, or let our team do it for you. This guide covers the people import from start to finish: where to find the templates, how to upload a file, and what to do if SteepleMate stops an import.
You need Administrator or SuperUser access to import people.
Open the menu: Choose Administration, then Import People. (This used to be called Import Data. Import Attendance, the next item, is a separate tool, described at the end of this guide.)

1. Import People: Opens the people import. The page is titled Import Members.
2. Import Attendance: Imports past attendance. See "Importing attendance" below.
The page shows one box for each kind of file SteepleMate can read. Each box has a template or sample you can download, and its own upload button.

1. Row-Per-Person: One row for each person. Best for a spreadsheet you build or clean up yourself, and for most moves from another system.
2. Download the template: The here link next to each format downloads that format's template. Download it before you prepare your data.
3. Upload SteepleMate Person Format: Starts the upload for this format.
4. Row-Per-Family: One row for each family, with columns for a spouse and up to six children.
5. Breeze: For a file exported from Breeze and arranged to match the Breeze template.
6. Planning Center: For a file exported from Planning Center. It should look very much like the Planning Center template.

1. Realm: For a file exported from Realm.
2. Realm sample: A sample file. Compare your export to it and make sure the columns are in the same order before you upload. For example, column A must be IndividualId and column E must be LastName.
3. Upload Realm Format: Starts the upload for this format.
4. Other Formats: Using something else, such as a custom database? Contact Support and we will look at your file and find the best way to bring it in.
For what goes in each column of the Row-Per-Person template, see the article Data Import Guide: Row-Per-Person Format.
Start from the template: Open the template you downloaded, delete the example rows, and put your own people in. Do not delete or rename the header row.
Save it as a spreadsheet or CSV: SteepleMate reads .xlsx, .xls and .csv files. Anything else is refused.
Choose your format: Click the green upload button for your format, for example Upload SteepleMate Person Format.
Browse for the file: Click Browse, pick your file, then choose your options.

1. Browse: Pick the file on your computer.
2. Begin: Starts the import. Nothing is imported until you choose this.
3. Cancel: Takes you back to the list of formats without importing anything.
4. Validate Cell Phones: Checks that the numbers you mark as cell phones really are cell numbers. It costs 5 cents per number.
5. First Row Contains Column Names: Leave this checked when your file starts with a row of headings, as the templates do. SteepleMate skips that row, and uses it to check that you chose the right format.
6. Mark All As Active Members: Check it only if every person in the file is an active member of your church.
Choose Begin. A large file can take a while. Keep the page open until you see the result.
When the import finishes, a message tells you how many people and families were imported, for example "Imported a total of 120 people into 45 families."
Look at your people: Choose Manage, then People and look through the list. Spot-check a few families: each should have one head of household, with the right spouse and children. If a family looks wrong, Administration, then Check Family Roles will find families with a role problem (see How to Use the Check Family Roles Report). To clean up the same person entered twice, see How to Merge Duplicate Profiles in SteepleMate.
Import each file once: If something looks wrong, contact Support before you upload the same file again, so you do not end up with every person twice.
Since the October 2026 release (369), SteepleMate checks that your file matches the format you chose before it saves anything. If the file looks like it was read incorrectly, the import stops and no people are added. You will see a red message at the top of the page.

There are two kinds of message:
To fix it: Stay on the upload screen, correct the file (or choose the right format with Cancel), choose the file again and click Begin. Use the template for your format so the columns line up. If the file really is right and it still stops, contact Support.
Administration, then Import Attendance, loads past attendance from a spreadsheet (.xlsx). Each row is a person and an attendance group, and each column after those holds a service date. It does not use the formats above.