Data Export

With the implementation of the new Dashboard interface, we are currently in the process of updating our documentation and some pages may be out of date. Thank you for your patience. Please contact 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:

Last updated

Ⓒ Open Collective 2024