🚨 This documentation is out of date.
View our New Documentation!
Open Collective Docs
Go back to Open Collective
  • Welcome
  • About
    • Introduction
    • Documentation
    • Terminology
    • Company
    • Pricing
    • Team
    • The Open Collective Way
      • Mission and Values
      • Community Guidelines
    • Hiring
    • Investors
    • Contributing
    • Refund Policy
    • Contact Us
  • Product
    • Features
    • Roadmap
    • Comparison
    • User Profile
    • Dashboard
      • Preview Features
    • Currencies
    • Log-in System
    • Privacy Policy
    • Moderation
    • Security
    • Ledger
      • Individual Transactions
      • Transaction Pairs, Groups & Perspectives
      • Viewing Transactions
      • Exporting Transactions
      • Fiscal Host Ledger Perspective
      • Contributions in the Ledger
      • Added Funds in the Ledger
      • Expenses in the Ledger
      • Ledger Changelog
    • Notifications
    • Two-factor Authentication
    • Activity Log
  • Collectives
    • Collectives FAQ
    • Creating a Collective
    • Quick Start Guide
    • Collective Settings
      • Customize Collective
      • Team
      • Collective Goals & Tiers
      • Expense Policy
      • Data Export
      • Security
      • Integrations
      • Zero Collective Balance
      • Closing a Collective
    • Add Fiscal Host
    • Change Fiscal Host
    • Open Source Collectives
      • Setting up GitHub Sponsors
    • Transparent Budget
    • Expenses
    • Updates & Comms
    • Custom Email
    • Moderation
    • Conversations
    • Events
    • Projects
    • Funding Options
    • Buttons & Banners
    • Connected Collectives
    • Contribution flow
  • Financial Contributors
    • Financial Contributors FAQ
    • Guest contributions
    • Payments
    • Platform Tips
    • Website Badge
    • Receipts
    • Collective to Collective
    • Organizations
      • Organization FAQ
      • Funds
      • Bulk Transfers
      • Gift Cards
      • Sustainer Resources
  • Expenses & Getting Paid
    • Expenses FAQ
    • Submitting Expenses
      • Inviting a third-party to submit an Expense
    • Expense Comments
    • Edit or Download an Expense
    • Receiving payment through Payoneer or Wise
    • Tax Information
  • Fiscal Hosts
    • Fiscal Hosts FAQ
    • Becoming a Fiscal Host
    • Creating a Fiscal Host
    • Organisation Settings
      • Info
      • Customize Profile Page
      • Connect external accounts
      • Accounting Categories
      • Security
      • Manage updates
      • Policies
    • Fiscal Host Dashboard
      • Expenses
      • Financial contributions
      • Pending applications
      • Hosted Collectives
      • Vendors
      • Transaction Report
        • Reports
    • Receiving Money
      • Bank Transfers
      • Credit Card
      • Add Funds Manually
      • Expected Funds
    • Payouts
      • Virtual Card Settings
      • Payouts with PayPal
      • Payouts with Wise
      • Two-factor authentication for payouts
      • Refunds
    • Host Fees
    • Local Tax Support
    • Agreement Templates
  • Independent Collectives
    • About Independent Collectives
    • Create an Independent Collective
      • Migrate from Self-Hosted to Independent Collective
      • Migrate from a Fiscal Host to Independent Collective
    • Independent Collective Setup
    • Independent Collective Management
      • Money coming in: Contributions
      • Money going out: Expenses
    • Close an Independent Collective
  • Contributing
    • Design
      • Design Workflow
      • Design Contribution Guidelines
    • Development
      • Contribution Guide
      • Best Practice Guidelines
      • Bounties
      • Architecture
      • API
        • Members
        • Collectives
        • Events
      • README Integration
      • PayPal
      • TransferWise
      • Post-Donation Redirect
      • Manual Reporting
      • GitHub Permissions
      • Internationalization (i18n) system
      • Testing with Cypress
      • Testing features
        • Conversations
      • Collective's locations
      • Virtual Cards
    • Documentation
      • Resources for documentarians
      • Style guide
      • Suggesting changes
    • Translation
  • Developers
    • OAuth
    • Personal Tokens
Powered by GitBook

Helpful Links

  • Website
  • Blog
  • Contact
  • Slack

â’¸ Open Collective 2024

On this page
  • Contributor Information
  • Exporting Transactions
  • Export Settings

Was this helpful?

Edit on GitHub
Export as PDF
  1. Collectives
  2. Collective Settings

Data Export

PreviousExpense PolicyNextSecurity

Last updated 1 year ago

Was this helpful?

With the implementation of the new , we are currently in the process of updating our documentation and some pages may be out of date. Thank you for your patience. Please our support team if you need any assistance.

There are multiple ways to export your collectives data. Download your contributor data, Transactions information and delve into your export settings.

Contributor Information

Navigate to your collective's Dashboard -> Contributors.

Click on the Export CSV button in top right hand corner.

The CSV export contains:

  • Contributor Profile URL

  • Contributor Name

  • Contributor Type (Individual or Company)

  • Total Amount Contributed

  • Currency

  • Active Recurring Contribution

  • Recurring Contribution Tier

  • Recurring Contribution Amount

  • Recurring Contribution Frequency

  • First Contribution Date

  • Latest Contribution Date

  • Email

  • Website

Exporting Transactions

Head to the budget section on your collective page. Click the Transactions tab

2. Click View all Transactions

3. Apply any filters to the CSV export.

For example select expenses in the Kind type to export a CSV with your expense information.

4. Download CSV on the right

Export Settings

Navigate to your collective's dashboard -> Settings -> Export.

On this page, you can export your data into:

  • Contributor data CSV Export

  • JSON Export

  • Widgets

  • Badges

  • Contributors images

Export Contributors CSV

Download a file of all of your contributors, with these fields:

  • Member ID

  • Date Created

  • User Type (User or Organisation)

  • Role (Admin, Host, Backer, Follower)

  • Tier

  • Active Recurring Contribution

  • Total Amount Donated

  • Currency

  • Lastest Transaction Date

  • Lastest Transaction Amount

  • User Profile URL

  • Name

  • Company

  • Description

  • Image

  • Email

  • Newsletter Opt in

  • Twitter

  • Github

  • Website

Export JSON

Export your data to integrate with other applications.

Options:

  • All members (contributors of all types)

  • Only users (individuals)

  • Only organizations

Parameters:

  • limit: number of members to return

  • offset: number of members to skip (for paging)

  • TierId: only return the members that belong to this TierId. You can find the TierId as part of the URL after selecting a tier on your collective pag

Widget

Export an HTML script to use on your website, showing your financial contributors.

Export images

Badge

Create an SVG showing the number of financial contributors of your Collective. By updating the text in the URL, you can change the label and color.

Code:

https://opencollective.com/collective/tiers/backers/badge.svg?label=Backers&color=brightgreen

Result:

Contributor image

Create an SVG showing the icons of your financial contributors.

There are a range of options:

Parameter

Description

default

width

width of the image

height

height of the image

limit

max number of members to show

(unlimited)

avatarHeight

max height of each avatar / logo

button

show "become a backer/sponsor" button

true

format

format of the image (replace .svg with .png or .jpg)

Code:

<object type="image/svg+xml" data="https://opencollective.com/collective/tiers/backers.svg?avatarHeight=36&width=600"></object>

Result:

Dashboard interface
contact