Row-Per-Person Import Format Guide | SteepleMate

Data Import Guide: Row-Per-Person Format

  1. 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:

    • * Our team can do the import for you. Send your account manager the exported file from your previous system and allow an hour or two to map the data and import it.
    • * Importing needs Administrator or SuperUser access.

    Step-by-Step Guide

    Step 1: Download the template

    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.

    The Row-Per-Person box on the Import Members page, with the template link and upload button

    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.

    Step 2: Follow the row-per-person rules

    • * One row for each person. Every person gets their own row.
    • * Family ID ties a family together. Give each family its own number, starting with 1. Everyone in the same family gets the same number. The rows do not have to be next to each other, but keeping a family together is easier to check. A row with no Family ID becomes a family of its own.
    • * Start each family with the head of household. Each family should have one Head of Household. If none is marked, a spouse (or else another person in the family) becomes the head. If more than one is marked, only the first stays the head and the others are set to Unknown. When the head of household has no address or home phone, SteepleMate moves the family's address and home phone onto the head.
    • * Leave unknown things blank. Do not type "N/A" or "unknown" in a cell. Leave it empty.
    • * Dates use MM/DD/YYYY, for example 03/14/1985.
    • * Use the exact words shown below for codes and titles. A Mailing Title that is spelled differently, in a different case or with a period added (such as "Mr.") is not recognized and is left blank.

    Step 3: Fill in the columns

    The columns are in this order. The first four groups are the ones most churches need.

    People and families

    • A. Family ID: Your own number for the family, starting at 1. Same number for everyone in the family.
    • B. Anniversary Date: Only needed on the head of household or spouse. The first date found for a family is used.
    • C. Person ID: Leave blank unless your old system gave each person a number you want to keep for reference.
    • D. Person Type: Fill this in on every row. CF is Church Family (members and regular attendees), C is Contact (non-members and outside contacts), G is Guest and V is Vendor.
    • E. Member: Y or N. Y marks the person as an active member.
    • F. Member Date: The date the person became a member.
    • G. Family Role: Head of Household, Spouse, Child, Grandchild or Unknown. SteepleMate reads the first letter (H, S, C or G), so blank or anything else is Unknown.

    Names

    • H. Mailing Title: Mr, Mrs, Ms, Miss, Rev, Dr or Hon. Capital first letter, no period.
    • I. Church Title: Brother, Sister or Pastor. After your import, check the church title on a few people, and set any that are blank in Manage, then People.
    • J. Last Name and K. First Name: Required. Put the last name in J and the first name in K, in that order, and follow the column headings rather than the order of the names in the example rows. SteepleMate checks these two columns to be sure the file matches the template.
    • L. Middle Name and M. Suffix: Optional.

    Groups, address and contact details

    • N. Attendance Group: The name of an attendance group that already exists in your church, typed exactly as it appears, for example Attendance - Adults. To put someone in more than one group, separate the names with commas. A name that does not match an existing attendance group is skipped, so check your group names under Administration, then Manage Groups first.
    • O. Mailing Address, P. City, Q. State, R. Zip, S. Country: Put the street address (and apartment) in O. Put the address on the head of household: family members with the same address are not saved twice. If you give an address but leave city, state or zip blank, SteepleMate fills them in from your church's address. Addresses are saved as USA, so the Country column does not need to be filled in.
    • T. Cell Phone and U. Home Phone: The 10-digit number with area code. Leave blank if there is no number.
    • X. Email Address: Leave blank if the email is not known.

    Personal details

    • V. Gender: M or F. Anything else, including blank, is saved as Unspecified.
    • W. DOB: Date of birth.
    • AB. Marital Status: One letter: S Single, M Married, W Widowed, D Divorced, X Separated, U Unspecified. SteepleMate reads the first letter only, so use the letters. A word such as "Separated" would be read as S, which is Single.
    • Y. Attended Date: When the person first came. If blank, the day of the import is used.
    • Z. Visitor Letter Date: The date a visitor letter was sent, if you track it.
    • AA. Notes: Optional notes, up to 2,000 characters.
    • AC. Inactive Date: Leave blank for active people. A date marks the person inactive as of that date.
    • AD to AG: Baptism and Holy Ghost columns. They are optional. Leave them blank if your church does not track them.

    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.

    Step 4: Upload the file

    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.

    If your data comes from somewhere else

    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.

    The Planning Center box with its template link and upload button

    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.

    The Realm box with its sample link and upload button

    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.

    Tips

    • * Pick the matching format. Since release 369, an import stops without adding anyone if the file does not look like the format you chose.
    • * Check before you upload. Make sure the example rows are gone, the headings are still there, last name is in J and first name in K.
    • * Import once. If something looks wrong, contact Support before uploading the same file again.

Info

Need Help?

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.