Finding free API connector for Legacy Excel with Mac

[Tante]

Hi all, Im very NEW to this. Trying to get data from Coinmarketcap.com, which uses an API key, so ALL the youtube videos telling you to save the plain text link in .IQY will not work. The only thing my research s showing that MAY work is getting a 3rd party API connector. When I search for them, many do not even work with excel. Than finding one for free that works with Legacy Excel (where g"et data from Web" is not an option on Power Query), is even harder to find.

Any ideas?

 

[Skyybot]

Coinmarketcap.com offers a free API key

 

[Tante]

yes, i know. But cant do anything with the key in 2019 Legacy Excel. Thus the need for an API Connector

Coinmarketcap.com offers a free API key