Excel

Google Sheets

> Blockscout is a blockchain explorer for Ethereum Networks and a tool for inspecting and analyzing EVM based blockchains including ETH, POA, xDai, RSK, ETC and more

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/BlockScout">BlockScout</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/BlockScout/Account%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/account-token-list) | **Account Token List** | <inline-code functionvalue='=CS.QUERY("BlockScout","Account Token List",{"module","account";"action","tokenlist";"address","0xbcf0fd3929ce93ce858cac1234cbdf9a526c61f7"})'>=CS.QUERY("BlockScout","Account Token List")</inline-code> | <inline-code>=CS.PARAMETERS("BlockScout","Account Token List")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/BlockScout/Pending%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/pending-transactions) | **Pending Transactions** | <inline-code functionvalue='=CS.QUERY("BlockScout","Pending Transactions",{"module","account";"action","pendingtxlist";"address","0xbcf0fd3929ce93ce858cac1234cbdf9a526c61f7"})'>=CS.QUERY("BlockScout","Pending Transactions")</inline-code> | <inline-code>=CS.PARAMETERS("BlockScout","Pending Transactions")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/BlockScout/Token%20Holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/token-holders) | **Token Holders** | <inline-code functionvalue='=CS.QUERY("BlockScout","Token Holders",{"module","token";"action","getTokenHolders";"contractaddress","0x12b19d3e2ccc14da04fae33e63652ce469b3f2fd";"page","1";"offset","100"})'>=CS.QUERY("BlockScout","Token Holders")</inline-code> | <inline-code>=CS.PARAMETERS("BlockScout","Token Holders")</inline-code> | 5 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/BlockScout/Account%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/account-token-list) | **Account Token List** | <inline-code functionvalue='=CSQUERY("BlockScout","Account Token List",{"module","account";"action","tokenlist";"address","0xbcf0fd3929ce93ce858cac1234cbdf9a526c61f7"})'>=CSQUERY("BlockScout","Account Token List")</inline-code> | <inline-code>=CSPARAMETERS("BlockScout","Account Token List")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/BlockScout/Pending%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/pending-transactions) | **Pending Transactions** | <inline-code functionvalue='=CSQUERY("BlockScout","Pending Transactions",{"module","account";"action","pendingtxlist";"address","0xbcf0fd3929ce93ce858cac1234cbdf9a526c61f7"})'>=CSQUERY("BlockScout","Pending Transactions")</inline-code> | <inline-code>=CSPARAMETERS("BlockScout","Pending Transactions")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/BlockScout/Token%20Holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/blockscout/token-holders) | **Token Holders** | <inline-code functionvalue='=CSQUERY("BlockScout","Token Holders",{"module","token";"action","getTokenHolders";"contractaddress","0x12b19d3e2ccc14da04fae33e63652ce469b3f2fd";"page","1";"offset","100"})'>=CSQUERY("BlockScout","Token Holders")</inline-code> | <inline-code>=CSPARAMETERS("BlockScout","Token Holders")</inline-code> | 5 |

</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-BlockScout">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-BlockScout">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://blockscout.com/eth/mainnet/">Click here</a>** for additional documentation from BlockScout

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

---

Tags: `BlockScout` `provider` 


How to pull BlockScout data into Excel and Google Sheets