How to Import Church Member Data Using Row-Per-Person Format in SteepleMate

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.

Important Notes:

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

  1. Family ID (Column A):

    • Each family should be numbered uniquely, starting from 1.
  2. Person Type (Column C):

    • Use the following codes to define each person's type:
      • CF: Church Family (members and regular attendees)
      • C: Contact (non-members or external contacts)
      • G: Guest
      • V: Vendor
  3. Family Role (Column F):

    • Define the role of each family member:
      • HOH: Head of Household
      • C: Child
      • G: Grandchild
      • S: Spouse

Contact Information:

  1. Mailing Title (Column G):
    • Use appropriate titles such as Miss, Mr, Mrs (note: do not include periods after titles).
  2. 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:

  1. 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.
  2. Email (Column T):
    • Leave this field blank if the email is unknown. No email communication will be sent without an email address.

Additional Information:

  1. Gender (Column R):

    • Use the following codes for gender:
      • F: Female
      • M: Male
      • U: Unspecified
  2. Marital Status (Column X):

    • Use the appropriate marital status:
      • Single
      • Married
      • Divorced
      • Unknown
      • Separated
      • Widowed

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:

  1. Login to SteepleMate
    Use your credentials to log in to your SteepleMate account.

  2. Go to the Administration Menu
    From the dashboard, click on the Administration Menu and select "Import Data".

    import church member data

  3. Select Import Row-Per-Person
    For this import type, choose the first option, "Import Row-Per-Person", to begin uploading your file.

    SteepleMate data import

  4. Download the Template
    To start formatting your information correctly.
    Import Church Member Data

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 ...
      • 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 ...
      • How to Expunge a Person’s Data in SteepleMate

        SteepleMate provides an option to permanently delete a person's data from the system. This action is designed to help comply with privacy laws such as the California Consumer Privacy Act (CCPA/CPRA) and the EU General Data Protection Regulation ...
      • How to Designate a Person as a Member in SteepleMate

        This guide will walk you through the process of marking someone as a member of your church in SteepleMate. While a person may already be categorized as “Church Family,” you can further specify their membership status and track the date they became a ...
      • Recent Articles

      • Export Contribution Statements in SteepleMate

        This guide will walk you through exporting contribution statements to PDF, XLSX, and image formats. While multiple file types are available, PDF and image formats are the most commonly used. Before You Begin Before exporting, ensure you have ...
      • How to Send Emails in SteepleMate

        This guide will walk you through using the email features in SteepleMate, including sending messages to individuals and groups. Composing a New Email Navigate to the Email Composer From the left navigation menu, select Communicate > Send Messages. ...
      • I accidentally deleted someone's profile. What can I recover?

        Can a deleted profile be recovered? Unfortunately, due to compliance requirements, once a profile has been expunged in SteepleMate, it cannot be recovered. This action is permanent and irreversible. Is any data retained after deletion? While the ...
      • How to Expunge a Person’s Data in SteepleMate

        SteepleMate provides an option to permanently delete a person's data from the system. This action is designed to help comply with privacy laws such as the California Consumer Privacy Act (CCPA/CPRA) and the EU General Data Protection Regulation ...
      • How to Connect Your QuickBooks Account to SteepleMate

        SteepleMate is the only cloud-based church management system certified by Intuit, offering a direct integration with QuickBooks Online. This integration allows you to post journal entries for online giving and in-person offerings directly to ...