DefiLlamaDefiLlama

DefiLlama Sheets

Your spreadsheet, powered by DeFi data

Custom functions that pull TVL, fees, yields, stablecoin stats and historical data for 6,000+ protocols.

B2=DEFILLAMA("tvl", "ethereum")
A
B
1
=DEFILLAMA("tvl", "ethereum")
$54.5B
2
=DEFILLAMA("fees-7d", "uniswap")
$14.8M
3
=DEFILLAMA("revenue-30d", "lido")
$5.4M
4
=DEFILLAMA_STABLECOIN_MCAP("USDT")
$183.7B
Market Metrics

Real-time Protocol & Chain Data

Access TVL, fees, revenue, market cap, price and more for every protocol and chain. Data refreshes hourly.

  • 30+ metrics including fees, revenue, volume, perps
  • 6,000+ protocols and 400+ chains
  • 24h, 7d, and 30d timeframes
1
=DEFILLAMA("tvl", "aave")
$27.0B
2
=DEFILLAMA("fees-24h", "gmx")
$87.9K
3
=DEFILLAMA("mcap", "sky")
$1.5B
4
=DEFILLAMA("volume-7d", "uniswap")
$13.5B
Yields

Yield Intelligence Across Chains

Discover the best yield opportunities — filter by chain, token, and APY. Get detailed pool data including IL risk and reward tokens.

  • Filter pools by chain, token, APY, or TVL
  • Detailed pool data with IL risk and reward tokens
  • Top pools discovery and comparison
=DEFILLAMA_YIELD("Ethereum", "USDC", "tvl", 3)
Chain
Project
Symbol
APY%
TVL
1
Ethereum
Maple
USDC
4.58%
$3.2B
2
Ethereum
Aave V3
USDC
2.33%
$1.2B
3
Ethereum
Merkl
USDC
0.35%
$1.1B
Stablecoins

Stablecoin Market Intelligence

Track stablecoin market caps, peg health, and supply across chains. Monitor historical trends and cross-chain distribution.

  • Market cap by stablecoin and chain
  • Historical supply data and trends
  • Full stablecoin directory with peg types
1
=DEFILLAMA_STABLECOIN_MCAP("USDT", "Tron")
$83.8B
2
=DEFILLAMA_STABLECOIN_MCAP("USDC")
$73.7B
3
=DEFILLAMA_STABLECOIN_MCAP("DAI")
$4.4B
4
=DEFILLAMA_STABLECOIN_MCAP("all", "Ethereum")
$159.4B
Historical Data

Historical Snapshots & Time Series

Pull historical data for any metric and date range. Build charts and trend analysis with hourly-refreshed data.

  • Single date or full date range queries
  • Ascending or descending sort
  • Perfect for building time-series charts
=DEFILLAMA_HISTORICAL("tvl", "ethereum", "2025-01-01", "2025-01-05")
1
Date
TVL
2
2025-01-01
$65.3B
3
2025-01-02
$66.2B
4
2025-01-03
$67.6B
5
2025-01-04
$70.2B
6
2025-01-05
$71.1B

Templates

Pre-built spreadsheets to get you started. Clone and customize to fit your workflow.

Stablecoin Yield Finder

Find the best stablecoin yields across lending protocols and chains.

View template →

Multi-Chain Yield Finder

Track and compare yield opportunities across multiple chains with earnings calculator.

View template →

Protocol Comparison

Side-by-side TVL, fees, revenue, and key metrics for any set of protocols.

View template →

Chain Comparison

Side-by-side metrics for multiple chains including TVL, fees, and users.

View template →

Advanced Revenue Table

Comprehensive financial metrics for revenue-generating protocols.

View template →