Excel

Google Sheets

> Real-Time Coin Prices, historical charts and crypto market cap data from more than 200 exchanges for over 5,000 coins.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/CoinCodex">CoinCodex</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/CoinCodex/All%20Coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/all-coins) | **All Coins** | <inline-code functionvalue='=CS.QUERY("CoinCodex","All Coins")'>=CS.QUERY("CoinCodex","All Coins")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","All Coins")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/history) | **History** | <inline-code functionvalue='=CS.QUERY("CoinCodex","History",{"days","10";"samples","10";"coins_limit","10"})'>=CS.QUERY("CoinCodex","History")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","History")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin) | **Get Coin** | <inline-code functionvalue='=CS.QUERY("CoinCodex","Get Coin",{"symbol","BTC"})'>=CS.QUERY("CoinCodex","Get Coin")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","Get Coin")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-history) | **Get Coin History** | <inline-code functionvalue='=CS.QUERY("CoinCodex","Get Coin History",{"symbol","btc";"start_date","2019-10-01";"end_date","2019-11-01";"samples","10"})'>=CS.QUERY("CoinCodex","Get Coin History")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","Get Coin History")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-markets) | **Get Coin Markets** | <inline-code functionvalue='=CS.QUERY("CoinCodex","Get Coin Markets",{"symbol","BTC"})'>=CS.QUERY("CoinCodex","Get Coin Markets")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","Get Coin Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20Ranges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-ranges) | **Get Coin Ranges** | <inline-code functionvalue='=CS.QUERY("CoinCodex","Get Coin Ranges",{"comma_separated_list_of_symbols","BTC,ETH,XMR"})'>=CS.QUERY("CoinCodex","Get Coin Ranges")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","Get Coin Ranges")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Metadata" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/metadata) | **Metadata** | <inline-code functionvalue='=CS.QUERY("CoinCodex","Metadata")'>=CS.QUERY("CoinCodex","Metadata")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","Metadata")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/IEOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/ieos) | **IEOs** | <inline-code functionvalue='=CS.QUERY("CoinCodex","IEOs")'>=CS.QUERY("CoinCodex","IEOs")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","IEOs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/STOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/stos) | **STOs** | <inline-code functionvalue='=CS.QUERY("CoinCodex","STOs")'>=CS.QUERY("CoinCodex","STOs")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","STOs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/ICOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/icos) | **ICOs** | <inline-code functionvalue='=CS.QUERY("CoinCodex","ICOs")'>=CS.QUERY("CoinCodex","ICOs")</inline-code> | <inline-code>=CS.PARAMETERS("CoinCodex","ICOs")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/All%20Coins" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/all-coins) | **All Coins** | <inline-code functionvalue='=CSQUERY("CoinCodex","All Coins")'>=CSQUERY("CoinCodex","All Coins")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","All Coins")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/history) | **History** | <inline-code functionvalue='=CSQUERY("CoinCodex","History",{"days","10";"samples","10";"coins_limit","10"})'>=CSQUERY("CoinCodex","History")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","History")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin) | **Get Coin** | <inline-code functionvalue='=CSQUERY("CoinCodex","Get Coin",{"symbol","BTC"})'>=CSQUERY("CoinCodex","Get Coin")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","Get Coin")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-history) | **Get Coin History** | <inline-code functionvalue='=CSQUERY("CoinCodex","Get Coin History",{"symbol","btc";"start_date","2019-10-01";"end_date","2019-11-01";"samples","10"})'>=CSQUERY("CoinCodex","Get Coin History")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","Get Coin History")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20Markets" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-markets) | **Get Coin Markets** | <inline-code functionvalue='=CSQUERY("CoinCodex","Get Coin Markets",{"symbol","BTC"})'>=CSQUERY("CoinCodex","Get Coin Markets")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","Get Coin Markets")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Get%20Coin%20Ranges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/get-coin-ranges) | **Get Coin Ranges** | <inline-code functionvalue='=CSQUERY("CoinCodex","Get Coin Ranges",{"comma_separated_list_of_symbols","BTC,ETH,XMR"})'>=CSQUERY("CoinCodex","Get Coin Ranges")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","Get Coin Ranges")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/Metadata" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/metadata) | **Metadata** | <inline-code functionvalue='=CSQUERY("CoinCodex","Metadata")'>=CSQUERY("CoinCodex","Metadata")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","Metadata")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/IEOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/ieos) | **IEOs** | <inline-code functionvalue='=CSQUERY("CoinCodex","IEOs")'>=CSQUERY("CoinCodex","IEOs")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","IEOs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/STOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/stos) | **STOs** | <inline-code functionvalue='=CSQUERY("CoinCodex","STOs")'>=CSQUERY("CoinCodex","STOs")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","STOs")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/CoinCodex/ICOs" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/coincodex/icos) | **ICOs** | <inline-code functionvalue='=CSQUERY("CoinCodex","ICOs")'>=CSQUERY("CoinCodex","ICOs")</inline-code> | <inline-code>=CSPARAMETERS("CoinCodex","ICOs")</inline-code> | 0 |

</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-CoinCodex">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-CoinCodex">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://coincodex.com/page/api/">Click here</a>** for additional documentation from CoinCodex

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

---

Tags: `CoinCodex` `provider` 


How to pull CoinCodex data into Excel and Google Sheets