You can easily access the entire Coinmarketcap API in Excel or Googlesheets using Cryptosheets

-> https://docs.cryptosheets.com/providers/coinmarketcap

-> easy copy + paste formulas for every endpoint in Excel & Googlesheets

-> free signup

-> use your own API KEY or the default with more limited data

Try it yourself:

-> Excel:

=CS.QUERY("CoinMarketCap", "Get Cryptocurrency Listings Latest", {"X-CMC_PRO_API_KEY","Your X-CMC_PRO_API_KEY"})

-> Google:

=CSQUERY("CoinMarketCap", "Get Cryptocurrency Listings Latest", {"X-CMC_PRO_API_KEY","Your X-CMC_PRO_API_KEY"})