---
title: The City
description: How to export Group Participants data from The City
---

[Skip to content](https://help.churchteams.com/knowledge/how-to-export-the-city-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)

# The City

## How to export Group Participants data from The City

As a group administrator, you have the ability to export CSV files of all the online or offline users from any group. The export file this process creates contains most data associated with the users in your City. This makes it helpful in situations that require you to have a complete list of personal information for the people of your church.

 

**To create a CSV list of active group participants (online users)**

1. In the admin panel, expand the **Admin**
2. Click **Groups**.
3. Using either the **Tree View**or the **Search for a group** field, find the group you want to edit.
4. Click **View Participants**.
5. Under the **Participant Reports**section, click **Export Active and Inactive Participants to CSV**.
6. At the bottom of the report queue, click **Refresh**.
7. When it becomes available, click **CSV**link and download the file. If you use Firefox, left-click to open the file. If you use Chrome, Safari or Internet Explorer, right-click and download the file.

 

**To create a CSV list of offline group participants (offline users)**

1. In the admin panel, expand the **Admin**
2. Click **Groups**.
3. Using either the **Tree View**or the **Search for a group** field, find the group you want to edit.
4. Click **View Participants**, then click the**Offline Participants **
5. Under the **Participant Reports**section, click **Export Offline Participants to CSV**.
6. At the bottom of the report queue, click **Refresh**.
7. When it becomes available, click **CSV**link and download the file. If you use Firefox, left-click to open the file. If you use Chrome, Safari or Internet Explorer, right-click and download the file.

 

Data Fields Definitions

The chart below provides definitions for the data fields included in the CSV export.

| Item | Definition |
| --- | --- |
| ID | The unique number for this user’s City account |
| Title | Displays any title assigned to the user |
| First | First name |
| Middle | Middle name |
| Last | Last name |
| Preferred\_Name | Preferred name |
| Email | Email address |
| Email\_Bounced | *Yes* indicates the user is having trouble receiving City emails |
| Primary\_Phone | The user’s primary phone number |
| Primary\_Phone\_Type | Whether the primary phone is a *home*, *work*, or *mobile* number |
| Secondary\_Phone | The user’s secondary phone number |
| Secondary\_Phone\_Type | Whether the secondary phone is a *home*, *work*, or *mobile* number |
| Address\_ID | A back-end identification number of the user’s first listed address |
| Street | The street number of the user’s first listed address |
| Street2 | The second line of the user’s first listed address, if used |
| City | The city of the user’s first listed address |
| State | The state of the user’s first listed address |
| Zipcode | The ZIP code of the user’s first listed address |
| Location\_Type | The type of location (*home*, *work*, or *mailing*) associated with that address |
| Birthdate | When the user was born |
| Gender | user’s gender |
| Primary\_Campus | The primary campus selected by the user |
| Type | Whether the user is offline (*OfflineUser*) or online (*User*) |
| Head\_of\_Household | Whether or not this user is the head of a family unit (this includes single people), for financial purposes |
| Family\_ID | The back-end identification number for the user’s family |
| Family\_Role | Which family role is held by the user (*Spouse*, *Child*, or *Other*) |
| Active | Whetherthe user has been deactivated (all offline users are listed as *active*) |
| user | The user’s official memebership status |
| user\_Since | The date the user became a member |
| Is\_On\_Staff | *Yes* indicates someone who is marked as being on staff at the church |
| External\_ID\_1 | user identification number associated with any other system your church uses (this can be renamed by an account administrator) |
| External\_ID\_2 | Customizable information field that can be renamed by an account administrator |
| External\_ID\_3 | Customizable information field that can be renamed by an account administrator |
| In\_Community\_Group | *Yes *indicates the user is in a group of the Community type (renaming that type will change this column heading) |
| In\_Service\_Group | *Yes *indicates the user is in a group of the Service type (renaming that type will change this column heading) |
| In\_Connect\_Group | *Yes *indicates the user is in a group of the Connect type (renaming that type will change this column heading) |
| In\_Campus | *Yes *indicates the user is in a group of the Campus type (renaming that type will change this column heading) |
| Created\_At | When the user’s account was made |
| Last\_Engaged | When the user was last engaged in The City |
| Contact\_Updated\_At | When the user’s contact information was last updated |
| Role\_In\_Group | The user’s group role in the group you exported (people who are inactive in the group show up as blank) |
| Marital\_Status | The user’s declared martial status (not related to whether or not their account is linked to a spouse) |
| Custom Fields | Up to 20 additional fields custom made by your account administrator |
| Flagged\_As\_Potential\_Duplicate | *Yes* indicates this user appears in the Duplicates tool as a possible duplicate profile |
| Group\_ID | The number of the group that you exported this list from |
| Group\_Name | The name of the group that you exported this list from |
| Group\_Type | The type of the group that you exported this list from |

- [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