Excel

Google Sheets

> Token information and analytics for crypto investors, brokers, hedge funds and cryptomarket traders.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Ethplorer">Ethplorer</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/Ethplorer/Get%20last%20block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-block) | **Get last block** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get last block",{"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get last block")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get last block")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20token%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-token-info) | **Get token info** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get token info",{"apiKey","Your apiKey";"address","0xf3db5fa2c66b7af3eb0c0b782510816cbe4813b8"})'>=CS.QUERY("Ethplorer","Get token info")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get token info")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20address%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-address-info) | **Get address info** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get address info",{"apiKey","Your apiKey";"address","0xff71cb760666ab06aa73f34995b42dd4b85ea07b"})'>=CS.QUERY("Ethplorer","Get address info")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get address info")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20transaction%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-transaction-info) | **Get transaction info** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get transaction info",{"transaction_hash","0x6aa670c983425eba23314459c48ae89b3b8d0e1089397c56400ce2da5ece9d26";"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get transaction info")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get transaction info")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20last%20token%20operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-token-operations) | **Get last token operations** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get last token operations",{"apiKey","Your apiKey";"transaction_hash","0x6aa670c983425eba23314459c48ae89b3b8d0e1089397c56400ce2da5ece9d26"})'>=CS.QUERY("Ethplorer","Get last token operations")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get last token operations")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20last%20address%20operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-address-operations) | **Get last address operations** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get last address operations",{"address","0x1f5006dff7e123d550abc8a4c46792518401fcaf";"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get last address operations")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get last address operations")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20address%20transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-address-transactions) | **Get address transactions** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get address transactions",{"address","0xb297cacf0f91c86dd9d2fb47c6d12783121ab780";"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get address transactions")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get address transactions")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top) | **Get top** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get top",{"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get top")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get top")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top%20tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top-tokens) | **Get top tokens** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get top tokens",{"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get top tokens")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get top tokens")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top%20token%20holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top-token-holders) | **Get top token holders** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get top token holders",{"apiKey","Your apiKey";"address","0xe94327d07fc17907b4db788e5adf2ed424addff6"})'>=CS.QUERY("Ethplorer","Get top token holders")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get top token holders")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20grouped%20token%20history" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-grouped-token-history) | **Get grouped token history** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get grouped token history",{"address","0xf3db5fa2c66b7af3eb0c0b782510816cbe4813b8";"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get grouped token history")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get grouped token history")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20grouped%20token%20price%20history" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-grouped-token-price-history) | **Get grouped token price history** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get grouped token price history",{"address","0x48c80f1f4d53d5951e5d5438b54cba84f29f32a5";"apiKey","Your apiKey"})'>=CS.QUERY("Ethplorer","Get grouped token price history")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get grouped token price history")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Last%20Block%20-%20Bulk" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-block---bulk) | **Get Last Block - Bulk** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get Last Block - Bulk",{"apiKey","Your_apiKey"})'>=CS.QUERY("Ethplorer","Get Last Block - Bulk")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get Last Block - Bulk")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20List%20of%20the%20Pool%20Addresses" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-list-of-the-pool-addresses) | **Get List of the Pool Addresses** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get List of the Pool Addresses",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615"})'>=CS.QUERY("Ethplorer","Get List of the Pool Addresses")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get List of the Pool Addresses")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Pool%20Last%20Operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-pool-last-operations) | **Get Pool Last Operations** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get Pool Last Operations",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615";"period","300"})'>=CS.QUERY("Ethplorer","Get Pool Last Operations")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get Pool Last Operations")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Pool%20Last%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-pool-last-transactions) | **Get Pool Last Transactions** | <inline-code functionvalue='=CS.QUERY("Ethplorer","Get Pool Last Transactions",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615";"period","300"})'>=CS.QUERY("Ethplorer","Get Pool Last Transactions")</inline-code> | <inline-code>=CS.PARAMETERS("Ethplorer","Get Pool Last Transactions")</inline-code> | 3 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20last%20block" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-block) | **Get last block** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get last block",{"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get last block")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get last block")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20token%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-token-info) | **Get token info** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get token info",{"apiKey","Your apiKey";"address","0xf3db5fa2c66b7af3eb0c0b782510816cbe4813b8"})'>=CSQUERY("Ethplorer","Get token info")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get token info")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20address%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-address-info) | **Get address info** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get address info",{"apiKey","Your apiKey";"address","0xff71cb760666ab06aa73f34995b42dd4b85ea07b"})'>=CSQUERY("Ethplorer","Get address info")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get address info")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20transaction%20info" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-transaction-info) | **Get transaction info** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get transaction info",{"transaction_hash","0x6aa670c983425eba23314459c48ae89b3b8d0e1089397c56400ce2da5ece9d26";"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get transaction info")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get transaction info")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20last%20token%20operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-token-operations) | **Get last token operations** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get last token operations",{"apiKey","Your apiKey";"transaction_hash","0x6aa670c983425eba23314459c48ae89b3b8d0e1089397c56400ce2da5ece9d26"})'>=CSQUERY("Ethplorer","Get last token operations")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get last token operations")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20last%20address%20operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-address-operations) | **Get last address operations** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get last address operations",{"address","0x1f5006dff7e123d550abc8a4c46792518401fcaf";"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get last address operations")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get last address operations")</inline-code> | 6 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20address%20transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-address-transactions) | **Get address transactions** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get address transactions",{"address","0xb297cacf0f91c86dd9d2fb47c6d12783121ab780";"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get address transactions")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get address transactions")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top) | **Get top** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get top",{"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get top")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get top")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top%20tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top-tokens) | **Get top tokens** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get top tokens",{"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get top tokens")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get top tokens")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20top%20token%20holders" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-top-token-holders) | **Get top token holders** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get top token holders",{"apiKey","Your apiKey";"address","0xe94327d07fc17907b4db788e5adf2ed424addff6"})'>=CSQUERY("Ethplorer","Get top token holders")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get top token holders")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20grouped%20token%20history" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-grouped-token-history) | **Get grouped token history** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get grouped token history",{"address","0xf3db5fa2c66b7af3eb0c0b782510816cbe4813b8";"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get grouped token history")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get grouped token history")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20grouped%20token%20price%20history" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-grouped-token-price-history) | **Get grouped token price history** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get grouped token price history",{"address","0x48c80f1f4d53d5951e5d5438b54cba84f29f32a5";"apiKey","Your apiKey"})'>=CSQUERY("Ethplorer","Get grouped token price history")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get grouped token price history")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Last%20Block%20-%20Bulk" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-last-block---bulk) | **Get Last Block - Bulk** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get Last Block - Bulk",{"apiKey","Your_apiKey"})'>=CSQUERY("Ethplorer","Get Last Block - Bulk")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get Last Block - Bulk")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20List%20of%20the%20Pool%20Addresses" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-list-of-the-pool-addresses) | **Get List of the Pool Addresses** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get List of the Pool Addresses",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615"})'>=CSQUERY("Ethplorer","Get List of the Pool Addresses")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get List of the Pool Addresses")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Pool%20Last%20Operations" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-pool-last-operations) | **Get Pool Last Operations** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get Pool Last Operations",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615";"period","300"})'>=CSQUERY("Ethplorer","Get Pool Last Operations")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get Pool Last Operations")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/Ethplorer/Get%20Pool%20Last%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/ethplorer/get-pool-last-transactions) | **Get Pool Last Transactions** | <inline-code functionvalue='=CSQUERY("Ethplorer","Get Pool Last Transactions",{"apiKey","Your_apiKey";"poolId","d5671522-462c-4799-9257-5ba355702615";"period","300"})'>=CSQUERY("Ethplorer","Get Pool Last Transactions")</inline-code> | <inline-code>=CSPARAMETERS("Ethplorer","Get Pool Last Transactions")</inline-code> | 3 |

</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-Ethplorer">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-Ethplorer">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://ethplorer.io/">Click here</a>** for additional documentation from Ethplorer

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

---

Tags: `Ethplorer` `provider` 


How to pull Ethplorer data into Excel and Google Sheets