DefiLlama Sheets brings trusted DeFi intelligence into Google Sheets™ for power users can research protocols, chains, stablecoins, and yields directly inside their models.
Pull live metrics with =DEFILLAMA() — TVL, borrows, fees, revenue, perps volume, FDV, price, and more
Track market structure over time with historical functions for protocol metrics and stablecoin market caps, returning single dates or ready-to-chart ranges.
Surface yield opportunities using filters for chain, token, APY sorting, and dive deeper with pool-level lookups, top-pool discovery, and reference lists of projects and chains.
Designed for DeFi analysts, treasuries, trading desks, and builders who rely on DefiLlama data to make faster, better-informed decisions inside their spreadsheets.
Examples:
=DEFILLAMA("tvl","ethereum") for current Ethereum TVL
=DEFILLAMA_HISTORICAL("fees","uniswap","2024-01-01","2024-03-31") for fee history,
=DEFILLAMA_YIELD("Arbitrum","USDC","tvl",25) to review top USDC yields on Arbitrum.