Sample Excel File for API Connect to WA Make Available for Excel for MAC 
It seems that the Sample Excel file for importing data from Wild Apricot was developed in Excel for WIndows. The Import Data macro does not compile because of a Missing:Microsoft XML,v3.0 reference. This XML object is only available in Excel for Windows.
Wild Apricot states that it will not be supporting this Excel file at all. That leaves out all MAC users.
I have not been able to find any suggestions on line on how to run this Macro or replace the XML object.
The Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.
AdminEvgeny Zaritovskiy (VP Technology of Wild Apricot by Personify, Wild Apricot by Personify) commented
I got you point, it's just takes time to rewrite it for Mac too. If we can do something about it, I will let you know.
But in general, the Excel file is just an example of API usage and anyone is free to take it and change in a way you want it to be.