> High performance API for querying information from the Ethereum 2.0 beacon chain Find examples for accessing every **Beaconchain** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/beaconchain/health-of-the-explorer) | **Health of the explorer** | =CS.QUERY("Beaconchain","Health of the explorer") | =CS.PARAMETERS("Beaconchain","Health of the explorer") | 0 | | Try It | [Docs](/providers/beaconchain/get-block) | **Get block** | =CS.QUERY("Beaconchain","Get block") | =CS.PARAMETERS("Beaconchain","Get block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-attestations-included-in-a-specific-block) | **Get the attestations included in a specific block** | =CS.QUERY("Beaconchain","Get the attestations included in a specific block") | =CS.PARAMETERS("Beaconchain","Get the attestations included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-attester-slashings-included-in-a-specific-block) | **Get the attester slashings included in a specific block** | =CS.QUERY("Beaconchain","Get the attester slashings included in a specific block") | =CS.PARAMETERS("Beaconchain","Get the attester slashings included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-deposits-included-in-a-specific-block) | **Get the deposits included in a specific block** | =CS.QUERY("Beaconchain","Get the deposits included in a specific block") | =CS.PARAMETERS("Beaconchain","Get the deposits included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-proposer-slashings-included-in-a-specific-block) | **Get the proposer slashings included in a specific block** | =CS.QUERY("Beaconchain","Get the proposer slashings included in a specific block") | =CS.PARAMETERS("Beaconchain","Get the proposer slashings included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-voluntary-exits-included-in-a-specific-block) | **Get the voluntary exits included in a specific block** | =CS.QUERY("Beaconchain","Get the voluntary exits included in a specific block") | =CS.PARAMETERS("Beaconchain","Get the voluntary exits included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/returns-charts-from-the-page-https://beaconcha.in/charts-as-png) | **Returns charts from the page https://beaconcha.in/charts as PNG** | =CS.QUERY("Beaconchain","Returns charts from the page https://beaconcha.in/charts as PNG") | =CS.PARAMETERS("Beaconchain","Returns charts from the page https://beaconcha.in/charts as PNG") | 1 | | Try It | [Docs](/providers/beaconchain/get-epoch-by-number) | **Get epoch by number** | =CS.QUERY("Beaconchain","Get epoch by number") | =CS.PARAMETERS("Beaconchain","Get epoch by number") | 1 | | Try It | [Docs](/providers/beaconchain/get-epoch-blocks-by-epoch-number) | **Get epoch blocks by epoch number** | =CS.QUERY("Beaconchain","Get epoch blocks by epoch number") | =CS.PARAMETERS("Beaconchain","Get epoch blocks by epoch number") | 1 | | Try It | [Docs](/providers/beaconchain/get-an-eth1-deposit-by-its-eth1-transaction-hash) | **Get an eth1 deposit by its eth1 transaction hash** | =CS.QUERY("Beaconchain","Get an eth1 deposit by its eth1 transaction hash") | =CS.PARAMETERS("Beaconchain","Get an eth1 deposit by its eth1 transaction hash") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-validators-that-belong-to-an-eth1-address) | **Get all validators that belong to an eth1 address** | =CS.QUERY("Beaconchain","Get all validators that belong to an eth1 address") | =CS.PARAMETERS("Beaconchain","Get all validators that belong to an eth1 address") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-current-top-100-performing-validators-(using-the-income-over-the-last-7-days)) | **Get the current top 100 performing validators (using the income over the last 7 days)** | =CS.QUERY("Beaconchain","Get the current top 100 performing validators (using the income over the last 7 days)") | =CS.PARAMETERS("Beaconchain","Get the current top 100 performing validators (using the income over the last 7 days)") | 0 | | Try It | [Docs](/providers/beaconchain/get-up-to-100-validators-by-their-index) | **Get up to 100 validators by their index** | =CS.QUERY("Beaconchain","Get up to 100 validators by their index") | =CS.PARAMETERS("Beaconchain","Get up to 100 validators by their index") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-attestations-during-the-last-100-epochs-for-up-to-100-validators) | **Get all attestations during the last 100 epochs for up to 100 validators** | =CS.QUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators") | =CS.PARAMETERS("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-balance-history-(last-100-epochs)-of-up-to-100-validators) | **Get the balance history (last 100 epochs) of up to 100 validators** | =CS.QUERY("Beaconchain","Get the balance history (last 100 epochs) of up to 100 validators") | =CS.PARAMETERS("Beaconchain","Get the balance history (last 100 epochs) of up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-eth1-deposits-for-up-to-100-validators) | **Get all eth1 deposits for up to 100 validators** | =CS.QUERY("Beaconchain","Get all eth1 deposits for up to 100 validators") | =CS.PARAMETERS("Beaconchain","Get all eth1 deposits for up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-current-performance-of-up-to-100-validators) | **Get the current performance of up to 100 validators** | =CS.QUERY("Beaconchain","Get the current performance of up to 100 validators") | =CS.PARAMETERS("Beaconchain","Get the current performance of up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-proposed-blocks-during-the-last-100-epochs-for-up-to-100-validators) | **Get all proposed blocks during the last 100 epochs for up to 100 validators** | =CS.QUERY("Beaconchain","Get all proposed blocks during the last 100 epochs for up to 100 validators") | =CS.PARAMETERS("Beaconchain","Get all proposed blocks during the last 100 epochs for up to 100 validators") | 1 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/beaconchain/health-of-the-explorer) | **Health of the explorer** | =CSQUERY("Beaconchain","Health of the explorer") | =CSPARAMETERS("Beaconchain","Health of the explorer") | 0 | | Try It | [Docs](/providers/beaconchain/get-block) | **Get block** | =CSQUERY("Beaconchain","Get block") | =CSPARAMETERS("Beaconchain","Get block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-attestations-included-in-a-specific-block) | **Get the attestations included in a specific block** | =CSQUERY("Beaconchain","Get the attestations included in a specific block") | =CSPARAMETERS("Beaconchain","Get the attestations included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-attester-slashings-included-in-a-specific-block) | **Get the attester slashings included in a specific block** | =CSQUERY("Beaconchain","Get the attester slashings included in a specific block") | =CSPARAMETERS("Beaconchain","Get the attester slashings included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-deposits-included-in-a-specific-block) | **Get the deposits included in a specific block** | =CSQUERY("Beaconchain","Get the deposits included in a specific block") | =CSPARAMETERS("Beaconchain","Get the deposits included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-proposer-slashings-included-in-a-specific-block) | **Get the proposer slashings included in a specific block** | =CSQUERY("Beaconchain","Get the proposer slashings included in a specific block") | =CSPARAMETERS("Beaconchain","Get the proposer slashings included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-voluntary-exits-included-in-a-specific-block) | **Get the voluntary exits included in a specific block** | =CSQUERY("Beaconchain","Get the voluntary exits included in a specific block") | =CSPARAMETERS("Beaconchain","Get the voluntary exits included in a specific block") | 1 | | Try It | [Docs](/providers/beaconchain/returns-charts-from-the-page-https://beaconcha.in/charts-as-png) | **Returns charts from the page https://beaconcha.in/charts as PNG** | =CSQUERY("Beaconchain","Returns charts from the page https://beaconcha.in/charts as PNG") | =CSPARAMETERS("Beaconchain","Returns charts from the page https://beaconcha.in/charts as PNG") | 1 | | Try It | [Docs](/providers/beaconchain/get-epoch-by-number) | **Get epoch by number** | =CSQUERY("Beaconchain","Get epoch by number") | =CSPARAMETERS("Beaconchain","Get epoch by number") | 1 | | Try It | [Docs](/providers/beaconchain/get-epoch-blocks-by-epoch-number) | **Get epoch blocks by epoch number** | =CSQUERY("Beaconchain","Get epoch blocks by epoch number") | =CSPARAMETERS("Beaconchain","Get epoch blocks by epoch number") | 1 | | Try It | [Docs](/providers/beaconchain/get-an-eth1-deposit-by-its-eth1-transaction-hash) | **Get an eth1 deposit by its eth1 transaction hash** | =CSQUERY("Beaconchain","Get an eth1 deposit by its eth1 transaction hash") | =CSPARAMETERS("Beaconchain","Get an eth1 deposit by its eth1 transaction hash") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-validators-that-belong-to-an-eth1-address) | **Get all validators that belong to an eth1 address** | =CSQUERY("Beaconchain","Get all validators that belong to an eth1 address") | =CSPARAMETERS("Beaconchain","Get all validators that belong to an eth1 address") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-current-top-100-performing-validators-(using-the-income-over-the-last-7-days)) | **Get the current top 100 performing validators (using the income over the last 7 days)** | =CSQUERY("Beaconchain","Get the current top 100 performing validators (using the income over the last 7 days)") | =CSPARAMETERS("Beaconchain","Get the current top 100 performing validators (using the income over the last 7 days)") | 0 | | Try It | [Docs](/providers/beaconchain/get-up-to-100-validators-by-their-index) | **Get up to 100 validators by their index** | =CSQUERY("Beaconchain","Get up to 100 validators by their index") | =CSPARAMETERS("Beaconchain","Get up to 100 validators by their index") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-attestations-during-the-last-100-epochs-for-up-to-100-validators) | **Get all attestations during the last 100 epochs for up to 100 validators** | =CSQUERY("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators") | =CSPARAMETERS("Beaconchain","Get all attestations during the last 100 epochs for up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-balance-history-(last-100-epochs)-of-up-to-100-validators) | **Get the balance history (last 100 epochs) of up to 100 validators** | =CSQUERY("Beaconchain","Get the balance history (last 100 epochs) of up to 100 validators") | =CSPARAMETERS("Beaconchain","Get the balance history (last 100 epochs) of up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-eth1-deposits-for-up-to-100-validators) | **Get all eth1 deposits for up to 100 validators** | =CSQUERY("Beaconchain","Get all eth1 deposits for up to 100 validators") | =CSPARAMETERS("Beaconchain","Get all eth1 deposits for up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-the-current-performance-of-up-to-100-validators) | **Get the current performance of up to 100 validators** | =CSQUERY("Beaconchain","Get the current performance of up to 100 validators") | =CSPARAMETERS("Beaconchain","Get the current performance of up to 100 validators") | 1 | | Try It | [Docs](/providers/beaconchain/get-all-proposed-blocks-during-the-last-100-epochs-for-up-to-100-validators) | **Get all proposed blocks during the last 100 epochs for up to 100 validators** | =CSQUERY("Beaconchain","Get all proposed blocks during the last 100 epochs for up to 100 validators") | =CSPARAMETERS("Beaconchain","Get all proposed blocks during the last 100 epochs for up to 100 validators") | 1 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*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 **Click here** for additional documentation from Beaconchain Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `Beaconchain` `provider`