Web3 KPI Spreadsheet Pack: 5 Google Sheets & Excel Templates (Multi-Chain)

Five spreadsheet templates for people who juggle wallets, airdrops, DeFi positions, bounties, and trades. Works in Google Sheets and Excel. No add-ons, no API keys, no scripts. You type the numbers, the formulas do the math.

The details

What you get (all five in one XLSX, plus each template as CSV):

1. Crypto Portfolio Tracker - multi-chain holdings (BTC, ETH, SOL, Base, L2s) with cost basis, P/L, and allocation % per asset. The TOTAL row checks your allocation sums to 100%.

2. Airdrop & Testnet Tracker - protocol, wallet, tx count, start date, status, estimated value. Summary block counts Claimed and In progress and totals your estimated value.

3. DeFi Yield Log - deposit, current value, APY, rewards claimed per position. Net P/L and net ROI calculated per row and for the whole book.

What's inside

• Live formulas everywhere - change a price and every dependent number updates.
• Dropdowns for Status and Long/Short in the XLSX.
• Sample rows are dummy data you overwrite. Add rows above the total row and the SUM ranges stretch.
• README included with setup steps for Google Sheets and Excel, plus how each formula works.

$10 one-time · instant download · checkout on Getly