Excel

Google Sheets

> Developed to estimate the size of the Bitcoin network by finding all the reachable nodes in the network.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Earn">Earn</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/Earn/List%20Snapshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/list-snapshots) | **List Snapshots** | <inline-code functionvalue='=CS.QUERY("Earn","List Snapshots",{"limit","50";"page","1"})'>=CS.QUERY("Earn","List Snapshots")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","List Snapshots")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/List%20Nodes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/list-nodes) | **List Nodes** | <inline-code functionvalue='=CS.QUERY("Earn","List Nodes",{"timestamp","latest"})'>=CS.QUERY("Earn","List Nodes")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","List Nodes")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Status" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-status) | **Node Status** | <inline-code functionvalue='=CS.QUERY("Earn","Node Status",{"address-port","208.118.235.190-8333"})'>=CS.QUERY("Earn","Node Status")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","Node Status")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Leaderboard" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/leaderboard) | **Leaderboard** | <inline-code functionvalue='=CS.QUERY("Earn","Leaderboard",{"limit","50";"page","1"})'>=CS.QUERY("Earn","Leaderboard")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","Leaderboard")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Latency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-latency) | **Node Latency** | <inline-code functionvalue='=CS.QUERY("Earn","Node Latency",{"address-port","208.118.235.190-8333"})'>=CS.QUERY("Earn","Node Latency")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","Node Latency")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Ranking" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-ranking) | **Node Ranking** | <inline-code functionvalue='=CS.QUERY("Earn","Node Ranking",{"address-port","208.118.235.190-8333"})'>=CS.QUERY("Earn","Node Ranking")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","Node Ranking")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Data%20Propagation" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/data-propagation) | **Data Propagation** | <inline-code functionvalue='=CS.QUERY("Earn","Data Propagation",{"inv_hash","1e0942ab85c1800b3cfa3997af73803ee0cda22b657fd307285ee8f08045654a"})'>=CS.QUERY("Earn","Data Propagation")</inline-code> | <inline-code>=CS.PARAMETERS("Earn","Data Propagation")</inline-code> | 1 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Earn/List%20Snapshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/list-snapshots) | **List Snapshots** | <inline-code functionvalue='=CSQUERY("Earn","List Snapshots",{"limit","50";"page","1"})'>=CSQUERY("Earn","List Snapshots")</inline-code> | <inline-code>=CSPARAMETERS("Earn","List Snapshots")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/List%20Nodes" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/list-nodes) | **List Nodes** | <inline-code functionvalue='=CSQUERY("Earn","List Nodes",{"timestamp","latest"})'>=CSQUERY("Earn","List Nodes")</inline-code> | <inline-code>=CSPARAMETERS("Earn","List Nodes")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Status" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-status) | **Node Status** | <inline-code functionvalue='=CSQUERY("Earn","Node Status",{"address-port","208.118.235.190-8333"})'>=CSQUERY("Earn","Node Status")</inline-code> | <inline-code>=CSPARAMETERS("Earn","Node Status")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Leaderboard" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/leaderboard) | **Leaderboard** | <inline-code functionvalue='=CSQUERY("Earn","Leaderboard",{"limit","50";"page","1"})'>=CSQUERY("Earn","Leaderboard")</inline-code> | <inline-code>=CSPARAMETERS("Earn","Leaderboard")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Latency" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-latency) | **Node Latency** | <inline-code functionvalue='=CSQUERY("Earn","Node Latency",{"address-port","208.118.235.190-8333"})'>=CSQUERY("Earn","Node Latency")</inline-code> | <inline-code>=CSPARAMETERS("Earn","Node Latency")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Node%20Ranking" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/node-ranking) | **Node Ranking** | <inline-code functionvalue='=CSQUERY("Earn","Node Ranking",{"address-port","208.118.235.190-8333"})'>=CSQUERY("Earn","Node Ranking")</inline-code> | <inline-code>=CSPARAMETERS("Earn","Node Ranking")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Earn/Data%20Propagation" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/earn/data-propagation) | **Data Propagation** | <inline-code functionvalue='=CSQUERY("Earn","Data Propagation",{"inv_hash","1e0942ab85c1800b3cfa3997af73803ee0cda22b657fd307285ee8f08045654a"})'>=CSQUERY("Earn","Data Propagation")</inline-code> | <inline-code>=CSPARAMETERS("Earn","Data Propagation")</inline-code> | 1 |

</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-Earn">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-Earn">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://bitnodes.earn.com/api/">Click here</a>** for additional documentation from Earn

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

---

Tags: `Earn` `provider` 


How to pull Earn data into Excel and Google Sheets