Excel

Google Sheets

> Crowdsourced and professionally curated research, analysis and market-moving news

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/CryptoRank.io">CryptoRank.io</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/CryptoRank.io/Currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies) | **Currencies** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Currencies",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"optionalFields","";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Currencies")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Currencies")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Historical" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-historical) | **Currencies Historical** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Currencies Historical",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"time","2020-01-10T00:00:00.000Z";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Currencies Historical")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Currencies Historical")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Crowdsales" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-crowdsales) | **Currencies Crowdsales** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Currencies Crowdsales",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Currencies Crowdsales")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Currencies Crowdsales")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Id" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-id) | **Currencies Id** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Currencies Id",{"api_key","api_key";"id","1"})'>=CS.QUERY("CryptoRank.io","Currencies Id")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Currencies Id")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Id%20Sparkline" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-id-sparkline) | **Currencies Id Sparkline** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Currencies Id Sparkline",{"id","1";"convert","USD";"from","2020-01-10T00:00:00.000Z";"to","2020-01-30T15:00:00.000Z";"interval","1h";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Currencies Id Sparkline")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Currencies Id Sparkline")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/exchanges) | **Exchanges** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Exchanges",{"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Exchanges")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Exchanges%20Id" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/exchanges-id) | **Exchanges Id** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Exchanges Id",{"api_key","api_key";"id","1"})'>=CS.QUERY("CryptoRank.io","Exchanges Id")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Exchanges Id")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Global" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/global) | **Global** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Global",{"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Global")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Global")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/markets) | **Markets** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","Markets",{"limit","100";"offset","0";"baseCoinId","";"quoteCoinId","";"exchangeId","";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","Markets")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","Markets")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/News%20Feed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/news-feed) | **News Feed** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","News Feed",{"limit","100";"offset","0";"coinId","";"from","";"to","";"coinSymbol","";"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","News Feed")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","News Feed")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/News%20Sources" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/news-sources) | **News Sources** | <inline-code functionvalue='=CS.QUERY("CryptoRank.io","News Sources",{"api_key","api_key"})'>=CS.QUERY("CryptoRank.io","News Sources")</inline-code> | <inline-code>=CS.PARAMETERS("CryptoRank.io","News Sources")</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/CryptoRank.io/Currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies) | **Currencies** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Currencies",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"optionalFields","";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Currencies")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Currencies")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Historical" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-historical) | **Currencies Historical** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Currencies Historical",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"time","2020-01-10T00:00:00.000Z";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Currencies Historical")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Currencies Historical")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Crowdsales" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-crowdsales) | **Currencies Crowdsales** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Currencies Crowdsales",{"limit","100";"offset","0";"convert","USD";"state","active";"ids","";"symbols","";"sort","rank";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Currencies Crowdsales")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Currencies Crowdsales")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Id" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-id) | **Currencies Id** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Currencies Id",{"api_key","api_key";"id","1"})'>=CSQUERY("CryptoRank.io","Currencies Id")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Currencies Id")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Currencies%20Id%20Sparkline" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/currencies-id-sparkline) | **Currencies Id Sparkline** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Currencies Id Sparkline",{"id","1";"convert","USD";"from","2020-01-10T00:00:00.000Z";"to","2020-01-30T15:00:00.000Z";"interval","1h";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Currencies Id Sparkline")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Currencies Id Sparkline")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/exchanges) | **Exchanges** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Exchanges",{"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Exchanges")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Exchanges%20Id" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/exchanges-id) | **Exchanges Id** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Exchanges Id",{"api_key","api_key";"id","1"})'>=CSQUERY("CryptoRank.io","Exchanges Id")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Exchanges Id")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Global" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/global) | **Global** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Global",{"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Global")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Global")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/markets) | **Markets** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","Markets",{"limit","100";"offset","0";"baseCoinId","";"quoteCoinId","";"exchangeId","";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","Markets")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","Markets")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/News%20Feed" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/news-feed) | **News Feed** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","News Feed",{"limit","100";"offset","0";"coinId","";"from","";"to","";"coinSymbol","";"api_key","api_key"})'>=CSQUERY("CryptoRank.io","News Feed")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","News Feed")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/CryptoRank.io/News%20Sources" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/cryptorank.io/news-sources) | **News Sources** | <inline-code functionvalue='=CSQUERY("CryptoRank.io","News Sources",{"api_key","api_key"})'>=CSQUERY("CryptoRank.io","News Sources")</inline-code> | <inline-code>=CSPARAMETERS("CryptoRank.io","News Sources")</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-CryptoRank.io">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-CryptoRank.io">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://cryptorank.io/api">Click here</a>** for additional documentation from CryptoRank.io

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

---

Tags: `CryptoRank.io` `provider` 


How to pull CryptoRank.io data into Excel and Google Sheets