Excel

Google Sheets

> Token Lists is a community-led initiative to improve discoverability, reputation and trust in ERC20 token lists in a manner that is inclusive, transparent, and decentralized.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/TokenLists">TokenLists</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/TokenLists/1%20Inch%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/1-inch-list) | **1 Inch List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","1 Inch List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/CoinGecko%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/coingecko-list) | **CoinGecko List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","CoinGecko List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Compound%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/compound-list) | **Compound List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Compound List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Wrapped%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/wrapped-tokens) | **Wrapped Tokens** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Wrapped Tokens")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Tryroll%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/tryroll-list) | **Tryroll List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Tryroll List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Uniswap%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/uniswap-list) | **Uniswap List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Uniswap List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Uma%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/uma-list) | **Uma List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Uma List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/CoinmarketCap%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/coinmarketcap-list) | **CoinmarketCap List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","CoinmarketCap List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Messari%20Verified" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/messari-verified) | **Messari Verified** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Messari Verified")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Opyn%20v1%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/opyn-v1-token-list) | **Opyn v1 Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Opyn v1 Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/ZapperFi%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/zapperfi-token-list) | **ZapperFi Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","ZapperFi Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Synthetix" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/synthetix) | **Synthetix** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Synthetix")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Kleros%20T2CR%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/kleros-t2cr-token-list) | **Kleros T2CR Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Kleros T2CR Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Testnet%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/testnet-token-list) | **Testnet Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Testnet Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/AAVE%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/aave-token-list) | **AAVE Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","AAVE Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Dharma%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/dharma-token-list) | **Dharma Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Dharma Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Zerion%20Explore%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/zerion-explore-token-list) | **Zerion Explore Token List** | <inline-code functionvalue=''>=CS.QUERY("TokenLists","Zerion Explore Token List")</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/TokenLists/1%20Inch%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/1-inch-list) | **1 Inch List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","1 Inch List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/CoinGecko%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/coingecko-list) | **CoinGecko List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","CoinGecko List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Compound%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/compound-list) | **Compound List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Compound List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Wrapped%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/wrapped-tokens) | **Wrapped Tokens** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Wrapped Tokens")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Tryroll%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/tryroll-list) | **Tryroll List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Tryroll List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Uniswap%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/uniswap-list) | **Uniswap List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Uniswap List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Uma%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/uma-list) | **Uma List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Uma List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/CoinmarketCap%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/coinmarketcap-list) | **CoinmarketCap List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","CoinmarketCap List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Messari%20Verified" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/messari-verified) | **Messari Verified** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Messari Verified")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Opyn%20v1%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/opyn-v1-token-list) | **Opyn v1 Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Opyn v1 Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/ZapperFi%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/zapperfi-token-list) | **ZapperFi Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","ZapperFi Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Synthetix" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/synthetix) | **Synthetix** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Synthetix")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Kleros%20T2CR%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/kleros-t2cr-token-list) | **Kleros T2CR Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Kleros T2CR Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Testnet%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/testnet-token-list) | **Testnet Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Testnet Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/AAVE%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/aave-token-list) | **AAVE Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","AAVE Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Dharma%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/dharma-token-list) | **Dharma Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Dharma Token List")</inline-code> | <inline-code></inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/TokenLists/Zerion%20Explore%20Token%20List" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/tokenlists/zerion-explore-token-list) | **Zerion Explore Token List** | <inline-code functionvalue=''>=CSQUERY("TokenLists","Zerion Explore Token List")</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-TokenLists">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-TokenLists">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://tokenlists.org/">Click here</a>** for additional documentation from TokenLists

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

---

Tags: `TokenLists` `provider` 


How to pull TokenLists data into Excel and Google Sheets