Overview

Google Sheets

Installation

Open the extension page on Google Workspace Marketplace to install the add-on.

Setup

1. Extensions → DefiLlama → Open Sidebar

2. Click Sign In

3. Authorize with your defillama account

Test

=DEFILLAMA("price", "Bitcoin")

---

Excel

Installation

1. Open Excel

2. Insert → Add-ins -> More Add-ins

3. Search "DefiLlama"

4. Click Add

Setup

1. Click DefiLlama Sheets

2. Click Sign In

3. Authenticate with your account

Test

=DEFILLAMA("tvl", "Ethereum")

Troubleshooting

• #NAME? error: Restart Excel, ensure add-in is enabled

• Auth issues: Sign out and sign in again via task pane

In case of any issues, questions or feedback, please contact us at [email protected]

---

Quick Examples

// Current data
=DEFILLAMA("tvl", "Ethereum")
=DEFILLAMA("fees", "Uniswap", "24h")
=DEFILLAMA("price", "Bitcoin")

// Historical
=DEFILLAMA_HISTORICAL("tvl", "Aave", "2024-01-01")

// Yields
=DEFILLAMA_YIELD("Arbitrum", "USDC", "apy", 10)
=DEFILLAMA_YIELD_TOP_POOLS(20)

// Stablecoins
=DEFILLAMA_STABLECOIN_MCAP()  // Total market cap
=DEFILLAMA_STABLECOIN_MCAP("USDC", "Ethereum")

Next Steps

• Function Reference - Complete parameter documentation

• Templates - Templates for common use cases

• Support - In case of any issues, questions or feedback