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.
In order to export you will have to select
- Object you want to export
- Date range
Optionally you can also add filters on
The format of the export is CSV file that will be downloaded to your download folder set in your browser.
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 stroings not having characters such as æ, ø, å, ö, ä and ü being shown properly. But it is easily solved by importing the file rather than opening it.