Excel

Google Sheets

> Solana blockchain explorer for defi, transactions, wallets, address, DEX exchange and much more

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Solscan">Solscan</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/Solscan/Block%20Last" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-last) | **Block Last** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Block Last")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Block%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-transactions) | **Block Transactions** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Block Transactions")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Block%20Block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-block) | **Block Block** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Block Block")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Transaction%20Last" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/transaction-last) | **Transaction Last** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Transaction Last")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Transaction%20Signature" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/transaction-signature) | **Transaction Signature** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Transaction Signature")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-tokens) | **Account Tokens** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account Tokens")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-transactions) | **Account Transactions** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account Transactions")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Stake%20Accounts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-stake-accounts) | **Account Stake Accounts** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account Stake Accounts")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20SPL%20Transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-spl-transfers) | **Account SPL Transfers** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account SPL Transfers")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20SOL%20Transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-sol-transfers) | **Account SOL Transfers** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account SOL Transfers")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Export%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-export-transactions) | **Account Export Transactions** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account Export Transactions")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Account" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-account) | **Account Account** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Account Account")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20Holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-holders) | **Token Holders** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Token Holders")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20Meta" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-meta) | **Token Meta** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Token Meta")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-list) | **Token List** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Token List")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Market%20Token%20Token%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/market-token-token-address) | **Market Token Token Address** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Market Token Token Address")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Chain%20Info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/chain-info) | **Chain Info** | <inline-code functionvalue=''>=CS.QUERY("Solscan","Chain Info")</inline-code> | <inline-code></inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Block%20Last" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-last) | **Block Last** | <inline-code functionvalue=''>=CSQUERY("Solscan","Block Last")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Block%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-transactions) | **Block Transactions** | <inline-code functionvalue=''>=CSQUERY("Solscan","Block Transactions")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Block%20Block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/block-block) | **Block Block** | <inline-code functionvalue=''>=CSQUERY("Solscan","Block Block")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Transaction%20Last" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/transaction-last) | **Transaction Last** | <inline-code functionvalue=''>=CSQUERY("Solscan","Transaction Last")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Transaction%20Signature" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/transaction-signature) | **Transaction Signature** | <inline-code functionvalue=''>=CSQUERY("Solscan","Transaction Signature")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-tokens) | **Account Tokens** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account Tokens")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-transactions) | **Account Transactions** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account Transactions")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Stake%20Accounts" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-stake-accounts) | **Account Stake Accounts** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account Stake Accounts")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20SPL%20Transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-spl-transfers) | **Account SPL Transfers** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account SPL Transfers")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20SOL%20Transfers" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-sol-transfers) | **Account SOL Transfers** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account SOL Transfers")</inline-code> | <inline-code></inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Export%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-export-transactions) | **Account Export Transactions** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account Export Transactions")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Account%20Account" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/account-account) | **Account Account** | <inline-code functionvalue=''>=CSQUERY("Solscan","Account Account")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20Holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-holders) | **Token Holders** | <inline-code functionvalue=''>=CSQUERY("Solscan","Token Holders")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20Meta" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-meta) | **Token Meta** | <inline-code functionvalue=''>=CSQUERY("Solscan","Token Meta")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/token-list) | **Token List** | <inline-code functionvalue=''>=CSQUERY("Solscan","Token List")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Market%20Token%20Token%20Address" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/market-token-token-address) | **Market Token Token Address** | <inline-code functionvalue=''>=CSQUERY("Solscan","Market Token Token Address")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Solscan/Chain%20Info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/solscan/chain-info) | **Chain Info** | <inline-code functionvalue=''>=CSQUERY("Solscan","Chain Info")</inline-code> | <inline-code></inline-code> | 0 |

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

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

---

Tags: `Solscan` `provider` 


How to pull Solscan data into Excel and Google Sheets