How to use Toke...

Example Paramet...

Example Fields:

Usage

Setup

Using the console

Using custom fu...

Using templates

Helpful Resources:

> Get the top 200 wallet addresses of token rich list through the token abbreviation and hash, including the wallet balance sorted in descending order.

## How to use TokenView data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull TokenView API data into your spreadsheet using the `side panel console`,  `custom functions` and `templates`.

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/tokenview/console/list-of-the-top-200-addresses-for-the-balance-of-token.gif" />

Explore more TokenView endpoints [here](https://app.cryptosheets.com/#/browse/TokenView)

## Example Parameters:

- chain_token_address: `eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca`
- apikey: `Your_apikey`

## Example Fields:

> This endpoint has no fields.


**Excel:**

<inline-code functionvalue='=CS.QUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})'>=CS.QUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})</inline-code>

**Googlesheets:**

<inline-code functionvalue='=CSQUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})'>=CSQUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})</inline-code>


> NOTE: Some international users may need to substitute commas `","` in custom functions with semicolons `";"` so for something like `=CS.TA("BTC","USD")` try `=CS.TA("BTC";"USD")` instead


## Usage

Cryptosheets data can be pulled through multiple interfaces:

<details>
  <summary>Setup</summary>

### Setup

  1. Install the Cryptosheets add-in from the [Microsoft AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-TokenView)

  2. Install the Cryptosheets add-in from the [Google GSuite Marketplace](https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?src=intercom-TokenView)

  3. After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

  <img src="https://res.cloudinary.com/cryptosheets/image/upload/v1570534844/cryptosheets-docs/excel/install.png" />

  <img src="https://res.cloudinary.com/cryptosheets/image/upload/v1570537238/cryptosheets-docs/excel/login.png" />

  <img src="https://downloads.intercomcdn.com/i/o/223225643/14f5d809cb6dd07fd8e7b8c1/image.png" />

  <img src="https://cryptosheets.intercom-attachments-1.com/i/o/223227015/6af83d71cec3605f4608e834/cryptosheets-docs_google_login_addons-drop-down-menu.png" />

</details>

<details>
  <summary>Using the console</summary>

### Using the console
  1. From the Cryptosheets **Excel ribbon** click `data`
  2. From the **Googlesheets Add-ons menu** click `Cryptosheets` then select `Launch side-bar`
  3. Type in `TokenView...` then click on `List of the top 200 addresses for the balance of token` 
  4. Scroll through the console parameters and input your values
  5. Select the cell you want to place the data into
  6. Click `make request`

[![img](https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png)](https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png)

[![img](https://res.cloudinary.com/cryptosheets/image/v1/upload/cryptosheets-docs/google/menu/data-browse-providers.png)](https://res.cloudinary.com/cryptosheets/image/v1/upload/cryptosheets-docs/google/menu/data-browse-providers.png)


<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1568230681/cryptosheets-docs/providers/tokenview/console/list-of-the-top-200-addresses-for-the-balance-of-token.gif" />

</details>

<details>
  <summary>Using custom functions</summary>

### Using custom functions

<video-player></video-player>

> **Tip**: For both Excel and Googlesheeets you can use either the **[QUERY](https://docs.cryptosheets.com/functions/query)** or **[QUERYA](https://docs.cryptosheets.com/functions/querya)** custom function

1. **Excel** In any cell type the following: 

`=CS.QUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})`

2. **Googlesheets** In any cell type the following: 

`=CSQUERY("TokenView","List of the top 200 addresses for the balance of token",{"chain_token_address","eth_0xe36df5bb57e80629cfc28a31e5f794071c085eca";"apikey","Your_apikey"})`

3. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the `function/formula builder`, then click the `clipboard icon` to copy the full formula string and paste it into any cell **[see detailed examples and tutorial](https://intercom.help/cryptosheets/en/articles/3472916-using-the-cryptosheets-api-console-query-and-function-formula-builder-for-excel-googlesheets)**

<img src="https://downloads.intercomcdn.com/i/o/161179379/577ba7c6149cd8827b598623/image.png" />

> **Hint**: If you need help remembering the exact parameters for any function, you can always just type in any cell: `=CS.PARAMETERS("TokenView","List of the top 200 addresses for the balance of token")` for Excel or `=CSPARAMETERS("TokenView","List of the top 200 addresses for the balance of token")` for Googlesheets

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/tokenview/functions/list-of-the-top-200-addresses-for-the-balance-of-token.gif" />

</details>

<details>
  <summary>Using templates</summary>

### Using templates
  1. From the Cryptosheets Excel ribbon click `templates` OR click on the `templates tab` in the browse section
  2. From the Googlesheets Add-ons menu click `Cryptosheets` then select `Templates`
  2. Load the template called `Query Builder` and type TokenView and List of the top 200 addresses for the balance of token
  3. You can also try searching "TokenView..." for other templates 

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/templates/gifs/query-builder-provider-endpoint.gif" />

</details>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

<ul>
  <li>
    <b><a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-TokenView">
      Get Cryptosheets for Microsoft Excel
    </a></b>
  </li>
  <li>
   <b><a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget&src=docs-TokenView">
      Get Cryptosheets for Googlesheets
    </a></b>
  </li>
</ul>

> 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. Learn more [here](https://intercom.help/cryptosheets/en/)

## Helpful Resources:
 - Visit the API documentation for TokenView **[here](https://documenter.getpostman.com/view/5728777/SVSEvX8k?version&#x3D;latest)**
 - See tutorials and examples for TokenView on the **[Cryptosheets YouTube channel](https://www.youtube.com/channel/UCReKkrBSlgKgNJlWHLASiPQ)**
 - Troubleshooting: please reference the following troubleshooting code: QUE-1670-4816. Learn more **[here](https://intercom.help/cryptosheets/en/)**

---
Tags: `List of the top 200 addresses for the balance of token` `TokenView` `endpoint` 

How to pull List of the top 200 addresses for the balance of token data from TokenView into Excel and Google Sheets

List of the top 200 addresses for the balance of token