Excel

Google Sheets

> Your home for all NEO related blockchain information

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Neoscan">Neoscan</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/Neoscan/Get%20Address%20Transactions%20Summary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-transactions-summary) | **Get Address Transactions Summary** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Transactions Summary",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ";"page","1"})'>=CS.QUERY("Neoscan","Get Address Transactions Summary")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Transactions Summary")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Pair%20Transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-pair-transaction) | **Get Address Pair Transaction** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Pair Transaction",{"address1","FENZVxTtw5XNYJxKSMGHPnk1rN5v4mUPim4vb6bDzStV";"address2","57LqigABq7jaVUFQK6jN5LEDYjzMmJeCEr9QeFvTnxGs";"page","1"})'>=CS.QUERY("Neoscan","Get Address Pair Transaction")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Pair Transaction")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20All%20Neo%20Nodes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-all-neo-nodes) | **Get All Neo Nodes** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get All Neo Nodes")'>=CS.QUERY("Neoscan","Get All Neo Nodes")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get All Neo Nodes")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-balance) | **Get Address Balance** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Balance",{"address","57LqigABq7jaVUFQK6jN5LEDYjzMmJeCEr9QeFvTnxGs"})'>=CS.QUERY("Neoscan","Get Address Balance")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Balance")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-block) | **Get Block** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Block",{"block_hash","27991c3cc475f46ed729115ed93fd5b08bf54548b34ebab5ca6ac1775db74ed3"})'>=CS.QUERY("Neoscan","Get Block")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Block")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Claimable%20Transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-claimable-transaction) | **Get Address Claimable Transaction** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Claimable Transaction",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CS.QUERY("Neoscan","Get Address Claimable Transaction")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Claimable Transaction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20ClaimedTransaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-claimedtransaction) | **Get Address ClaimedTransaction** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address ClaimedTransaction",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CS.QUERY("Neoscan","Get Address ClaimedTransaction")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address ClaimedTransaction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Last%20Block%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-last-block-index) | **Get Last Block Index** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Last Block Index")'>=CS.QUERY("Neoscan","Get Last Block Index")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Last Block Index")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Last%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-last-transactions) | **Get Address Last Transactions** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Last Transactions",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ";"page","1"})'>=CS.QUERY("Neoscan","Get Address Last Transactions")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Last Transactions")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Transaction%20Hash" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-transaction-hash) | **Get Transaction Hash** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Transaction Hash",{"transaction_hash","e910759f0243401d4de38e9b8d96eba53950d13e7c78779d395d63a9a1ab9f1c"})'>=CS.QUERY("Neoscan","Get Transaction Hash")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Transaction Hash")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Unclaimed%20Gas" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-unclaimed-gas) | **Get Address Unclaimed Gas** | <inline-code functionvalue='=CS.QUERY("Neoscan","Get Address Unclaimed Gas",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CS.QUERY("Neoscan","Get Address Unclaimed Gas")</inline-code> | <inline-code>=CS.PARAMETERS("Neoscan","Get Address Unclaimed Gas")</inline-code> | 1 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Transactions%20Summary" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-transactions-summary) | **Get Address Transactions Summary** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Transactions Summary",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ";"page","1"})'>=CSQUERY("Neoscan","Get Address Transactions Summary")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Transactions Summary")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Pair%20Transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-pair-transaction) | **Get Address Pair Transaction** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Pair Transaction",{"address1","FENZVxTtw5XNYJxKSMGHPnk1rN5v4mUPim4vb6bDzStV";"address2","57LqigABq7jaVUFQK6jN5LEDYjzMmJeCEr9QeFvTnxGs";"page","1"})'>=CSQUERY("Neoscan","Get Address Pair Transaction")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Pair Transaction")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20All%20Neo%20Nodes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-all-neo-nodes) | **Get All Neo Nodes** | <inline-code functionvalue='=CSQUERY("Neoscan","Get All Neo Nodes")'>=CSQUERY("Neoscan","Get All Neo Nodes")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get All Neo Nodes")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-balance) | **Get Address Balance** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Balance",{"address","57LqigABq7jaVUFQK6jN5LEDYjzMmJeCEr9QeFvTnxGs"})'>=CSQUERY("Neoscan","Get Address Balance")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Balance")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-block) | **Get Block** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Block",{"block_hash","27991c3cc475f46ed729115ed93fd5b08bf54548b34ebab5ca6ac1775db74ed3"})'>=CSQUERY("Neoscan","Get Block")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Block")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Claimable%20Transaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-claimable-transaction) | **Get Address Claimable Transaction** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Claimable Transaction",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CSQUERY("Neoscan","Get Address Claimable Transaction")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Claimable Transaction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20ClaimedTransaction" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-claimedtransaction) | **Get Address ClaimedTransaction** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address ClaimedTransaction",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CSQUERY("Neoscan","Get Address ClaimedTransaction")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address ClaimedTransaction")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Last%20Block%20Index" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-last-block-index) | **Get Last Block Index** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Last Block Index")'>=CSQUERY("Neoscan","Get Last Block Index")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Last Block Index")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Last%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-last-transactions) | **Get Address Last Transactions** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Last Transactions",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ";"page","1"})'>=CSQUERY("Neoscan","Get Address Last Transactions")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Last Transactions")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Transaction%20Hash" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-transaction-hash) | **Get Transaction Hash** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Transaction Hash",{"transaction_hash","e910759f0243401d4de38e9b8d96eba53950d13e7c78779d395d63a9a1ab9f1c"})'>=CSQUERY("Neoscan","Get Transaction Hash")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Transaction Hash")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Neoscan/Get%20Address%20Unclaimed%20Gas" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/neoscan/get-address-unclaimed-gas) | **Get Address Unclaimed Gas** | <inline-code functionvalue='=CSQUERY("Neoscan","Get Address Unclaimed Gas",{"address","7D746efAyhngHRos3vF2kb6tvb57hQdLzAUdQFsVFCQ"})'>=CSQUERY("Neoscan","Get Address Unclaimed Gas")</inline-code> | <inline-code>=CSPARAMETERS("Neoscan","Get Address Unclaimed Gas")</inline-code> | 1 |

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

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

---

Tags: `Neoscan` `provider` 


How to pull Neoscan data into Excel and Google Sheets