Excel

Google Sheets

> Yearn API is a collection of Serverless API endpoints focused on Yearn network integrations.

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/Yearn%20API">Yearn API</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/Yearn%20API/Loanscan%20Crvbtc" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-crvbtc) | **Loanscan Crvbtc** | <inline-code functionvalue='=CS.QUERY("Yearn API","Loanscan Crvbtc")'>=CS.QUERY("Yearn API","Loanscan Crvbtc")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Loanscan Crvbtc")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Crvbusd" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-crvbusd) | **Loanscan Crvbusd** | <inline-code functionvalue='=CS.QUERY("Yearn API","Loanscan Crvbusd")'>=CS.QUERY("Yearn API","Loanscan Crvbusd")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Loanscan Crvbusd")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Ethstable" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-ethstable) | **Loanscan Ethstable** | <inline-code functionvalue='=CS.QUERY("Yearn API","Loanscan Ethstable")'>=CS.QUERY("Yearn API","Loanscan Ethstable")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Loanscan Ethstable")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Link" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-link) | **Loanscan Link** | <inline-code functionvalue='=CS.QUERY("Yearn API","Loanscan Link")'>=CS.QUERY("Yearn API","Loanscan Link")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Loanscan Link")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Ycrv" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-ycrv) | **Loanscan Ycrv** | <inline-code functionvalue='=CS.QUERY("Yearn API","Loanscan Ycrv")'>=CS.QUERY("Yearn API","Loanscan Ycrv")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Loanscan Ycrv")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults) | **User User Address Vaults** | <inline-code functionvalue='=CS.QUERY("Yearn API","User User Address Vaults",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C7"})'>=CS.QUERY("Yearn API","User User Address Vaults")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","User User Address Vaults")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Earnings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-earnings) | **User User Address Vaults Earnings** | <inline-code functionvalue='=CS.QUERY("Yearn API","User User Address Vaults Earnings",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C8"})'>=CS.QUERY("Yearn API","User User Address Vaults Earnings")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","User User Address Vaults Earnings")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-statistics) | **User User Address Vaults Statistics** | <inline-code functionvalue='=CS.QUERY("Yearn API","User User Address Vaults Statistics",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C9"})'>=CS.QUERY("Yearn API","User User Address Vaults Statistics")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","User User Address Vaults Statistics")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-transactions) | **User User Address Vaults Transactions** | <inline-code functionvalue='=CS.QUERY("Yearn API","User User Address Vaults Transactions",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C10"})'>=CS.QUERY("Yearn API","User User Address Vaults Transactions")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","User User Address Vaults Transactions")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults) | **Vaults** | <inline-code functionvalue='=CS.QUERY("Yearn API","Vaults")'>=CS.QUERY("Yearn API","Vaults")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Vaults")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults%20Apy" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults-apy) | **Vaults Apy** | <inline-code functionvalue='=CS.QUERY("Yearn API","Vaults Apy")'>=CS.QUERY("Yearn API","Vaults Apy")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Vaults Apy")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults%20Snapshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults-snapshots) | **Vaults Snapshots** | <inline-code functionvalue='=CS.QUERY("Yearn API","Vaults Snapshots")'>=CS.QUERY("Yearn API","Vaults Snapshots")</inline-code> | <inline-code>=CS.PARAMETERS("Yearn API","Vaults Snapshots")</inline-code> | 0 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Crvbtc" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-crvbtc) | **Loanscan Crvbtc** | <inline-code functionvalue='=CSQUERY("Yearn API","Loanscan Crvbtc")'>=CSQUERY("Yearn API","Loanscan Crvbtc")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Loanscan Crvbtc")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Crvbusd" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-crvbusd) | **Loanscan Crvbusd** | <inline-code functionvalue='=CSQUERY("Yearn API","Loanscan Crvbusd")'>=CSQUERY("Yearn API","Loanscan Crvbusd")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Loanscan Crvbusd")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Ethstable" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-ethstable) | **Loanscan Ethstable** | <inline-code functionvalue='=CSQUERY("Yearn API","Loanscan Ethstable")'>=CSQUERY("Yearn API","Loanscan Ethstable")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Loanscan Ethstable")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Link" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-link) | **Loanscan Link** | <inline-code functionvalue='=CSQUERY("Yearn API","Loanscan Link")'>=CSQUERY("Yearn API","Loanscan Link")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Loanscan Link")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Loanscan%20Ycrv" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/loanscan-ycrv) | **Loanscan Ycrv** | <inline-code functionvalue='=CSQUERY("Yearn API","Loanscan Ycrv")'>=CSQUERY("Yearn API","Loanscan Ycrv")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Loanscan Ycrv")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults) | **User User Address Vaults** | <inline-code functionvalue='=CSQUERY("Yearn API","User User Address Vaults",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C7"})'>=CSQUERY("Yearn API","User User Address Vaults")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","User User Address Vaults")</inline-code> | 4 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Earnings" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-earnings) | **User User Address Vaults Earnings** | <inline-code functionvalue='=CSQUERY("Yearn API","User User Address Vaults Earnings",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C8"})'>=CSQUERY("Yearn API","User User Address Vaults Earnings")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","User User Address Vaults Earnings")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Statistics" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-statistics) | **User User Address Vaults Statistics** | <inline-code functionvalue='=CSQUERY("Yearn API","User User Address Vaults Statistics",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C9"})'>=CSQUERY("Yearn API","User User Address Vaults Statistics")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","User User Address Vaults Statistics")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/User%20User%20Address%20Vaults%20Transactions" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/user-user-address-vaults-transactions) | **User User Address Vaults Transactions** | <inline-code functionvalue='=CSQUERY("Yearn API","User User Address Vaults Transactions",{"userAddress","0xB98BB93a2dC967546AbdA3a0226813B25D9A85C10"})'>=CSQUERY("Yearn API","User User Address Vaults Transactions")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","User User Address Vaults Transactions")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults) | **Vaults** | <inline-code functionvalue='=CSQUERY("Yearn API","Vaults")'>=CSQUERY("Yearn API","Vaults")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Vaults")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults%20Apy" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults-apy) | **Vaults Apy** | <inline-code functionvalue='=CSQUERY("Yearn API","Vaults Apy")'>=CSQUERY("Yearn API","Vaults Apy")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Vaults Apy")</inline-code> | 0 |
| <a href="https://app.cryptosheets.com/#/browse/Yearn%20API/Vaults%20Snapshots" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/yearn-api/vaults-snapshots) | **Vaults Snapshots** | <inline-code functionvalue='=CSQUERY("Yearn API","Vaults Snapshots")'>=CSQUERY("Yearn API","Vaults Snapshots")</inline-code> | <inline-code>=CSPARAMETERS("Yearn API","Vaults Snapshots")</inline-code> | 0 |

</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-Yearn API">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-Yearn API">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://github.com/yearn-integrations/api">Click here</a>** for additional documentation from Yearn API

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

---

Tags: `Yearn API` `provider` 


How to pull Yearn API data into Excel and Google Sheets