Import People into SteepleMate: Step-by-Step Guide

Importing Data into SteepleMate

NotesIdea
Our team can import your members and finances for free! Let us handle the heavy lifting and get your data into SteepleMate without the
hassle. Just send us the exported file from your previous system, or connect with your account manager for additional help in retrieving the data.

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.

Step-by-Step Guide

Step 1: Open 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.)

The Administration menu with Import People and Import Attendance highlighted

1. Import People: Opens the people import. The page is titled Import Members.
2. Import Attendance: Imports past attendance. See "Importing attendance" below.

Step 2: Choose the format that matches your file

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.

The Import Members page with the Row-Per-Person, Row-Per-Family, Breeze and Planning Center formats

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.

The Realm and Other Formats boxes

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.

Step 3: Prepare your file

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.

Step 4: Upload your file

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.

The upload screen with Browse, Begin, Cancel and the three import 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.

Step 5: Check 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.

If SteepleMate stops your import

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.

The red message shown when a file does not match the template

There are two kinds of message:

  • * "This file does not match the Person template: expected First Name in column K, found ..." The headings are not where the format expects them. The usual causes are choosing the wrong format (a Planning Center file sent through Row-Per-Person), a template with columns added, deleted or moved, or First Row Contains Column Names checked for a file that has no heading row. The message names the format and the column it expected.
  • * "This file does not match the template: 12 of 40 rows have a blank name or a date where a last name should be." This appears when the box is unchecked and more than a quarter of the rows look wrong. Columns have usually shifted, so a date has landed where the last name belongs.

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.

Importing attendance

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.

  • * SteepleMate matches the names and the group names in your file to the people and attendance groups in your church. Names can be written First Last or Last, First.
  • * For anything it cannot match, you choose what to do on two review screens, Synchronize Attendance Groups and Synchronize Attendees: pick the right group or person, create a new one, or leave those entries out. A person can also be counted as anonymous.
  • * A service is created for any date in your file that your church does not already have.
  • * Contact Support for the attendance template and help getting your file ready. If the page will not open for you, Support can run it for you.

Tips

  • * Start with the template. Most stopped imports come from a file that does not match the format you picked.
  • * Keep one row per person. In the Row-Per-Person format, everyone in the same family shares the same Family ID.
  • * Do not delete the header row. It is how SteepleMate knows the file is in the right format.
  • * Need help? Contact Support. We can map the data and import it for you.