Excel

Google Sheets

> Find the latest analytics and rankings of DeFi protocols

Find examples for accessing every **<a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse">DeFi Pulse</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/DeFi%20Pulse/Get%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-rates) | **Get Rates** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get Rates",{"token","DAI";"amount","10000";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get Rates")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get Rates")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Projects" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-projects) | **Get Projects** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get Projects",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get Projects")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get Projects")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Market%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/market-data) | **Market Data** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Market Data",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Market Data")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Market Data")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20Projects" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-projects) | **Get Lending Projects** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get Lending Projects",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get Lending Projects")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get Lending Projects")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Lending%20Market%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/lending-market-data) | **Lending Market Data** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Lending Market Data",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Lending Market Data")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Lending Market Data")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-history) | **Get History** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get History",{"project","maker";"period","1w";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get History")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get History")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-tokens) | **Get Lending Tokens** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get Lending Tokens",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get Lending Tokens")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get Lending Tokens")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-history) | **Get Lending History** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Get Lending History",{"period","1w";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Get Lending History")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Get Lending History")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/All%20Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/all-exchanges) | **All Exchanges** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","All Exchanges",{"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","All Exchanges")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","All Exchanges")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Single%20Exchange" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/single-exchange) | **Single Exchange** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Single Exchange",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Single Exchange")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Single Exchange")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Returns" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/returns) | **Returns** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Returns",{"api-key","Your api-key";"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e"})'>=CS.QUERY("DeFi Pulse","Returns")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Returns")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Liquidity%20Owner" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/liquidity-owner) | **Liquidity Owner** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Liquidity Owner",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Liquidity Owner")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Liquidity Owner")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Trades%20for%20Exchange" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/trades-for-exchange) | **Trades for Exchange** | <inline-code functionvalue='=CS.QUERY("DeFi Pulse","Trades for Exchange",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CS.QUERY("DeFi Pulse","Trades for Exchange")</inline-code> | <inline-code>=CS.PARAMETERS("DeFi Pulse","Trades for Exchange")</inline-code> | 9 |

</div>

## Google Sheets

<div class="markdown">

| App Url                                                                                  | Docs Url                                                                                  | Name                        | Example                                                                                                                        | Parameters | # of Parameters |
| --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Rates" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-rates) | **Get Rates** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get Rates",{"token","DAI";"amount","10000";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get Rates")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get Rates")</inline-code> | 3 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Projects" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-projects) | **Get Projects** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get Projects",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get Projects")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get Projects")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Market%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/market-data) | **Market Data** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Market Data",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Market Data")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Market Data")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20Projects" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-projects) | **Get Lending Projects** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get Lending Projects",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get Lending Projects")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get Lending Projects")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Lending%20Market%20Data" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/lending-market-data) | **Lending Market Data** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Lending Market Data",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Lending Market Data")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Lending Market Data")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-history) | **Get History** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get History",{"project","maker";"period","1w";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get History")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get History")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20Tokens" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-tokens) | **Get Lending Tokens** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get Lending Tokens",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get Lending Tokens")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get Lending Tokens")</inline-code> | 1 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Get%20Lending%20History" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/get-lending-history) | **Get Lending History** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Get Lending History",{"period","1w";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Get Lending History")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Get Lending History")</inline-code> | 5 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/All%20Exchanges" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/all-exchanges) | **All Exchanges** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","All Exchanges",{"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","All Exchanges")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","All Exchanges")</inline-code> | 7 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Single%20Exchange" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/single-exchange) | **Single Exchange** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Single Exchange",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Single Exchange")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Single Exchange")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Returns" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/returns) | **Returns** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Returns",{"api-key","Your api-key";"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e"})'>=CSQUERY("DeFi Pulse","Returns")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Returns")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Liquidity%20Owner" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/liquidity-owner) | **Liquidity Owner** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Liquidity Owner",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Liquidity Owner")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Liquidity Owner")</inline-code> | 2 |
| <a href="https://app.cryptosheets.com/#/browse/DeFi%20Pulse/Trades%20for%20Exchange" rel="noopener noreferrer" target="_blank">Try It</a> | [Docs](/providers/defi-pulse/trades-for-exchange) | **Trades for Exchange** | <inline-code functionvalue='=CSQUERY("DeFi Pulse","Trades for Exchange",{"address","0xf64F38AE6B1e6144F292ECFA0A7C9236885F032e";"api-key","Your api-key"})'>=CSQUERY("DeFi Pulse","Trades for Exchange")</inline-code> | <inline-code>=CSPARAMETERS("DeFi Pulse","Trades for Exchange")</inline-code> | 9 |

</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-DeFi Pulse">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-DeFi Pulse">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://docs.defipulse.com">Click here</a>** for additional documentation from DeFi Pulse

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

---

Tags: `DeFi Pulse` `provider` 


How to pull Defi Pulse data into Excel and Google Sheets