Excel

Google Sheets

> A network and block explorer for the default smart contract blockchain on AVAX Avalanche, it enables the creation of any Ethereum-compatible EVM smart contracts.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Snowtrace">Snowtrace</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/Snowtrace/Get%20AVAX%20Balance%20for%20a%20single%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-avax-balance-for-a-single-address) | **Get AVAX Balance for a single Address** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get AVAX Balance for a single Address")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20AVAX%20Balance%20for%20multiple%20Addresses%20in%20a%20single%20call" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-avax-balance-for-multiple-addresses-in-a-single-call) | **Get AVAX Balance for multiple Addresses in a single call** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get AVAX Balance for multiple Addresses in a single call")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20Normal%20Transactions%20By%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-normal-transactions-by-address-avax) | **Get a list of Normal Transactions By Address AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get a list of Normal Transactions By Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20Internal%20Transactions%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-internal-transactions-by-address-avax) | **Get a list of Internal Transactions by Address AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get a list of Internal Transactions by Address AVAX")</inline-code> | <inline-code></inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20Internal%20Transactions%20by%20Transaction%20Hash%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-internal-transactions-by-transaction-hash-avax) | **Get Internal Transactions by Transaction Hash AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get Internal Transactions by Transaction Hash AVAX")</inline-code> | <inline-code></inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20Internal%20Transactions%20by%20Range%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-internal-transactions-by-range-avax) | **Get Internal Transactions by Range AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get Internal Transactions by Range AVAX")</inline-code> | <inline-code></inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20ERC-20%20-%20Token%20Transfer%20Events%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-erc-20---token-transfer-events-by-address-avax) | **Get a list of ERC-20 - Token Transfer Events by Address AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get a list of ERC-20 - Token Transfer Events by Address AVAX")</inline-code> | <inline-code></inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20ERC721%20-%20Token%20Transfer%20Events%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-erc721---token-transfer-events-by-address-avax) | **Get a list of ERC721 - Token Transfer Events by Address AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get a list of ERC721 - Token Transfer Events by Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20list%20of%20Blocks%20Validated%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-list-of-blocks-validated-by-address-avax) | **Get list of Blocks Validated by Address AVAX** | <inline-code functionvalue=''>=CS.QUERY("Snowtrace","Get list of Blocks Validated by Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20AVAX%20Balance%20for%20a%20single%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-avax-balance-for-a-single-address) | **Get AVAX Balance for a single Address** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get AVAX Balance for a single Address")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20AVAX%20Balance%20for%20multiple%20Addresses%20in%20a%20single%20call" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-avax-balance-for-multiple-addresses-in-a-single-call) | **Get AVAX Balance for multiple Addresses in a single call** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get AVAX Balance for multiple Addresses in a single call")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20Normal%20Transactions%20By%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-normal-transactions-by-address-avax) | **Get a list of Normal Transactions By Address AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get a list of Normal Transactions By Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20Internal%20Transactions%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-internal-transactions-by-address-avax) | **Get a list of Internal Transactions by Address AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get a list of Internal Transactions by Address AVAX")</inline-code> | <inline-code></inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20Internal%20Transactions%20by%20Transaction%20Hash%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-internal-transactions-by-transaction-hash-avax) | **Get Internal Transactions by Transaction Hash AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get Internal Transactions by Transaction Hash AVAX")</inline-code> | <inline-code></inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20Internal%20Transactions%20by%20Range%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-internal-transactions-by-range-avax) | **Get Internal Transactions by Range AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get Internal Transactions by Range AVAX")</inline-code> | <inline-code></inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20ERC-20%20-%20Token%20Transfer%20Events%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-erc-20---token-transfer-events-by-address-avax) | **Get a list of ERC-20 - Token Transfer Events by Address AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get a list of ERC-20 - Token Transfer Events by Address AVAX")</inline-code> | <inline-code></inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20a%20list%20of%20ERC721%20-%20Token%20Transfer%20Events%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-a-list-of-erc721---token-transfer-events-by-address-avax) | **Get a list of ERC721 - Token Transfer Events by Address AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get a list of ERC721 - Token Transfer Events by Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Snowtrace/Get%20list%20of%20Blocks%20Validated%20by%20Address%20AVAX" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/snowtrace/get-list-of-blocks-validated-by-address-avax) | **Get list of Blocks Validated by Address AVAX** | <inline-code functionvalue=''>=CSQUERY("Snowtrace","Get list of Blocks Validated by Address AVAX")</inline-code> | <inline-code></inline-code> | 7 |

</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-Snowtrace">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-Snowtrace">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://snowtrace.io/">Click here</a>** for additional documentation from Snowtrace

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

---

Tags: `Snowtrace` `provider` 


How to pull Snowtrace data into Excel and Google Sheets