Follow

Export Data

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

  • Object you want to export
  • Date range

Optionally you can also add filters on

  • Project
  • Site

The format of the export is CSV file that will be downloaded to your download folder set in your browser.

Screenshot_2020-02-26_at_15.16.42.png

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 stroings not having characters such as æ, ø, å, ö, ä and ü being shown properly. But it is easily solved by importing the file rather than opening it.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk