DefiLlama Sheets
Access DeFi data right in your spreadsheets
Google Sheets
Our Google Sheets add-on brings powerful DeFi analytics directly to your spreadsheets with custom functions.
Microsoft Excel
Access DeFi data in Excel with our custom functions add-in for seamless analysis.
Data You Can Access
- Market Metrics: TVL, fees, revenue, and volumes for 6000+ protocols and 400+ chains.
- Protocol Health: Monitor TVL changes, chain exposure, and dominance stats.
- Stablecoins: Follow market caps, supply by chain, and daily expansion.
- Yield Opportunities: Surface pool APY, TVL, and reward breakdowns.
- Historical Snapshots: Pull any metric by date with hourly refreshes from DefiLlama.
Examples
=DEFILLAMA("tvl", "ethereum")
Get current Total Value Locked for Ethereum
=DEFILLAMA_HISTORICAL("tvl", "uniswap", "2024-01-15")
Get historical TVL for Uniswap on a specific date
=DEFILLAMA_HISTORICAL("fees", "tether", "2025-01-01", "2025-02-01")
Get historical fees for Tether on a monthly date range
=DEFILLAMA_STABLECOIN_MCAP("USDT", "ethereum")
Get current USDT market cap on Ethereum