CoinMarketCap
Cryptocurrency market cap rankings, charts, and more.
Find examples for accessing every CoinMarketCap endpoint using Cryptosheets through:
side panel consolecustom functions(Excel & Googlesheets)templates
Excel
| App Url | Docs Url | Name | Example | Parameters | # of Parameters |
|---|---|---|---|---|---|
| Try It | Docs | Get Exchange Map | =CS.QUERY("CoinMarketCap","Get Exchange Map") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Map") | 7 |
| Try It | Docs | Get Fiat Map | =CS.QUERY("CoinMarketCap","Get Fiat Map") | =CS.PARAMETERS("CoinMarketCap","Get Fiat Map") | 5 |
| Try It | Docs | 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 | Get Cryptocurrency Map | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Map") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Map") | 7 |
| Try It | Docs | Get Cryptocurrency Info | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Info") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Info") | 3 |
| Try It | Docs | Get Exchange Info | =CS.QUERY("CoinMarketCap","Get Exchange Info") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Info") | 3 |
| Try It | Docs | 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 | Get Exchange Listings Latest | =CS.QUERY("CoinMarketCap","Get Exchange Listings Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Listings Latest") | 8 |
| Try It | Docs | Get Cryptocurrency Listings Latest | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Listings Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") | 18 |
| Try It | Docs | Get Blockchain Statistics Latest | =CS.QUERY("CoinMarketCap","Get Blockchain Statistics Latest") | =CS.PARAMETERS("CoinMarketCap","Get Blockchain Statistics Latest") | 2 |
| Try It | Docs | 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 | Get Cryptocurrency Listings Historical | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Listings Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Historical") | 9 |
| Try It | Docs | Get Exchange Listings Historical | =CS.QUERY("CoinMarketCap","Get Exchange Listings Historical") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Listings Historical") | 8 |
| Try It | Docs | Get Exchange Quotes Latest | =CS.QUERY("CoinMarketCap","Get Exchange Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Quotes Latest") | 3 |
| Try It | Docs | 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 | Get Cryptocurrency Quotes Latest | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Quotes Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Latest") | 6 |
| Try It | Docs | Get Cryptocurrency Quotes Historical | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Quotes Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Historical") | 8 |
| Try It | Docs | Get Exchange Quotes Historical | =CS.QUERY("CoinMarketCap","Get Exchange Quotes Historical") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Quotes Historical") | 7 |
| Try It | Docs | Get Exchange Marketpairs Latest | =CS.QUERY("CoinMarketCap","Get Exchange Marketpairs Latest") | =CS.PARAMETERS("CoinMarketCap","Get Exchange Marketpairs Latest") | 9 |
| Try It | Docs | Get Cryptocurrency Marketpairs Latest | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | 11 |
| Try It | Docs | Get Cryptocurrency Ohlcv Latest | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | 4 |
| Try It | Docs | Get Cryptocurrency Ohlcv Historical | =CS.QUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | =CS.PARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | 9 |
| Try It | Docs | 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 | Get Tools Price Conversion | =CS.QUERY("CoinMarketCap","Get Tools Price Conversion") | =CS.PARAMETERS("CoinMarketCap","Get Tools Price Conversion") | 5 |
| Try It | Docs | Get Front Page | =CS.QUERY("CoinMarketCap","Get Front Page") | =CS.PARAMETERS("CoinMarketCap","Get Front Page") | 6 |
| Try It | Docs | Trending Gainers Losers | =CS.QUERY("CoinMarketCap","Trending Gainers Losers") | =CS.PARAMETERS("CoinMarketCap","Trending Gainers Losers") | 6 |
| Try It | Docs | Trending Most Visited | =CS.QUERY("CoinMarketCap","Trending Most Visited") | =CS.PARAMETERS("CoinMarketCap","Trending Most Visited") | 6 |
| Try It | Docs | Trending Latest | =CS.QUERY("CoinMarketCap","Trending Latest") | =CS.PARAMETERS("CoinMarketCap","Trending Latest") | 6 |
| Try It | Docs | Airdrop | =CS.QUERY("CoinMarketCap","Airdrop") | =CS.PARAMETERS("CoinMarketCap","Airdrop") | 2 |
| Try It | Docs | Airdrops | =CS.QUERY("CoinMarketCap","Airdrops") | =CS.PARAMETERS("CoinMarketCap","Airdrops") | 7 |
| Try It | Docs | Category | =CS.QUERY("CoinMarketCap","Category") | =CS.PARAMETERS("CoinMarketCap","Category") | 6 |
| Try It | Docs | Categories | =CS.QUERY("CoinMarketCap","Categories") | =CS.PARAMETERS("CoinMarketCap","Categories") | 6 |
Google Sheets
| App Url | Docs Url | Name | Example | Parameters | # of Parameters |
|---|---|---|---|---|---|
| Try It | Docs | Get Exchange Map | =CSQUERY("CoinMarketCap","Get Exchange Map") | =CSPARAMETERS("CoinMarketCap","Get Exchange Map") | 7 |
| Try It | Docs | Get Fiat Map | =CSQUERY("CoinMarketCap","Get Fiat Map") | =CSPARAMETERS("CoinMarketCap","Get Fiat Map") | 5 |
| Try It | Docs | Get Global Metrics Quotes Latest | =CSQUERY("CoinMarketCap","Get Global Metrics Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Global Metrics Quotes Latest") | 2 |
| Try It | Docs | Get Cryptocurrency Map | =CSQUERY("CoinMarketCap","Get Cryptocurrency Map") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Map") | 7 |
| Try It | Docs | Get Cryptocurrency Info | =CSQUERY("CoinMarketCap","Get Cryptocurrency Info") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Info") | 3 |
| Try It | Docs | Get Exchange Info | =CSQUERY("CoinMarketCap","Get Exchange Info") | =CSPARAMETERS("CoinMarketCap","Get Exchange Info") | 3 |
| Try It | Docs | Get Global Metrics Quotes Historical | =CSQUERY("CoinMarketCap","Get Global Metrics Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Global Metrics Quotes Historical") | 7 |
| Try It | Docs | Get Exchange Listings Latest | =CSQUERY("CoinMarketCap","Get Exchange Listings Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Listings Latest") | 8 |
| Try It | Docs | Get Cryptocurrency Listings Latest | =CSQUERY("CoinMarketCap","Get Cryptocurrency Listings Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Latest") | 18 |
| Try It | Docs | Get Blockchain Statistics Latest | =CSQUERY("CoinMarketCap","Get Blockchain Statistics Latest") | =CSPARAMETERS("CoinMarketCap","Get Blockchain Statistics Latest") | 2 |
| Try It | Docs | 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 | Get Cryptocurrency Listings Historical | =CSQUERY("CoinMarketCap","Get Cryptocurrency Listings Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Listings Historical") | 9 |
| Try It | Docs | Get Exchange Listings Historical | =CSQUERY("CoinMarketCap","Get Exchange Listings Historical") | =CSPARAMETERS("CoinMarketCap","Get Exchange Listings Historical") | 8 |
| Try It | Docs | Get Exchange Quotes Latest | =CSQUERY("CoinMarketCap","Get Exchange Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Quotes Latest") | 3 |
| Try It | Docs | 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 | Get Cryptocurrency Quotes Latest | =CSQUERY("CoinMarketCap","Get Cryptocurrency Quotes Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Latest") | 6 |
| Try It | Docs | Get Cryptocurrency Quotes Historical | =CSQUERY("CoinMarketCap","Get Cryptocurrency Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Quotes Historical") | 8 |
| Try It | Docs | Get Exchange Quotes Historical | =CSQUERY("CoinMarketCap","Get Exchange Quotes Historical") | =CSPARAMETERS("CoinMarketCap","Get Exchange Quotes Historical") | 7 |
| Try It | Docs | Get Exchange Marketpairs Latest | =CSQUERY("CoinMarketCap","Get Exchange Marketpairs Latest") | =CSPARAMETERS("CoinMarketCap","Get Exchange Marketpairs Latest") | 9 |
| Try It | Docs | Get Cryptocurrency Marketpairs Latest | =CSQUERY("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Marketpairs Latest") | 11 |
| Try It | Docs | Get Cryptocurrency Ohlcv Latest | =CSQUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Latest") | 4 |
| Try It | Docs | Get Cryptocurrency Ohlcv Historical | =CSQUERY("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | =CSPARAMETERS("CoinMarketCap","Get Cryptocurrency Ohlcv Historical") | 9 |
| Try It | Docs | 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 | Get Tools Price Conversion | =CSQUERY("CoinMarketCap","Get Tools Price Conversion") | =CSPARAMETERS("CoinMarketCap","Get Tools Price Conversion") | 5 |
| Try It | Docs | Get Front Page | =CSQUERY("CoinMarketCap","Get Front Page") | =CSPARAMETERS("CoinMarketCap","Get Front Page") | 6 |
| Try It | Docs | Trending Gainers Losers | =CSQUERY("CoinMarketCap","Trending Gainers Losers") | =CSPARAMETERS("CoinMarketCap","Trending Gainers Losers") | 6 |
| Try It | Docs | Trending Most Visited | =CSQUERY("CoinMarketCap","Trending Most Visited") | =CSPARAMETERS("CoinMarketCap","Trending Most Visited") | 6 |
| Try It | Docs | Trending Latest | =CSQUERY("CoinMarketCap","Trending Latest") | =CSPARAMETERS("CoinMarketCap","Trending Latest") | 6 |
| Try It | Docs | Airdrop | =CSQUERY("CoinMarketCap","Airdrop") | =CSPARAMETERS("CoinMarketCap","Airdrop") | 2 |
| Try It | Docs | Airdrops | =CSQUERY("CoinMarketCap","Airdrops") | =CSPARAMETERS("CoinMarketCap","Airdrops") | 7 |
| Try It | Docs | Category | =CSQUERY("CoinMarketCap","Category") | =CSPARAMETERS("CoinMarketCap","Category") | 6 |
| Try It | Docs | Categories | =CSQUERY("CoinMarketCap","Categories") | =CSPARAMETERS("CoinMarketCap","Categories") | 6 |
Signing up for Cryptosheets is free 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 of Microsoft Office or Excel for custom functions to work
Click here for additional documentation from CoinMarketCap
Learn more here
Tags: CoinMarketCap provider