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