--- title: Community Export Member Data description: Community Export Member Data --- [Skip to content](https://help.ideascale.com/community-export-member-data-new-community-settings#main-content) English Show submenu for translations [![IdeaScale](https://help.ideascale.com/hs-fs/hubfs/ideascale-logo.png?width=223&height=31&name=ideascale-logo.png)](https://help.ideascale.com/?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [Go to ideascale.com](https://ideascale.com/) [Go to ideascale.com](https://ideascale.com/) Hi!👋 How can we help you today? - There are no suggestions because the search field is empty. 1. [IdeaScale Support Center](https://help.ideascale.com/?hsLang=en) 2. [Community Settings - Data](https://help.ideascale.com/community-settings-data?hsLang=en) 3. [Export Data](https://help.ideascale.com/community-settings-data?hsLang=en#export-data) # Community Export Member Data ## Export Member Data on Community level ***Path: Workspace Homepage >> Navigation Panel >> Settings >> Community >> Data >> Export Data >> Member Data*** | What is Community Export Member Data? | | --- | | Community Export Member Data is a reporting feature that allows quick download of member registration and activity information for a community. | Community Administrators can get quick information on members registered with the community by downloading member data reports. Additional information on leaderboard points and Community Roles (if configured in the community) can be exported along with the Member Data report. --- ### Role Permissions 1. **Community Administrator:** Configures and downloads Member Data exports for the community. --- **TABLE OF CONTENTS** Export Settings [Excel Sheet Fields](https://help.ideascale.com/community-export-member-data-new-community-settings#ExcelSheetFields) [Community-Level Fields](https://help.ideascale.com/community-export-member-data-new-community-settings#Community-LevelFields) [Campaign-Level Fields](https://help.ideascale.com/community-export-member-data-new-community-settings#Campaign-LevelFields) [Exceptions](https://help.ideascale.com/community-export-member-data-new-community-settings#Exceptions) [Frequently Asked Questions](https://help.ideascale.com/community-export-member-data-new-community-settings#FrequentlyAskedQuestions) --- ### Export Settings The following settings are available when configuring a Member Data export: 1. Export Format: Member data can be exported in either of the following formats: 1. Microsoft Excel sheet (.xls) format. 2. CSV format. 2. Include Groups in Export: Switch this setting on to include the groups a member belongs to in the exported data. 3. Filter by Date Range: Leave this switch disabled to export all data from the beginning up to the current date. Enable the switch and specify a start date and an end date to export data for a specific time period instead. 4. Timezone: Select a preferred timezone for viewing the exported data, rather than defaulting to the community's timezone. --- ### Excel Sheet Fields The exported Excel sheet contains a community-level summary along with separate sheets for the member breakdown per campaign. ### Community-Level Fields The community-level sheet contains the following fields: 1. Member ID: The unique identifier assigned to the member. 2. Email Address: The member's registered email address. See Exceptions below for identity-hidden members. 3. Username: The member's username. 4. Name: The member's display name. See Exceptions below for identity-hidden members. 5. Member Since: The date the member joined the community. 6. Last Successful Login Date and Time: The date and time of the member's most recent successful login. 7. Source: How the member's account originated — Admin (added by the workspace or community owner), Upload (invited by an administrator), or Web (registered directly through the community website). 8. Status: The member's current standing in the community, in Member status/Member Email status format — Member, Invited, Yet to Join, or Banned combined with a status such as verified or sent (for example, member/verified or member/sent). 9. Ideas: The number of ideas submitted by the member. 10. Votes: The number of votes cast by the member. 11. Comments: The number of comments made by the member. 12. TOS Accepted: Whether the member has accepted the Terms of Service — Yes or No. 13. TOS Accepted Date: The date the Terms of Service were accepted. 14. Group Based Moderation: The member's group-based moderation standing. 15. Groups: The groups the member belongs to. Included only when Include Groups in Export is enabled. 16. Member Profile Questions: The member's responses to community profile questions. ![Screenshot 2025-07-25 at 10-19-26 AM-png copy](https://help.ideascale.com/hs-fs/hubfs/Screenshot%202025-07-25%20at%2010-19-26%20AM-png%20copy.jpg?width=670&height=227&name=Screenshot%202025-07-25%20at%2010-19-26%20AM-png%20copy.jpg) --- ### Campaign-Level Fields Each campaign-specific sheet contains the following fields: 1. Member ID: The unique identifier assigned to the member. 2. Email Address: The member's registered email address. See Exceptions below for identity-hidden members. 3. Username: The member's username. 4. Name: The member's display name. See Exceptions below for identity-hidden members. 5. Member Since: The date the member joined the community. 6. Last Successful Login Date and Time: The date and time of the member's most recent successful login. 7. Source: How the member's account originated — Upload (invited by an administrator) or Web (registered directly through the community website). 8. Status: The member's current standing, in Member status/Member Email status format. 9. Ideas: The number of ideas submitted by the member within the campaign. 10. Votes: The number of votes cast by the member within the campaign. 11. Comments: The number of comments made by the member within the campaign. 12. TOS Accepted: Whether the member has accepted the Terms of Service — Yes or No. 13. TOS Accepted Date: The date the Terms of Service were accepted. ***Note: 1. Source = Admin means the members in the workspace/community owner; Source=Upload means the administration invited user through the community; Source=Web means the user registered from the community website.*** ***2. The status column in the report is in Member status/Member Email status format. For e.g. member/verified;member/sent.*** ![Screenshot 2025-07-25 at 10-25-13 AM-png copy](https://help.ideascale.com/hs-fs/hubfs/Screenshot%202025-07-25%20at%2010-25-13%20AM-png%20copy.jpg?width=670&height=294&name=Screenshot%202025-07-25%20at%2010-25-13%20AM-png%20copy.jpg) --- ### Exceptions 1. Hide My Identity Enabled: If the community setting Hide My Identity is enabled and a member has chosen to keep their identity hidden, that member's Name appears in the export as "Community Member," and their Email Address is hidden. --- ### Frequently Asked Questions #### What is the difference between the community-level sheet and the campaign-level sheets in the export? The community-level sheet summarizes a member's activity and details across the entire community, while each campaign-level sheet breaks that same member's activity down individually per campaign. #### Why does a member's Source show as Admin, Upload, or Web? Source reflects how the member's account originated: Admin means the member is the workspace or community owner, Upload means an administrator invited the member into the community, and Web means the member registered directly through the community website. Note: campaign-level sheets do not include Admin as a Source value. #### Can groups be excluded from the export? Yes. Groups only appear on the community-level sheet when Include Groups in Export is switched on. Leaving the switch off excludes group data from the export. --- **Related Articles** - [Help Article for Export Data ](https://help.ideascale.com/export-data-overview?hsLang=en) - [Help Article for Erase Community Data](https://help.ideascale.com/erase-data?hsLang=en)   Last Updated: August 2, 2026   - [Product Updates](https://help.ideascale.com/product-updates?hsLang=en#main-content) - [2026](https://help.ideascale.com/product-updates?hsLang=en#2026) - [2025](https://help.ideascale.com/product-updates?hsLang=en#2025) - [Workspace](https://help.ideascale.com/workspace?hsLang=en#main-content) - [Workspace Homepage](https://help.ideascale.com/workspace?hsLang=en#workspace-homepage) - [Manage Workspace](https://help.ideascale.com/manage-workspace?hsLang=en#main-content) - [Workspace Configuration](https://help.ideascale.com/manage-workspace?hsLang=en#workspace-configuration) - [Email Settings](https://help.ideascale.com/manage-workspace?hsLang=en#email-settings) - [Security](https://help.ideascale.com/manage-workspace?hsLang=en#security) - [Data](https://help.ideascale.com/manage-workspace?hsLang=en#data) - [Campaign Management](https://help.ideascale.com/campaign-management?hsLang=en#main-content) - [Campaigns](https://help.ideascale.com/campaign-management?hsLang=en#campaigns) - [Workflow](https://help.ideascale.com/campaign-management?hsLang=en#workflow) - [Team Roles](https://help.ideascale.com/campaign-management?hsLang=en#team-roles) - [IdeaScale AI](https://help.ideascale.com/ideascale-ai?hsLang=en) - [IdeaScale Whiteboard](https://help.ideascale.com/ideascale-whiteboard?hsLang=en#main-content) - [Facilitator Guides](https://help.ideascale.com/ideascale-whiteboard?hsLang=en#facilitator-guides) - [Best Practices](https://help.ideascale.com/best-practices?hsLang=en#main-content) - [FAQs](https://help.ideascale.com/best-practices?hsLang=en#faqs) - [New User Guides](https://help.ideascale.com/new-user-guides?hsLang=en#main-content) - [Starter Guide](https://help.ideascale.com/new-user-guides?hsLang=en#starter-guide) - [Registration, Password & Authentication, New Users](https://help.ideascale.com/new-user-guides?hsLang=en#registration-password-authentication-new-users) - [Participation](https://help.ideascale.com/new-user-guides?hsLang=en#participation) - [Notifications](https://help.ideascale.com/new-user-guides?hsLang=en#notifications) - [Personal Settings](https://help.ideascale.com/personal-settings?hsLang=en#main-content) - [Email, Services & Devices](https://help.ideascale.com/personal-settings?hsLang=en#email-services-devices) - [Your Communities & Notifications](https://help.ideascale.com/personal-settings?hsLang=en#your-communities-notifications) - [Messages](https://help.ideascale.com/personal-settings?hsLang=en#messages) - [Reporting](https://help.ideascale.com/reporting?hsLang=en) - [Idea Portfolio](https://help.ideascale.com/idea-portfolio?hsLang=en) - [Moderator Dashboard](https://help.ideascale.com/moderator-dashboard?hsLang=en) - [Member Management](https://help.ideascale.com/member-management?hsLang=en#main-content) - [Administrators](https://help.ideascale.com/member-management?hsLang=en#administrators) - [Custom Admin](https://help.ideascale.com/member-management?hsLang=en#custom-admin) - [Members](https://help.ideascale.com/member-management?hsLang=en#members) - [Moderators](https://help.ideascale.com/member-management?hsLang=en#moderators) - [Groups](https://help.ideascale.com/member-management?hsLang=en#groups) - [Community Overview](https://help.ideascale.com/community-overview?hsLang=en) - [Community Settings - Community Configuration](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#main-content) - [Community Info](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#community-info) - [Profile Questions](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#profile-questions) - [Tags](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#tags) - [Labels](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#labels) - [Strings](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#strings) - [Landing Pages](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#landing-pages) - [Custom Pages](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#custom-pages) - [Footer](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#footer) - [File Library](https://help.ideascale.com/community-settings-community-configuration?hsLang=en#file-library) - [Community Settings - Email Settings](https://help.ideascale.com/community-settings-email-settings?hsLang=en#main-content) - [General](https://help.ideascale.com/community-settings-email-settings?hsLang=en#general) - [Notifications](https://help.ideascale.com/community-settings-email-settings?hsLang=en#notifications) - [Broadcast Emails](https://help.ideascale.com/community-settings-email-settings?hsLang=en#broadcast-emails) - [Idea Inactivity Emails](https://help.ideascale.com/community-settings-email-settings?hsLang=en#idea-inactivity-emails) - [Email Logs](https://help.ideascale.com/community-settings-email-settings?hsLang=en#email-logs) - [Community Settings - Automation](https://help.ideascale.com/community-settings-automation?hsLang=en) - [Community Settings - Community Access](https://help.ideascale.com/community-settings-community-access?hsLang=en) - [Community Settings - Integrations](https://help.ideascale.com/community-settings-integrations?hsLang=en#main-content) - [App Directory](https://help.ideascale.com/community-settings-integrations?hsLang=en#app-directory) - [Developer API](https://help.ideascale.com/community-settings-integrations?hsLang=en#developer-api) - [Community Settings - Data](https://help.ideascale.com/community-settings-data?hsLang=en#main-content) - [Export Data](https://help.ideascale.com/community-settings-data?hsLang=en#export-data) - [Import Data](https://help.ideascale.com/community-settings-data?hsLang=en#import-data) - [Erase Community Data](https://help.ideascale.com/community-settings-data?hsLang=en#erase-community-data) - [Government](https://help.ideascale.com/government?hsLang=en) - [Policies & Notices](https://help.ideascale.com/policies-notices?hsLang=en) - [Community Settings - Logs](https://help.ideascale.com/community-settings-logs?hsLang=en) [![Chill listening crop-3](https://help.ideascale.com/hs-fs/hubfs/Icon_V2-1.png?width=24&height=24&name=Icon_V2-1.png "Chill listening crop-3")](http://ideascale.com) IdeaScale's Help Center Copyright © 2026, IdeaScale