How to use in excel

I m trying to usr this in exel, but getting errors.
I go to data/new query and enter this to get data

https://api.nomics.com/v1/currencies/ticker?key=XXXXXXXXXXXXXXXXXXX&ids=BTC,ETH,XRP&interval=1h,1d,7d,30d,365d&convert=USD&per-page=100&page=1