Excel

Google Sheets

> Blockset is a backend-as-a-service for blockchain data. It is designed with wallets, blockchain explorers, and data aggregators in mind - and (unlike raw full nodes) is designed to handle unlimited scale.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Blockset">Blockset</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/Blockset/blockchains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blockchains) | **blockchains** | <inline-code functionvalue='=CS.QUERY("Blockset","blockchains",{"authorization","Your auth_token"})'>=CS.QUERY("Blockset","blockchains")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","blockchains")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/blockchain" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blockchain) | **blockchain** | <inline-code functionvalue='=CS.QUERY("Blockset","blockchain",{"id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","blockchain")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","blockchain")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blocks) | **blocks** | <inline-code functionvalue='=CS.QUERY("Blockset","blocks",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","blocks")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","blocks")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/block) | **block** | <inline-code functionvalue='=CS.QUERY("Blockset","block",{"block_id","bitcoin-mainnet:000000000019d6689c085ae165831e934ff763ae46a2a6c172b3f1b60a8ce26f";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","block")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","block")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transactions) | **transactions** | <inline-code functionvalue='=CS.QUERY("Blockset","transactions",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","transactions")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","transactions")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transaction) | **transaction** | <inline-code functionvalue='=CS.QUERY("Blockset","transaction",{"transaction_id","bitcoin-mainnet:4a5e1e4baab89f3a32518a88c31bc87f618f76673e2cc77ab2127b7afdeda33b";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","transaction")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","transaction")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transfers) | **transfers** | <inline-code functionvalue='=CS.QUERY("Blockset","transfers",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","transfers")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","transfers")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transfer" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transfer) | **transfer** | <inline-code functionvalue='=CS.QUERY("Blockset","transfer",{"transfer_id","bitcoin-mainnet:0e3e2357e806b6cdb1f70b54c3a3a17b6714ee1f0e68bebb44a74b1efd512098:1";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","transfer")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","transfer")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/currencies) | **currencies** | <inline-code functionvalue='=CS.QUERY("Blockset","currencies",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","currencies")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","currencies")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/currency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/currency) | **currency** | <inline-code functionvalue='=CS.QUERY("Blockset","currency",{"id","bitcoin-mainnet:__native__";"authorization","Your auth_token"})'>=CS.QUERY("Blockset","currency")</inline-code> | <inline-code>=CS.PARAMETERS("Blockset","currency")</inline-code> | 2 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/blockchains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blockchains) | **blockchains** | <inline-code functionvalue='=CSQUERY("Blockset","blockchains",{"authorization","Your auth_token"})'>=CSQUERY("Blockset","blockchains")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","blockchains")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/blockchain" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blockchain) | **blockchain** | <inline-code functionvalue='=CSQUERY("Blockset","blockchain",{"id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CSQUERY("Blockset","blockchain")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","blockchain")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/blocks" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/blocks) | **blocks** | <inline-code functionvalue='=CSQUERY("Blockset","blocks",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CSQUERY("Blockset","blocks")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","blocks")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/block) | **block** | <inline-code functionvalue='=CSQUERY("Blockset","block",{"block_id","bitcoin-mainnet:000000000019d6689c085ae165831e934ff763ae46a2a6c172b3f1b60a8ce26f";"authorization","Your auth_token"})'>=CSQUERY("Blockset","block")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","block")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transactions) | **transactions** | <inline-code functionvalue='=CSQUERY("Blockset","transactions",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CSQUERY("Blockset","transactions")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","transactions")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transaction) | **transaction** | <inline-code functionvalue='=CSQUERY("Blockset","transaction",{"transaction_id","bitcoin-mainnet:4a5e1e4baab89f3a32518a88c31bc87f618f76673e2cc77ab2127b7afdeda33b";"authorization","Your auth_token"})'>=CSQUERY("Blockset","transaction")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","transaction")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transfers) | **transfers** | <inline-code functionvalue='=CSQUERY("Blockset","transfers",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CSQUERY("Blockset","transfers")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","transfers")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/transfer" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/transfer) | **transfer** | <inline-code functionvalue='=CSQUERY("Blockset","transfer",{"transfer_id","bitcoin-mainnet:0e3e2357e806b6cdb1f70b54c3a3a17b6714ee1f0e68bebb44a74b1efd512098:1";"authorization","Your auth_token"})'>=CSQUERY("Blockset","transfer")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","transfer")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/currencies" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/currencies) | **currencies** | <inline-code functionvalue='=CSQUERY("Blockset","currencies",{"blockchain_id","bitcoin-mainnet";"authorization","Your auth_token"})'>=CSQUERY("Blockset","currencies")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","currencies")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Blockset/currency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockset/currency) | **currency** | <inline-code functionvalue='=CSQUERY("Blockset","currency",{"id","bitcoin-mainnet:__native__";"authorization","Your auth_token"})'>=CSQUERY("Blockset","currency")</inline-code> | <inline-code>=CSPARAMETERS("Blockset","currency")</inline-code> | 2 |

</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-Blockset">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-Blockset">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://blockset.com/docs">Click here</a>** for additional documentation from Blockset

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

---

Tags: `Blockset` `provider` 


How to pull Blockset data into Excel and Google Sheets