Excel

Google Sheets

> DeBank is an all-in-one DeFi wallet, from where you can track DeFi portfolios, wallets, explore DeFi projects, compare DeFi rates across multiple protocols, chains and much more

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/DeBank">DeBank</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/DeBank/Get%20Chain%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-chain-r) | **Get Chain R** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Chain R")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Chain%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-chain-list) | **Get Chain List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Chain List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Protocol%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-protocol-r) | **Get Protocol R** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Protocol R")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Protocol%20List%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-protocol-list-r) | **Get Protocol List R** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Protocol List R")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Tvl" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-tvl) | **Get Tvl** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Tvl")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Token%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-token-r) | **Get Token R** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Token R")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Token%20List%20By%20Ids%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-token-list-by-ids-r) | **Get Token List By Ids R** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Token List By Ids R")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Chain%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-chain-balance) | **Get User Chain Balance** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Chain Balance")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Complex%20Protocol%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-complex-protocol-list) | **Get User Complex Protocol List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Complex Protocol List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Nft%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-nft-list) | **Get User Nft List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Nft List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Protocol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-protocol) | **Get User Protocol** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Protocol")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Simple%20Protocol%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-simple-protocol-list) | **Get User Simple Protocol List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Simple Protocol List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token) | **Get User Token** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Token")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20Authorized%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-authorized-list) | **Get User Token Authorized List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Token Authorized List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-list) | **Get User Token List** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Token List")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20Search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-search) | **Get User Token Search** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Token Search")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Total%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-total-balance) | **Get User Total Balance** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get User Total Balance")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Check%20Origin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-check-origin) | **Get Check Origin** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Check Origin")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Url%20Config" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-url-config) | **Get Url Config** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Url Config")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Ens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-ens) | **Get Ens** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Ens")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Explain%20Origin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-explain-origin) | **Get Explain Origin** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Explain Origin")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Gas%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-gas-market) | **Get Gas Market** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Gas Market")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Explain%20Tx" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-explain-tx) | **Get Explain Tx** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Explain Tx")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Pending%20Tx%20Count" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-pending-tx-count) | **Get Pending Tx Count** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Pending Tx Count")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Recommend%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-recommend-chains) | **Get Recommend Chains** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Recommend Chains")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Support%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-support-chains) | **Get Support Chains** | <inline-code functionvalue=''>=CS.QUERY("DeBank","Get Support Chains")</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/DeBank/Get%20Chain%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-chain-r) | **Get Chain R** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Chain R")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Chain%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-chain-list) | **Get Chain List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Chain List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Protocol%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-protocol-r) | **Get Protocol R** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Protocol R")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Protocol%20List%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-protocol-list-r) | **Get Protocol List R** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Protocol List R")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Tvl" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-tvl) | **Get Tvl** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Tvl")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Token%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-token-r) | **Get Token R** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Token R")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Token%20List%20By%20Ids%20R" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-token-list-by-ids-r) | **Get Token List By Ids R** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Token List By Ids R")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Chain%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-chain-balance) | **Get User Chain Balance** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Chain Balance")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Complex%20Protocol%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-complex-protocol-list) | **Get User Complex Protocol List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Complex Protocol List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Nft%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-nft-list) | **Get User Nft List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Nft List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Protocol" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-protocol) | **Get User Protocol** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Protocol")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Simple%20Protocol%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-simple-protocol-list) | **Get User Simple Protocol List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Simple Protocol List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token) | **Get User Token** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Token")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20Authorized%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-authorized-list) | **Get User Token Authorized List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Token Authorized List")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-list) | **Get User Token List** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Token List")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Token%20Search" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-token-search) | **Get User Token Search** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Token Search")</inline-code> | <inline-code></inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20User%20Total%20Balance" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-user-total-balance) | **Get User Total Balance** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get User Total Balance")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Check%20Origin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-check-origin) | **Get Check Origin** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Check Origin")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Url%20Config" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-url-config) | **Get Url Config** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Url Config")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Ens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-ens) | **Get Ens** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Ens")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Explain%20Origin" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-explain-origin) | **Get Explain Origin** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Explain Origin")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Gas%20Market" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-gas-market) | **Get Gas Market** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Gas Market")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Explain%20Tx" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-explain-tx) | **Get Explain Tx** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Explain Tx")</inline-code> | <inline-code></inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Pending%20Tx%20Count" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-pending-tx-count) | **Get Pending Tx Count** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Pending Tx Count")</inline-code> | <inline-code></inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Recommend%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-recommend-chains) | **Get Recommend Chains** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Recommend Chains")</inline-code> | <inline-code></inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeBank/Get%20Support%20Chains" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/debank/get-support-chains) | **Get Support Chains** | <inline-code functionvalue=''>=CSQUERY("DeBank","Get Support Chains")</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-DeBank">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-DeBank">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://debank.com/">Click here</a>** for additional documentation from DeBank

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

---

Tags: `DeBank` `provider` 


How to pull DeBank data into Excel and Google Sheets