How to successfully link the coingecko data to Excel for Mac?

Question

Level 1

5 points

How to successfully link the coingecko data to Excel for Mac?

Following the tutorials on linking website data to Excel for windows this looks pretty straight forward. For excel for Mac I don't have any luck to link the coingecko data to Excel for Mac though.

Any advice to successfully link the coingecko data to Excel for Mac?

I've tried to load it with TextEdit iqy file extension and through MS Word with a iqy exntension but the link returns a lot of txt instead of a nice spreadsheet to pull the data from.

Thanks in advance.

[Re-Titled by Moderator]

iPhone 14 Pro, iOS 17

Posted on Jan 6, 2024 3:19 AM

Reply

Answer 1

Tom Gewecke

Level 10

116,378 points

Jan 6, 2024 4:22 AM in response to FGNL0031

A good forum for Excel is at

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_unknown-mso_OPMac?sort=LastReplyDate&dir=Desc&tab=All&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&isFilterExpanded=true&page=1

Reply

Answer 2

May 13, 2024 9:33 AM in response to FGNL0031

I have the same issue and couldn't find documentation on this anywhere else.

I'm thinking about writing a background script that writes the CoinGecko data to a local JSON file when the spreadsheet is opened, then I would use PowerQuery to pull from the JSON file.

If anyone has other tips or workarounds that are less technical, I would appreciate it!

Reply

How to successfully link the coingecko data to Excel for Mac?

Similar questions