Importing From Power Church

Below are the steps to export member data from Power Church:

Navigate to Membership menu at the top, highlight Personal Profiles, then Other Output and select Export Data
Selection Criteria:
- Select OK
Introduction:

Select OK

What fields would you like to export:

Select the >> button to select all fields
Make sure you include envelope or member number, if you record donations with that information at your church
Select Next

The type of export file format would you like to create:

Select Excel 5
Select Next

What would you like to name the export file:

Select Location
Select where you want to save your file and give your file a name
Select Next

Select Finish

Please arrange the column layout according to our requirements as outlined in this article or check out our import template. Attach it to a support ticket, and we'll perform the import for you.

How to Format the File

The FIRST NAME (A), LAST NAME (B), and FAMILY NAME (C) columns are required. Do not leave any of these fields blank.

The format for FAMILY NAME (C) should be “LASTNAME, Husband and Wife”. This is how the family's name will be displayed when you run reports per family in the People Screen, including the member directory and photo directory. This is also how the system will format new names so you want to be consistent throughout your database.

This is a shared data field among all family members so put that same info for the spouse and children. So for example, you would enter for all family members: SMITH, John and Sally

FORMAL NAME (M) is recommended as well, formatted "Mr. & Mrs. Husband Lastname", as it's what's used on contribution statements to address the family: Mr. & Mrs. John Smith

We grant one free spreadsheet import for your account. Going forward, you will enter new names on the People Screen. Please note that subsequent requests in the future for another spreadsheet import will incur a small fee, so make sure the initial file is as complete as possible.