> Cryptocurrency market cap rankings, charts, and more. Find examples for accessing every **CoinMarketCap** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/coinmarketcap/get-exchange-map) | **Get Exchange Map** | =CS.QUERY("CoinMarketCap","Get Exchange Map") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Map") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-fiat-map) | **Get Fiat Map** | =CS.QUERY("CoinMarketCap","Get Fiat Map") | =CS.PARAMETERS("CoinMarketCap","Get Fiat Map") | 5 | | Try It | [Docs](/providers/coinmarketcap/get-global-metrics-quotes-latest) | **Get Global Metrics Quotes Latest** | =CS.QUERY("CoinMarketCap","Get Global Metrics Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Global Metrics Quotes Latest") | 2 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-map) | **Get Cryptocurrency Map** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Map") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Map") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-info) | **Get Cryptocurrency Info** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Info") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Info") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-info) | **Get Exchange Info** | =CS.QUERY("CoinMarketCap","Get Exchange Info") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Info") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-global-metrics-quotes-historical) | **Get Global Metrics Quotes Historical** | =CS.QUERY("CoinMarketCap","Get Global Metrics Quotes Historical") | =CS.PARAMETERS("CoinMarketCap","Get Global Metrics Quotes Historical") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-listings-latest) | **Get Exchange Listings Latest** | =CS.QUERY("CoinMarketCap","Get Exchange Listings Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Listings Latest") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-listings-latest) | **Get Cryptocurrency Listings Latest** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Listings Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") | 18 | | Try It | [Docs](/providers/coinmarketcap/get-blockchain-statistics-latest) | **Get Blockchain Statistics Latest** | =CS.QUERY("CoinMarketCap","Get Blockchain Statistics Latest") | =CS.PARAMETERS("CoinMarketCap","Get Blockchain Statistics Latest") | 2 | | Try It | [Docs](/providers/coinmarketcap/get-partners-flipside-crypto-fcas-listings-latest) | **Get Partners FlipSide Crypto Fcas Listings Latest** | =CS.QUERY("CoinMarketCap","Get Partners FlipSide Crypto Fcas Listings Latest") | =CS.PARAMETERS("CoinMarketCap","Get Partners FlipSide Crypto Fcas Listings Latest") | 4 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-listings-historical) | **Get Cryptocurrency Listings Historical** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Listings Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Historical") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-listings-historical) | **Get Exchange Listings Historical** | =CS.QUERY("CoinMarketCap","Get Exchange Listings Historical") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Listings Historical") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-quotes-latest) | **Get Exchange Quotes Latest** | =CS.QUERY("CoinMarketCap","Get Exchange Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Quotes Latest") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-partners-flipside-crypto-fcas-quotes-latest) | **Get Partners FlipSide Crypto Fcas Quotes Latest** | =CS.QUERY("CoinMarketCap","Get Partners FlipSide Crypto Fcas Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Partners FlipSide Crypto Fcas Quotes Latest") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-quotes-latest) | **Get Cryptocurrency Quotes Latest** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Latest") | 6 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-quotes-historical) | **Get Cryptocurrency Quotes Historical** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Quotes Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Historical") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-quotes-historical) | **Get Exchange Quotes Historical** | =CS.QUERY("CoinMarketCap","Get Exchange Quotes Historical") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Quotes Historical") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-marketpairs-latest) | **Get Exchange Marketpairs Latest** | =CS.QUERY("CoinMarketCap","Get Exchange Marketpairs Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Marketpairs Latest") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-marketpairs-latest) | **Get Cryptocurrency Marketpairs Latest** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | 11 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-ohlcv-latest) | **Get Cryptocurrency Ohlcv Latest** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | 4 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-ohlcv-historical) | **Get Cryptocurrency Ohlcv Historical** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-price-performance-stats-latest) | **Get Cryptocurrency Price Performance Stats Latest** | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Price Performance Stats Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Price Performance Stats Latest") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-tools-price-conversion) | **Get Tools Price Conversion** | =CS.QUERY("CoinMarketCap","Get Tools Price Conversion") | =CS.PARAMETERS("CoinMarketCap","Get Tools Price Conversion") | 5 | | Try It | [Docs](/providers/coinmarketcap/get-front-page) | **Get Front Page** | =CS.QUERY("CoinMarketCap","Get Front Page") | =CS.PARAMETERS("CoinMarketCap","Get Front Page") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-gainers-losers) | **Trending Gainers Losers** | =CS.QUERY("CoinMarketCap","Trending Gainers Losers") | =CS.PARAMETERS("CoinMarketCap","Trending Gainers Losers") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-most-visited) | **Trending Most Visited** | =CS.QUERY("CoinMarketCap","Trending Most Visited") | =CS.PARAMETERS("CoinMarketCap","Trending Most Visited") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-latest) | **Trending Latest** | =CS.QUERY("CoinMarketCap","Trending Latest") | =CS.PARAMETERS("CoinMarketCap","Trending Latest") | 6 | | Try It | [Docs](/providers/coinmarketcap/airdrop) | **Airdrop** | =CS.QUERY("CoinMarketCap","Airdrop") | =CS.PARAMETERS("CoinMarketCap","Airdrop") | 2 | | Try It | [Docs](/providers/coinmarketcap/airdrops) | **Airdrops** | =CS.QUERY("CoinMarketCap","Airdrops") | =CS.PARAMETERS("CoinMarketCap","Airdrops") | 7 | | Try It | [Docs](/providers/coinmarketcap/category) | **Category** | =CS.QUERY("CoinMarketCap","Category") | =CS.PARAMETERS("CoinMarketCap","Category") | 6 | | Try It | [Docs](/providers/coinmarketcap/categories) | **Categories** | =CS.QUERY("CoinMarketCap","Categories") | =CS.PARAMETERS("CoinMarketCap","Categories") | 6 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/coinmarketcap/get-exchange-map) | **Get Exchange Map** | =CSQUERY("CoinMarketCap","Get Exchange Map") | =CSPARAMETERS("CoinMarketCap","Get Exchange Map") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-fiat-map) | **Get Fiat Map** | =CSQUERY("CoinMarketCap","Get Fiat Map") | =CSPARAMETERS("CoinMarketCap","Get Fiat Map") | 5 | | Try It | [Docs](/providers/coinmarketcap/get-global-metrics-quotes-latest) | **Get Global Metrics Quotes Latest** | =CSQUERY("CoinMarketCap","Get Global Metrics Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Global Metrics Quotes Latest") | 2 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-map) | **Get Cryptocurrency Map** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Map") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Map") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-info) | **Get Cryptocurrency Info** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Info") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Info") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-info) | **Get Exchange Info** | =CSQUERY("CoinMarketCap","Get Exchange Info") | =CSPARAMETERS("CoinMarketCap","Get Exchange Info") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-global-metrics-quotes-historical) | **Get Global Metrics Quotes Historical** | =CSQUERY("CoinMarketCap","Get Global Metrics Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Global Metrics Quotes Historical") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-listings-latest) | **Get Exchange Listings Latest** | =CSQUERY("CoinMarketCap","Get Exchange Listings Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Listings Latest") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-listings-latest) | **Get Cryptocurrency Listings Latest** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Listings Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") | 18 | | Try It | [Docs](/providers/coinmarketcap/get-blockchain-statistics-latest) | **Get Blockchain Statistics Latest** | =CSQUERY("CoinMarketCap","Get Blockchain Statistics Latest") | =CSPARAMETERS("CoinMarketCap","Get Blockchain Statistics Latest") | 2 | | Try It | [Docs](/providers/coinmarketcap/get-partners-flipside-crypto-fcas-listings-latest) | **Get Partners FlipSide Crypto Fcas Listings Latest** | =CSQUERY("CoinMarketCap","Get Partners FlipSide Crypto Fcas Listings Latest") | =CSPARAMETERS("CoinMarketCap","Get Partners FlipSide Crypto Fcas Listings Latest") | 4 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-listings-historical) | **Get Cryptocurrency Listings Historical** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Listings Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Historical") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-listings-historical) | **Get Exchange Listings Historical** | =CSQUERY("CoinMarketCap","Get Exchange Listings Historical") | =CSPARAMETERS("CoinMarketCap","Get Exchange Listings Historical") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-quotes-latest) | **Get Exchange Quotes Latest** | =CSQUERY("CoinMarketCap","Get Exchange Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Quotes Latest") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-partners-flipside-crypto-fcas-quotes-latest) | **Get Partners FlipSide Crypto Fcas Quotes Latest** | =CSQUERY("CoinMarketCap","Get Partners FlipSide Crypto Fcas Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Partners FlipSide Crypto Fcas Quotes Latest") | 3 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-quotes-latest) | **Get Cryptocurrency Quotes Latest** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Latest") | 6 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-quotes-historical) | **Get Cryptocurrency Quotes Historical** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Historical") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-quotes-historical) | **Get Exchange Quotes Historical** | =CSQUERY("CoinMarketCap","Get Exchange Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Exchange Quotes Historical") | 7 | | Try It | [Docs](/providers/coinmarketcap/get-exchange-marketpairs-latest) | **Get Exchange Marketpairs Latest** | =CSQUERY("CoinMarketCap","Get Exchange Marketpairs Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Marketpairs Latest") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-marketpairs-latest) | **Get Cryptocurrency Marketpairs Latest** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | 11 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-ohlcv-latest) | **Get Cryptocurrency Ohlcv Latest** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | 4 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-ohlcv-historical) | **Get Cryptocurrency Ohlcv Historical** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | 9 | | Try It | [Docs](/providers/coinmarketcap/get-cryptocurrency-price-performance-stats-latest) | **Get Cryptocurrency Price Performance Stats Latest** | =CSQUERY("CoinMarketCap","Get Cryptocurrency Price Performance Stats Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Price Performance Stats Latest") | 8 | | Try It | [Docs](/providers/coinmarketcap/get-tools-price-conversion) | **Get Tools Price Conversion** | =CSQUERY("CoinMarketCap","Get Tools Price Conversion") | =CSPARAMETERS("CoinMarketCap","Get Tools Price Conversion") | 5 | | Try It | [Docs](/providers/coinmarketcap/get-front-page) | **Get Front Page** | =CSQUERY("CoinMarketCap","Get Front Page") | =CSPARAMETERS("CoinMarketCap","Get Front Page") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-gainers-losers) | **Trending Gainers Losers** | =CSQUERY("CoinMarketCap","Trending Gainers Losers") | =CSPARAMETERS("CoinMarketCap","Trending Gainers Losers") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-most-visited) | **Trending Most Visited** | =CSQUERY("CoinMarketCap","Trending Most Visited") | =CSPARAMETERS("CoinMarketCap","Trending Most Visited") | 6 | | Try It | [Docs](/providers/coinmarketcap/trending-latest) | **Trending Latest** | =CSQUERY("CoinMarketCap","Trending Latest") | =CSPARAMETERS("CoinMarketCap","Trending Latest") | 6 | | Try It | [Docs](/providers/coinmarketcap/airdrop) | **Airdrop** | =CSQUERY("CoinMarketCap","Airdrop") | =CSPARAMETERS("CoinMarketCap","Airdrop") | 2 | | Try It | [Docs](/providers/coinmarketcap/airdrops) | **Airdrops** | =CSQUERY("CoinMarketCap","Airdrops") | =CSPARAMETERS("CoinMarketCap","Airdrops") | 7 | | Try It | [Docs](/providers/coinmarketcap/category) | **Category** | =CSQUERY("CoinMarketCap","Category") | =CSPARAMETERS("CoinMarketCap","Category") | 6 | | Try It | [Docs](/providers/coinmarketcap/categories) | **Categories** | =CSQUERY("CoinMarketCap","Categories") | =CSPARAMETERS("CoinMarketCap","Categories") | 6 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from CoinMarketCap Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `CoinMarketCap` `provider`