Excel

Google Sheets

> Leading provider of institutional-grade crypto-asset data tracking over 80 metrics for bitcoin and other altcoins in real-time.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/ByteTree">ByteTree</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/ByteTree/BTC%20All%20Time%20Daily%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/btc-all-time-daily-data) | **BTC All Time Daily Data** | <inline-code functionvalue='=CS.QUERY("ByteTree","BTC All Time Daily Data")'>=CS.QUERY("ByteTree","BTC All Time Daily Data")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BTC All Time Daily Data")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BCH%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bch-all-time-daily) | **BCH All Time Daily** | <inline-code functionvalue='=CS.QUERY("ByteTree","BCH All Time Daily")'>=CS.QUERY("ByteTree","BCH All Time Daily")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BCH All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BSV%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bsv-all-time-daily) | **BSV All Time Daily** | <inline-code functionvalue='=CS.QUERY("ByteTree","BSV All Time Daily")'>=CS.QUERY("ByteTree","BSV All Time Daily")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BSV All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/LTC%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/ltc-all-time-daily) | **LTC All Time Daily** | <inline-code functionvalue='=CS.QUERY("ByteTree","LTC All Time Daily")'>=CS.QUERY("ByteTree","LTC All Time Daily")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","LTC All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/DASH%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/dash-all-time-daily) | **DASH All Time Daily** | <inline-code functionvalue='=CS.QUERY("ByteTree","DASH All Time Daily")'>=CS.QUERY("ByteTree","DASH All Time Daily")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","DASH All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BTC%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/btc-30d-blocks) | **BTC 30d Blocks** | <inline-code functionvalue='=CS.QUERY("ByteTree","BTC 30d Blocks")'>=CS.QUERY("ByteTree","BTC 30d Blocks")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BTC 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BCH%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bch-30d-blocks) | **BCH 30d Blocks** | <inline-code functionvalue='=CS.QUERY("ByteTree","BCH 30d Blocks")'>=CS.QUERY("ByteTree","BCH 30d Blocks")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BCH 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BSV%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bsv-30d-blocks) | **BSV 30d Blocks** | <inline-code functionvalue='=CS.QUERY("ByteTree","BSV 30d Blocks")'>=CS.QUERY("ByteTree","BSV 30d Blocks")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","BSV 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/LTC%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/ltc-30d-blocks) | **LTC 30d Blocks** | <inline-code functionvalue='=CS.QUERY("ByteTree","LTC 30d Blocks")'>=CS.QUERY("ByteTree","LTC 30d Blocks")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","LTC 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/DASH%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/dash-30d-blocks) | **DASH 30d Blocks** | <inline-code functionvalue='=CS.QUERY("ByteTree","DASH 30d Blocks")'>=CS.QUERY("ByteTree","DASH 30d Blocks")</inline-code> | <inline-code>=CS.PARAMETERS("ByteTree","DASH 30d Blocks")</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/ByteTree/BTC%20All%20Time%20Daily%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/btc-all-time-daily-data) | **BTC All Time Daily Data** | <inline-code functionvalue='=CSQUERY("ByteTree","BTC All Time Daily Data")'>=CSQUERY("ByteTree","BTC All Time Daily Data")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BTC All Time Daily Data")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BCH%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bch-all-time-daily) | **BCH All Time Daily** | <inline-code functionvalue='=CSQUERY("ByteTree","BCH All Time Daily")'>=CSQUERY("ByteTree","BCH All Time Daily")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BCH All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BSV%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bsv-all-time-daily) | **BSV All Time Daily** | <inline-code functionvalue='=CSQUERY("ByteTree","BSV All Time Daily")'>=CSQUERY("ByteTree","BSV All Time Daily")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BSV All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/LTC%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/ltc-all-time-daily) | **LTC All Time Daily** | <inline-code functionvalue='=CSQUERY("ByteTree","LTC All Time Daily")'>=CSQUERY("ByteTree","LTC All Time Daily")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","LTC All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/DASH%20All%20Time%20Daily" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/dash-all-time-daily) | **DASH All Time Daily** | <inline-code functionvalue='=CSQUERY("ByteTree","DASH All Time Daily")'>=CSQUERY("ByteTree","DASH All Time Daily")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","DASH All Time Daily")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BTC%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/btc-30d-blocks) | **BTC 30d Blocks** | <inline-code functionvalue='=CSQUERY("ByteTree","BTC 30d Blocks")'>=CSQUERY("ByteTree","BTC 30d Blocks")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BTC 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BCH%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bch-30d-blocks) | **BCH 30d Blocks** | <inline-code functionvalue='=CSQUERY("ByteTree","BCH 30d Blocks")'>=CSQUERY("ByteTree","BCH 30d Blocks")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BCH 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/BSV%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/bsv-30d-blocks) | **BSV 30d Blocks** | <inline-code functionvalue='=CSQUERY("ByteTree","BSV 30d Blocks")'>=CSQUERY("ByteTree","BSV 30d Blocks")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","BSV 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/LTC%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/ltc-30d-blocks) | **LTC 30d Blocks** | <inline-code functionvalue='=CSQUERY("ByteTree","LTC 30d Blocks")'>=CSQUERY("ByteTree","LTC 30d Blocks")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","LTC 30d Blocks")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/ByteTree/DASH%2030d%20Blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/bytetree/dash-30d-blocks) | **DASH 30d Blocks** | <inline-code functionvalue='=CSQUERY("ByteTree","DASH 30d Blocks")'>=CSQUERY("ByteTree","DASH 30d Blocks")</inline-code> | <inline-code>=CSPARAMETERS("ByteTree","DASH 30d Blocks")</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-ByteTree">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-ByteTree">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://bytetree.com/">Click here</a>** for additional documentation from ByteTree

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

---

Tags: `ByteTree` `provider` 


How to pull ByteTree data into Excel and Google Sheets