How to use Beac...

Example Paramet...

Example Fields:

Usage

Setup

Using the console

Using custom fu...

Using templates

Helpful Resources:

> Get all attestations during the last 100 epochs for up to 100 validators

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

This article demonstrates three examples of how to pull Beaconchain 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/beaconchain/console/get-all-attestations-during-the-last-100-epochs-for-up-to-100-validators.gif" />

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

## Example Parameters:

- indexOrPubkey: `0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa`

## Example Fields:

> This endpoint has no fields.


**Excel:**

<inline-code functionvalue='=CS.QUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})'>=CS.QUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})</inline-code>

**Googlesheets:**

<inline-code functionvalue='=CSQUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})'>=CSQUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})</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-Beaconchain)

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

  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 `Beaconchain...` then click on `Get all attestations during the last 100 epochs for up to 100 validators` 
  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/beaconchain/console/get-all-attestations-during-the-last-100-epochs-for-up-to-100-validators.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("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})`

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

`=CSQUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators",{"indexOrPubkey","0xaac86eac83f8e38a8f661bc6ecb80806fb4e9c0321c8c5559a5ebef6992e8f380890f7457a8aeb3123c951de30a18dfa"})`

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("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators")` for Excel or `=CSPARAMETERS("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators")` for Googlesheets

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/beaconchain/functions/get-all-attestations-during-the-last-100-epochs-for-up-to-100-validators.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 Beaconchain and Get all attestations during the last 100 epochs for up to 100 validators
  3. You can also try searching "Beaconchain..." 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-Beaconchain">
      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-Beaconchain">
      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 Beaconchain **[here](https://www.beaconcha.in/)**
 - See tutorials and examples for Beaconchain on the **[Cryptosheets YouTube channel]()**
 - Troubleshooting: please reference the following troubleshooting code: QUE-1807-5123. Learn more **[here](https://intercom.help/cryptosheets/en/)**

---
Tags: `Get all attestations during the last 100 epochs for up to 100 validators` `Beaconchain` `endpoint` 

How to pull Get all attestations during the last 100 epochs for up to 100 validators data from Beaconchain into Excel and Google Sheets

Get all attestations during the last 100 epochs for up to 100 validators