---
title: Fellowship One
description: How to export data from Fellowship One
---

[Skip to content](https://help.churchteams.com/knowledge/how-to-export-fellowship-one-information-to-a-csv-file-for-importing-into-churchteams#main-content)

English

Show submenu for translations

[More support](https://help.churchteams.com/knowledge/kb-tickets/new?hsLang=en)

![Churchteams Logo](https://help.churchteams.com/hs-fs/hubfs/CT%20Churchteams%20Logo.png?width=320&height=62&name=CT%20Churchteams%20Logo.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [More support](https://help.churchteams.com/knowledge/kb-tickets/new)
- [Contact us](https://go.churchteams.com/contact/)

[Contact us](https://go.churchteams.com/contact/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://help.churchteams.com/knowledge?hsLang=en)
2. [Getting Started](https://help.churchteams.com/knowledge/getting-started?hsLang=en)
3. [People Setup and Data Conversion](https://help.churchteams.com/knowledge/getting-started?hsLang=en#people-setup-and-data-conversion)

# Fellowship One

## How to export data from Fellowship One

Due to possible version differences, we have included two variations of export instructions for both People and Contributions.  If neither work for your configuration, please contact the vendor for assistance. 

### People Data

** Version 1**

1. Click on reports
2. Type P9400 in the search window on the top right of the page
3. For all the group fields: ***“Ignore This”***
4. For choose fields to display:

–  Household Fields; ***“Household ID” ***and ***“Home Phone”***

–  Individual Fields;  “***Select all fields”***

1. Output Separated Email Columns? ***“YES”***
2. Output Separated Phone Columns? ***“YES”***
3. Display this1stAddress; ***“Primary” ***this will populate the next pull down
4. Display these Fields for each Address; “***Select all except full address”***
5. Note:  F1 will exclude Deceased individuals by default, so look for a setting and potentially change it so that deceased individuals are included in the export.  Check Status/SubStatus (who): ***Having these Status Group: Statuses: Select All including Deceased***
6. Choose an Output Type; ***“Excel”***
7. Click “Run Report”
8. When the report is complete download the file to your computer
9. Open in Excel and Save As a CSV file. (if more than one row is left for the headers remove all rows that are column headers except for the firstrow.
10. Send the file to data@churchteams.com and we will review it and load it for you or ask any questions needed to clarify how it should be loaded.

** Version 2**

1. Go to Reports (far right on menu bar).
2. Search for **P9400** (Core People Records Export v3.2) in top black bar search box.
3. Enter in the following criteria: 
     1. Return People in these Groups (who): 
            - Based on their Role/Type -\> **Don't Limit People Base on Group Membership**
            - These Spans of Care -\> **Ignore This**
            - These Group Types -\> **Ignore This**
            - These Campuses -\> **Ignore This**
            - These Groups -\> **Ignore This**
     2. Group Membership Instructions: -\> **Return People in ANY Selected Group**
     3. And Joined within this Time Period -\> **Ignore This**
     4. Choose Fields to Display (what):
     5. Output Separate Email Columns: **Yes**
     6. Output Separate Phone Columns: **Yes**
     7. Display this 1st Address -\> **Primary**
     8. Display this 2nd Address -\> **Ignore** **This**
     9. Display these Fields for each Address:
     10. If displaying Full Address, Format it using **1 Line**.
     11. Configure Output (what):
     12. Click additional filters.
     13. Return based on Status/SubStatus (who):
     14. Display Field Formatting (what):
4. **Run Report**
5. Click on the **Queue** link (top black bar) and when your report is ready, download it to your computer.

### **Contributions**

**Version 1**

- Run the G1050 Core Giving Records report (v 3.0)
- Under Return Giving Records
- Based on this date: Received Date
- Occurring with this date range: Custom Date Range and enter appropriate range
- Occurring on or after this time: -- Ignore this --
- Occurring on or before this time: -- Ignore this --
- Belonging to these batches: -- Do not filter --
- Configured Displayed Output
- Page/Sheet Break On: -- Ignore this --
- SubGroup with Subtotal on: -- Ignore this --
- Giving Fields to Display
- Select all EXCEPT the "All transactions by ID"
- Contributor Fields to Display
- ContributorID
- ContributorName
- GivingUnitID
- GivingUnitName
- GivingUnitContact
- Household, Individual or Organization
- Primary Address Fields to Display
- select all of them
- Grand Total Columns to Display: -- Ignore this --
- Sort Records by: Last Name, First Name, Received Date
- Create Labels/Temporary Group Using: -- I am NOT outputting to labels or groups --
- Choose an Output Type: CSV
- Click Run Report and once the report is Complete click the download link to save the file

**Version 2**

1. Go to Reports (far right on menu bar).
2. Search for **G1050** (Core Giving Records v 3.0).
3. Set the following criteria for Return Giving Records (who): 
     1. Based on this date -\> **Received Date**
     2. Week starts on -\> **Sunday**
     3. Occurring within this Date Range -\> **Custom Date Range**
     4. Occurring after this time: **Ignore** **This** (has to be done or report will error)
     5. Occurring before this time: **Ignore** **This** (has to be done or report will error)
     6. Belonging to Batches -\> **Ignore** **This** (has to be done or report will error)
4. Set the following criteria for choosing fields and configuring the output: 
     1. Page/Sheet ... -\> **Ignore** **This**
     2. Subgroup with Subtotal on -\> **Ignore** **This**
     3. Multi Select Box -\> Gift Columns to Display: 
            - **All Trans by ID**
            - **ACH, Check, Cash, BankCard**
            - **Batch Date**
            - **Batch Name**
            - **Contribution or Receipt**
            - **Contribution Attributes**
            - **Contribution Subtype**
            - **Create Date**
            - **Fund**
            - **Fund account Reference description**
            - **Memo**
            - **Received Date**
            - **Reference (check number)**
            - **Sub Fund**
     4. Multi select box -\> Contributor Columns to Display: 
            - **Contributor ID**
            - **Contributor Full Name**
            - **Contributor Last Name**
            - **Giving Unit ID**
            - **Giving Unit Full Name**
            - **Giving Unit Last Name**
            - **Household, Individual or Organization **(needed to get the correct name)
            - **Mem/Envelope #**
     5. Multi select box -\> Primary Address columns to Display 
            - **Ignore**
     6. Multi select box -\> Grand Total Columns to Display 
            - **Ignore**
5. Display total amount -\> **Yes**
6. Sort Records by **Received Date & Time**
7. Output to labels -\> **No**
8. Choose an Output Type: -\> **Excel**
9. **Run Report**
10. Click on the **Queue** link (top black bar) and when your report is ready, download it to your computer.

 

- [Getting Started](https://help.churchteams.com/knowledge/getting-started?hsLang=en#main-content)

    - [Resources](https://help.churchteams.com/knowledge/getting-started?hsLang=en#resources)
    - [People Setup and Data Conversion](https://help.churchteams.com/knowledge/getting-started?hsLang=en#people-setup-and-data-conversion)
    - [Post-Conversion FAQs](https://help.churchteams.com/knowledge/getting-started?hsLang=en#post-conversion-faqs)
- [People](https://help.churchteams.com/knowledge/people?hsLang=en#main-content)

    - [General](https://help.churchteams.com/knowledge/people?hsLang=en#general)
    - [Settings](https://help.churchteams.com/knowledge/people?hsLang=en#settings)
    - [Security](https://help.churchteams.com/knowledge/people?hsLang=en#security)
    - [Family/Household](https://help.churchteams.com/knowledge/people?hsLang=en#family-household)
    - [Directory](https://help.churchteams.com/knowledge/people?hsLang=en#directory)
    - [Merging](https://help.churchteams.com/knowledge/people?hsLang=en#merging)
    - [Notes](https://help.churchteams.com/knowledge/people?hsLang=en#notes)
- [Groups](https://help.churchteams.com/knowledge/groups?hsLang=en#main-content)

    - [Organization](https://help.churchteams.com/knowledge/groups?hsLang=en#organization)
    - [Groups: Settings](https://help.churchteams.com/knowledge/groups?hsLang=en#groups-settings)
    - [Attendance](https://help.churchteams.com/knowledge/groups?hsLang=en#attendance)
- [Communicate](https://help.churchteams.com/knowledge/communicate?hsLang=en#main-content)

    - [Member App](https://help.churchteams.com/knowledge/communicate?hsLang=en#member-app)
    - [Website Integration](https://help.churchteams.com/knowledge/communicate?hsLang=en#website-integration)
    - [Mailing Labels](https://help.churchteams.com/knowledge/communicate?hsLang=en#mailing-labels)
    - [Email](https://help.churchteams.com/knowledge/communicate?hsLang=en#email)
    - [Text-To-Church](https://help.churchteams.com/knowledge/communicate?hsLang=en#text-to-church)
    - [Content Pages & Tap Tags](https://help.churchteams.com/knowledge/communicate?hsLang=en#content-pages-tap-tags)
- [Giving](https://help.churchteams.com/knowledge/giving?hsLang=en#main-content)

    - [General](https://help.churchteams.com/knowledge/giving?hsLang=en#general)
    - [Pledge Tracking](https://help.churchteams.com/knowledge/giving?hsLang=en#pledge-tracking)
    - [Setup](https://help.churchteams.com/knowledge/giving?hsLang=en#setup)
    - [Contribution Statements](https://help.churchteams.com/knowledge/giving?hsLang=en#contribution-statements)
    - [Online Giving](https://help.churchteams.com/knowledge/giving?hsLang=en#online-giving)
    - [Batches](https://help.churchteams.com/knowledge/giving?hsLang=en#batches)
- [Check-in](https://help.churchteams.com/knowledge/check-in?hsLang=en#main-content)

    - [Text-to-Check-in](https://help.churchteams.com/knowledge/check-in?hsLang=en#text-to-check-in)
    - [Tablets](https://help.churchteams.com/knowledge/check-in?hsLang=en#tablets)
    - [Views/Settings](https://help.churchteams.com/knowledge/check-in?hsLang=en#views-settings)
    - [Setup](https://help.churchteams.com/knowledge/check-in?hsLang=en#setup)
    - [Troubleshooting](https://help.churchteams.com/knowledge/check-in?hsLang=en#troubleshooting)
    - [General](https://help.churchteams.com/knowledge/check-in?hsLang=en#general)
- [Event Registration](https://help.churchteams.com/knowledge/event-registration?hsLang=en#main-content)

    - [Registration Attributes](https://help.churchteams.com/knowledge/event-registration?hsLang=en#registration-attributes)
    - [Settings](https://help.churchteams.com/knowledge/event-registration?hsLang=en#settings)
    - [Website Integration](https://help.churchteams.com/knowledge/event-registration?hsLang=en#website-integration)
    - [Fairs](https://help.churchteams.com/knowledge/event-registration?hsLang=en#fairs)
- [Volunteers](https://help.churchteams.com/knowledge/volunteers?hsLang=en)
- [Reports](https://help.churchteams.com/knowledge/reports?hsLang=en#main-content)

    - [Members](https://help.churchteams.com/knowledge/reports?hsLang=en#members)
    - [General](https://help.churchteams.com/knowledge/reports?hsLang=en#general)
    - [Financial](https://help.churchteams.com/knowledge/reports?hsLang=en#financial)
    - [Groups](https://help.churchteams.com/knowledge/reports?hsLang=en#groups)
- [Settings](https://help.churchteams.com/knowledge/settings?hsLang=en#main-content)

    - [Account Information](https://help.churchteams.com/knowledge/settings?hsLang=en#account-information)
    - [Accessibility](https://help.churchteams.com/knowledge/settings?hsLang=en#accessibility)
    - [Notifications](https://help.churchteams.com/knowledge/settings?hsLang=en#notifications)
    - [User Accounts](https://help.churchteams.com/knowledge/settings?hsLang=en#user-accounts)
- [Assimilation / Workflow Automation](https://help.churchteams.com/knowledge/assimilation-workflow-automation?hsLang=en#main-content)

    - [Saved and Scheduled Reports](https://help.churchteams.com/knowledge/assimilation-workflow-automation?hsLang=en#saved-and-scheduled-reports)
    - [Workflow](https://help.churchteams.com/knowledge/assimilation-workflow-automation?hsLang=en#workflow)
- [Sales](https://help.churchteams.com/knowledge/sales?hsLang=en#main-content)

    - [Software Upgrades](https://help.churchteams.com/knowledge/sales?hsLang=en#software-upgrades)
- [GrowthFinder](https://help.churchteams.com/knowledge/growthfinder?hsLang=en)
- [Account Info](https://help.churchteams.com/knowledge/account-info?hsLang=en#main-content)

    - [Security](https://help.churchteams.com/knowledge/account-info?hsLang=en#security)

[![CT Churchteams Logo](https://help.churchteams.com/hs-fs/hubfs/CT%20Churchteams%20Logo.png?width=380&height=74&name=CT%20Churchteams%20Logo.png "CT Churchteams Logo")](http://go.churchteams.com)

Copyright © 2025, Churchteams