This is a Professional Plan only feature - to upgrade see https://donorfy.com/pricing
Excel will retrieve data via the Donorfy Data Service, to use the data service you will need to find your System API key - see this article for help with that.
To use this feature your Donorfy sign-in needs access to the Donorfy Data Service - see this article for help managing user permissions.
You can use Excel to analyse or create visualisations based on your data by connecting Excel to the Donorfy Data Service.
The Donorfy data service uses OData to provide data to Excel - depending on the version of Excel you have you may need to download a plugin from the Microsoft website to allow Excel to work with OData.
Your link to the Donorfy Data Service will be https://data.donorfy.com/odata/<your api key> e.g. if your api key was abcdefgh your link would be https://data.donorfy.com/odata/abcdefgh
From the Data tab in Excel choose 'From Other Sources' in 'Get External Data' section, from the list displayed choose 'From Odata Data Feed'
From the Data Connection Wizard enter the link to Donorfy data service and enter your user name and password
Next, you will have to select the data sources (tables) you want to work with,
Once you have done that you can then create tables, charts and pivot tables
Errors Reading Data
Occasionally we have encountered error messages opening oData feeds from the Data tab in Excel similar to the example below
These appear to be caused by the way Excel samples the data - the only workarounds we have found are to
- Install Power Query into Excel and use that to read in the data
- For users of Office 365, Excel 16 or 19, you can use Get & Transform - see Microsoft support article
- Use an alternative tool - such as Power BI
The underlying connection was closed error message:
TLS 1.2 is used and if the registry file is not enabled on your computer the connection will fail.
The following link is extremely helpful, It contains the details of the registry files to add, enable and disable: https://support.convercent.com/hc/en-us/articles/360029441831-Microsoft-Excel-and-TLS-1-0-Deprecation-Notice
If TLS 1.2 is required, please ask your organisation's IT person to enable it for you.