Data Import Guide: Row-Per-Person Format
We’re thrilled to have you on board. This guide will walk you through the process of importing your church member information. Follow these steps carefully, and you’ll be set up in no time.
- Family ID: Each family must have a unique ID, starting with 1.
- Head of Household (HOH): Always begin with the HOH for each family.
- Attendance Groups: Use the format "Attendance – GroupName" (e.g., Attendance – Adults).
- DO NOT DELETE HEADERS: Headers are essential for a successful import.
Step-by-Step Guide:
Family and Person Details:
Family ID (Column A):
- Each family should be numbered uniquely, starting from 1.
Person Type (Column C):
Family Role (Column F):
Contact Information:
Mailing Title (Column G):
- Use appropriate titles such as Miss, Mr, Mrs (note: do not include periods after titles).
Address (Columns L-N):
- Separate fields for street address, city, state, and zip code. Ensure the data is entered correctly to avoid issues in member communication.
Communication Details:
Cell Phone (Column P):
- Leave this field blank if no phone number is available. No text messages will be sent if the field is empty.
Email (Column T):
- Leave this field blank if the email is unknown. No email communication will be sent without an email address.
Additional Information:
Gender (Column R):
Marital Status (Column X):
Remove Example Rows:
- Rows 2-6 are examples in the Excel template. Make sure to delete these rows before importing to avoid errors.
Ready to Import?
Once your data is complete and formatted correctly, follow these steps:
Login to SteepleMate
Use your credentials to log in to your SteepleMate account.
Go to the Administration Menu
From the dashboard, click on the Administration Menu and select "Import Data".
Select Import Row-Per-Person
For this import type, choose the first option, "Import Row-Per-Person", to begin uploading your file.
Download the Template
To start formatting your information correctly.


Need Help?
If you run into any issues or have questions during the process, don’t hesitate to contact the SteepleMate Support team. 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.
Related Articles
Importing Data into SteepleMate
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 ...
Organization Settings in SteepleMate Free
Welcome to SteepleMate! This guide will walk you through the essential steps to set up your Organization Settings so your church can start using SteepleMate efficiently. If you need additional help, don’t hesitate to reach out to your Account ...
Checklist for Getting Started with SteepleMate Free
Welcome to SteepleMate! We're so glad you made it to SteepleMate! As you explore the system, you'll find many opportunities to fine-tune and configure settings to meet your needs. Getting Started Once you've created a SteepleMate account, we ...
How to Customize Date Fields in SteepleMate
SteepleMate now allows you to customize up to six date fields in member profiles. This feature gives your church flexibility in tracking key milestones such as baptism dates, first visits, membership anniversaries, and more. These fields can also be ...
Managing Web Kiosk Submissions
Audience: Church administrators using SteepleMate Free Focus: Reviewing and managing prayer requests, testimonies, and messages submitted through the Web Kiosk What Can Church Members Do? From the Web Kiosk, members can: Sign In for Prayer or Fasting ...
Recent Articles
Using a Different Online Giving Provider with Your SteepleMate Website
This article explains what you can and can’t change on your site, and how to share a third-party giving link with your church family. Do I Have to Use SteepleMate for Online Giving? No. You are not required to use SteepleMate online giving. Some ...
Why Do I See “We Seem to Have a Problem Verifying Your Internet Connection” on the Giving Page?
Overview When someone tries to give online through SteepleMate and sees a message about a problem verifying their internet connection, it usually means their connection is coming through: A VPN (Virtual Private Network) Certain types of public Wi-Fi ...
Can Online Giving Features Be Hidden in the SteepleMate System?
SteepleMate understands that not every church chooses to use online giving within the SteepleMate System. This preference is acceptable, and churches are free to determine the giving approach that best serves their congregation. A church’s decision ...
Why Church Website Images Can Get Cut Off
When updating your church website’s Home (Hero) section, it’s important to understand how responsive design works. Modern websites automatically adjust to fit different screen sizes, including: Desktop computers, Tablets, Mobile phones Because of ...
Connect Center (Web Kiosk) Customization
What is the Connect Center (Web Kiosk)? The Connect Center, also referred to as the Web Kiosk, is the web-based interface churches use to allow congregants to: Sign in for prayer or fasting Submit prayer requests or testimonies View announcements ...