Excel

Google Sheets

> Live Cryptocurrency data

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/CoinRanking">CoinRanking</a>** endpoint using **Cryptosheets** through:

- `side panel console`
- `custom functions` (Excel & Googlesheets)
- `templates`

## Excel

<div class="markdown">

| App Url                                                                                 | Docs Url                                                                                 | Name                        | Example                                             | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | --------   | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/markets) | **markets** | <inline-code functionvalue='=CS.QUERY("CoinRanking","markets")'>=CS.QUERY("CoinRanking","markets")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","markets")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coins) | **Coins** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Coins")'>=CS.QUERY("CoinRanking","Coins")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Coins")</inline-code> | 10 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coin) | **Coin** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Coin",{"coin_id","1335"})'>=CS.QUERY("CoinRanking","Coin")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Coin")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coin%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coin-history) | **Coin History** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Coin History",{"coin_id","1335";"timeframe","24h"})'>=CS.QUERY("CoinRanking","Coin History")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Coin History")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Global%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/global-stats) | **Global Stats** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Global Stats")'>=CS.QUERY("CoinRanking","Global Stats")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Global Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/exchanges) | **Exchanges** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Exchanges")'>=CS.QUERY("CoinRanking","Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Exchanges")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Get%20NFTs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/get-nfts) | **Get NFTs** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Get NFTs",{"dappSlug","cryptokitties";"limit","50";"orderBy","auctionCreatedAt"})'>=CS.QUERY("CoinRanking","Get NFTs")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Get NFTs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Get%20NFT" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/get-nft) | **Get NFT** | <inline-code functionvalue='=CS.QUERY("CoinRanking","Get NFT",{"id","16443c43d6a1ba33c85a49c7c6c36f7ac7150e478a405d05c4bedcc200b9610a"})'>=CS.QUERY("CoinRanking","Get NFT")</inline-code> | <inline-code>=CS.PARAMETERS("CoinRanking","Get NFT")</inline-code> | 1 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/markets) | **markets** | <inline-code functionvalue='=CSQUERY("CoinRanking","markets")'>=CSQUERY("CoinRanking","markets")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","markets")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coins) | **Coins** | <inline-code functionvalue='=CSQUERY("CoinRanking","Coins")'>=CSQUERY("CoinRanking","Coins")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Coins")</inline-code> | 10 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coin) | **Coin** | <inline-code functionvalue='=CSQUERY("CoinRanking","Coin",{"coin_id","1335"})'>=CSQUERY("CoinRanking","Coin")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Coin")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Coin%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/coin-history) | **Coin History** | <inline-code functionvalue='=CSQUERY("CoinRanking","Coin History",{"coin_id","1335";"timeframe","24h"})'>=CSQUERY("CoinRanking","Coin History")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Coin History")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Global%20Stats" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/global-stats) | **Global Stats** | <inline-code functionvalue='=CSQUERY("CoinRanking","Global Stats")'>=CSQUERY("CoinRanking","Global Stats")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Global Stats")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/exchanges) | **Exchanges** | <inline-code functionvalue='=CSQUERY("CoinRanking","Exchanges")'>=CSQUERY("CoinRanking","Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Exchanges")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Get%20NFTs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/get-nfts) | **Get NFTs** | <inline-code functionvalue='=CSQUERY("CoinRanking","Get NFTs",{"dappSlug","cryptokitties";"limit","50";"orderBy","auctionCreatedAt"})'>=CSQUERY("CoinRanking","Get NFTs")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Get NFTs")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinRanking/Get%20NFT" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coinranking/get-nft) | **Get NFT** | <inline-code functionvalue='=CSQUERY("CoinRanking","Get NFT",{"id","16443c43d6a1ba33c85a49c7c6c36f7ac7150e478a405d05c4bedcc200b9610a"})'>=CSQUERY("CoinRanking","Get NFT")</inline-code> | <inline-code>=CSPARAMETERS("CoinRanking","Get NFT")</inline-code> | 1 |

</div>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

**<a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-CoinRanking">Get Cryptosheets for Microsoft Excel</a>**

**<a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget?src=docs-CoinRanking">Get Cryptosheets for Googlesheets</a>**

\*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

**<a href="https://docs.coinranking.com/">Click here</a>** for additional documentation from CoinRanking

Learn more [here](https://intercom.help/cryptosheets/en/)

---

Tags: `CoinRanking` `provider` 


How to pull CoinRanking data into Excel and Google Sheets