Excel Templates
Configure your data, see matching templates, and download with CryptoSheets formulas.
Configure Your Data
Select coins to see relevant templates. Leave empty for market-wide templates.
CryptoSheets Add-in Required
These templates contain formulas only - no market data is embedded. Data is fetched via the CryptoSheets Excel add-in when you open the file in Microsoft Excel Desktop. You must have an active CryptoSheets account.
View full requirementsMarket Data
(7)Crypto Screener
Real-time market data with customizable filters and metrics
Market Overview
Global crypto market stats, BTC dominance, and top coins
Personal Watchlist
Track your favorite coins with alerts and daily summaries
Macro Indicators
Economic indicators affecting crypto markets
Alerts Summary
Price alerts, risk alerts, and market notifications
Gainers & Losers
Top daily performers and biggest drops
ETF Tracker
Bitcoin & Crypto ETF flows, holdings, and performance
Technical Analysis
(3)OHLCV Historical Data
Open, High, Low, Close, Volume candlestick data
Technical Indicators
RSI, MACD, Moving Averages, Bollinger Bands
Historical Analysis
Educational historical price study and performance metrics
On-Chain
(5)Whale Tracker
Large holder activity, wallet distribution, and movements
Exchange Flows
Crypto exchange inflows and outflows
Bitcoin On-Chain
BTC hashrate, difficulty, active addresses, mempool
ETH Gas Tracker
Current Ethereum gas prices and trends
Mining Statistics
Cryptocurrency mining metrics and profitability
DeFi
(2)DeFi TVL Tracker
Total Value Locked across DeFi protocols
DeFi Yields
Best yield farming APYs across protocols
Sentiment
(2)Fear & Greed Index
Market sentiment with historical trends
Social Sentiment
Twitter, Reddit, news sentiment analysis
Derivatives
(3)Funding Rates
Perpetual futures funding rates across exchanges
Open Interest
Futures open interest and liquidations
Liquidations
Futures liquidation data across exchanges
Portfolio
(4)Coin Comparison
Compare multiple cryptocurrencies side-by-side
Risk Dashboard
Volatility, drawdown, and risk analysis metrics
Portfolio Tracker
Track your holdings with P&L calculations
Correlation Matrix
Price correlation between cryptocurrencies
NFT
(1)NFT Collections
Top NFT collections by volume and floor price
Token Economics
(2)Token Unlocks
Upcoming token vesting unlocks
Staking Rewards
Staking APY comparison across coins
How Templates Work
Configure
Select coins and settings above
Download
Get the .xlsx template file
Open in Excel
CryptoSheets add-in fetches data
Refresh
Click Refresh All for latest data
Need Help Getting Started?
Check out our setup guide to get your templates working in Excel.
Disclaimer: Templates contain formulas only - no market data is embedded. DataSimplify is software tooling, not a data vendor.View full disclaimer