In our data exporter you can export data on fundraiser and donations.
The donation data is the exact same as in the monthly reports, you just have the option here to define the time range yourself and also limit the data to either a specific site or project.
The fundraiser data you can export is documented here.
The exporter
In order to export you will have to select the:
- Object you want to export
- Date range
Optionally you can also add filters on the specific:
- Project
- Site
The format of the export is a CSV file that will be downloaded to your download folder set in your browser.
Number format
If you are a UK charity, the file is comma separated, with numbers formatted as 1,234.56
If you are a charity from any other European country, the file is semicolon separated, with numbers formatted as 1.234,56
Data encoding and issues in excel
The encoding of the file is UTF-8. So if you want to open the file in excel, it is advisable to use the import function in excel and select this encoding.
Excel does not recognise this encoding by itself, so just double clicking the file will result in text strings having characters such as æ, ø, å, ö, ä and ü not being shown properly. But this is easily solved by importing the file rather than opening it.