Excel

Google Sheets

> Polygon MATIC is a Layer 2 L2 protocol and a framework for building and connecting ETH EVM Ethereum-compatible blockchain networks.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Polygonscan">Polygonscan</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/Polygonscan/Get%20MATIC%20Balance%20for%20a%20single%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-matic-balance-for-a-single-address) | **Get MATIC Balance for a single Address** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get MATIC Balance for a single Address",{"module","account";"action","balance";"address","0x0000000000000000000000000000000000001010";"tag","latest";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get MATIC Balance for a single Address")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get MATIC Balance for a single Address")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20MATIC%20Balance%20for%20multiple%20Addresses%20in%20a%20single%20call" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-matic-balance-for-multiple-addresses-in-a-single-call) | **Get MATIC Balance for multiple Addresses in a single call** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get MATIC Balance for multiple Addresses in a single call",{"module","account";"action","balancemulti";"address","0x0000000000000000000000000000000000001010,0x0000000000000000000000000000000000001010,0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c";"tag","latest";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get MATIC Balance for multiple Addresses in a single call")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get MATIC Balance for multiple Addresses in a single call")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20Normal%20Transactions%20By%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-normal-transactions-by-address-matic) | **Get a list of Normal Transactions By Address MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get a list of Normal Transactions By Address MATIC",{"module","account";"action","txlist";"address","0x0000000000000000000000000000000000001010";"startblock","1";"endblock","99999999";"sort","asc";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get a list of Normal Transactions By Address MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get a list of Normal Transactions By Address MATIC")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20Internal%20Transactions%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-internal-transactions-by-address-matic) | **Get a list of Internal Transactions by Address MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get a list of Internal Transactions by Address MATIC",{"module","account";"action","txlist";"address","0x0000000000000000000000000000000000001010";"startblock","1";"endblock","99999999";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get a list of Internal Transactions by Address MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get a list of Internal Transactions by Address MATIC")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20Internal%20Transactions%20by%20Transaction%20Hash%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-internal-transactions-by-transaction-hash-matic) | **Get Internal Transactions by Transaction Hash MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get Internal Transactions by Transaction Hash MATIC",{"module","account";"action","txlistinternal";"address","0x0000000000000000000000000000000000001010";"startblock","0";"endblock","2702578";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get Internal Transactions by Transaction Hash MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get Internal Transactions by Transaction Hash MATIC")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20Internal%20Transactions%20by%20Range%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-internal-transactions-by-range-matic) | **Get Internal Transactions by Range MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get Internal Transactions by Range MATIC",{"module","account";"action","txlistinternal";"startblock","0";"endblock","2702578";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get Internal Transactions by Range MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get Internal Transactions by Range MATIC")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20ERC-20%20-%20Token%20Transfer%20Events%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-erc-20---token-transfer-events-by-address-matic) | **Get a list of ERC-20 - Token Transfer Events by Address MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC",{"module","account";"action","tokentx";"contractaddress","0x2791bca1f2de4661ed88a30c99a7a9449aa84174";"address","0x0000000000000000000000000000000000001010";"page","1";"offset","100";"sort","asc";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20ERC721%20-%20Token%20Transfer%20Events%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-erc721---token-transfer-events-by-address-matic) | **Get a list of ERC721 - Token Transfer Events by Address MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC",{"module","account";"action","tokennfttx";"contractaddress","0xf556faf23fc2feefa33ee6db2d1ee4c70e534513";"address","0x0910741516743fbf6e6d796e8c5a033ff953a0ee";"page","1";"offset","100";"sort","asc"})'>=CS.QUERY("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20list%20of%20Blocks%20Validated%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-list-of-blocks-validated-by-address-matic) | **Get list of Blocks Validated by Address MATIC** | <inline-code functionvalue='=CS.QUERY("Polygonscan","Get list of Blocks Validated by Address MATIC",{"module","account";"action","getminedblocks";"address","0x46a3a41bd932244dd08186e4c19f1a7e48cbcdf4";"blocktype","blocks";"page","1";"offset","10";"apikey","YourApiKeyToken"})'>=CS.QUERY("Polygonscan","Get list of Blocks Validated by Address MATIC")</inline-code> | <inline-code>=CS.PARAMETERS("Polygonscan","Get list of Blocks Validated by Address MATIC")</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/Polygonscan/Get%20MATIC%20Balance%20for%20a%20single%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-matic-balance-for-a-single-address) | **Get MATIC Balance for a single Address** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get MATIC Balance for a single Address",{"module","account";"action","balance";"address","0x0000000000000000000000000000000000001010";"tag","latest";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get MATIC Balance for a single Address")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get MATIC Balance for a single Address")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20MATIC%20Balance%20for%20multiple%20Addresses%20in%20a%20single%20call" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-matic-balance-for-multiple-addresses-in-a-single-call) | **Get MATIC Balance for multiple Addresses in a single call** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get MATIC Balance for multiple Addresses in a single call",{"module","account";"action","balancemulti";"address","0x0000000000000000000000000000000000001010,0x0000000000000000000000000000000000001010,0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c";"tag","latest";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get MATIC Balance for multiple Addresses in a single call")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get MATIC Balance for multiple Addresses in a single call")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20Normal%20Transactions%20By%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-normal-transactions-by-address-matic) | **Get a list of Normal Transactions By Address MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get a list of Normal Transactions By Address MATIC",{"module","account";"action","txlist";"address","0x0000000000000000000000000000000000001010";"startblock","1";"endblock","99999999";"sort","asc";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get a list of Normal Transactions By Address MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get a list of Normal Transactions By Address MATIC")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20Internal%20Transactions%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-internal-transactions-by-address-matic) | **Get a list of Internal Transactions by Address MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get a list of Internal Transactions by Address MATIC",{"module","account";"action","txlist";"address","0x0000000000000000000000000000000000001010";"startblock","1";"endblock","99999999";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get a list of Internal Transactions by Address MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get a list of Internal Transactions by Address MATIC")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20Internal%20Transactions%20by%20Transaction%20Hash%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-internal-transactions-by-transaction-hash-matic) | **Get Internal Transactions by Transaction Hash MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get Internal Transactions by Transaction Hash MATIC",{"module","account";"action","txlistinternal";"address","0x0000000000000000000000000000000000001010";"startblock","0";"endblock","2702578";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get Internal Transactions by Transaction Hash MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get Internal Transactions by Transaction Hash MATIC")</inline-code> | 9 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20Internal%20Transactions%20by%20Range%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-internal-transactions-by-range-matic) | **Get Internal Transactions by Range MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get Internal Transactions by Range MATIC",{"module","account";"action","txlistinternal";"startblock","0";"endblock","2702578";"page","1";"offset","10";"sort","asc";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get Internal Transactions by Range MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get Internal Transactions by Range MATIC")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20ERC-20%20-%20Token%20Transfer%20Events%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-erc-20---token-transfer-events-by-address-matic) | **Get a list of ERC-20 - Token Transfer Events by Address MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC",{"module","account";"action","tokentx";"contractaddress","0x2791bca1f2de4661ed88a30c99a7a9449aa84174";"address","0x0000000000000000000000000000000000001010";"page","1";"offset","100";"sort","asc";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get a list of ERC-20 - Token Transfer Events by Address MATIC")</inline-code> | 8 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20a%20list%20of%20ERC721%20-%20Token%20Transfer%20Events%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-a-list-of-erc721---token-transfer-events-by-address-matic) | **Get a list of ERC721 - Token Transfer Events by Address MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC",{"module","account";"action","tokennfttx";"contractaddress","0xf556faf23fc2feefa33ee6db2d1ee4c70e534513";"address","0x0910741516743fbf6e6d796e8c5a033ff953a0ee";"page","1";"offset","100";"sort","asc"})'>=CSQUERY("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get a list of ERC721 - Token Transfer Events by Address MATIC")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/Polygonscan/Get%20list%20of%20Blocks%20Validated%20by%20Address%20MATIC" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/polygonscan/get-list-of-blocks-validated-by-address-matic) | **Get list of Blocks Validated by Address MATIC** | <inline-code functionvalue='=CSQUERY("Polygonscan","Get list of Blocks Validated by Address MATIC",{"module","account";"action","getminedblocks";"address","0x46a3a41bd932244dd08186e4c19f1a7e48cbcdf4";"blocktype","blocks";"page","1";"offset","10";"apikey","YourApiKeyToken"})'>=CSQUERY("Polygonscan","Get list of Blocks Validated by Address MATIC")</inline-code> | <inline-code>=CSPARAMETERS("Polygonscan","Get list of Blocks Validated by Address MATIC")</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-Polygonscan">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-Polygonscan">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://polygonscan.com/">Click here</a>** for additional documentation from Polygonscan

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

---

Tags: `Polygonscan` `provider` 


How to pull Polygonscan data into Excel and Google Sheets