Add Exernal data from a web query on mac excel

[jrose7]

Hello,

i'm here because i'm really frustrated.
I read and i saw different guides but it doesn't work.
I have excel on my Mac, 2019 version.
I tried to add the crypto prices from APY coinmarketcap.
I created a new document word with my APY like this: https://pro-api.coinmarketcap.com/v...atest?limit=1000&convert=EUR&CMC_PRO_API_KEY=MyApyKeyNumber
and 1) I saved it txt onto folder " queries " but don't works ( Doesn't let me select it )
2) I tried to change his format in .iqy but it don't works ( Doesn't let me select it )
3) I toke the already existent file .iqy called: SampleWebQuery01.iqy , copied it on desk, open with Text Edit and i found this:

WEB
1

Mac Web Query article - Microsoft Support

go.microsoft.com

Selection=1
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

So i tried to change the link with my https://pro-api.coinmarketcap.com/v...atest?limit=1000&convert=EUR&CMC_PRO_API_KEY=MyApyKeyNumber
but don't work ( I can select but reported an error)
4) I tried to add also:

Selection=1
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

I can select it and excel start to work but report all data in one column ( see image below ):

5) I tried to change some value, Selection, Formatting etc... same result..

I'm really frustrated..
If someone can tell me where i wrong or if know another way to import crypto datas would very appreciates.

Thanks in advance.