Crypto Portfolio Tracker Excel Template — P&L, Allocation, Private & Offline

Track your entire crypto portfolio in one Excel file — no exchanges login, no cloud, fully private. Auto-calculated P&L, allocation charts, and transaction history. WHAT YOU GET (instant .xlsx download): - 6 ready sheets: Start Here, Settings, Holdings, Transactions, Dashboard, Performance - Holdings: enter coin, quantity, average cost, current price — total cost and current value calculate automatically - Transactions: 50 rows with Type dropdown (Buy / Sell / Transfer / Stake / Receive) and auto totals, SUMIF-based - Dashboard: 5 KPI cards (total value, total cost, P&L, best/worst performer) + pie allocation chart + cost-vs-value bar chart + goal alert - Performance sheet: profit/loss and return % per coin — instantly see what's working - Demo portfolio (BTC, ETH, USDT, SOL, DOT) pre-filled so you see everything in action — delete and start - Yellow cells = your input, everything else is automatic. Sheet protection without password. COMPATIBILITY: Excel 2016+, Microsoft 365, Google Sheets, LibreOffice Calc. Windows / Mac. WHO IT'S FOR: crypto investors who want an offline, private portfolio tracker instead of connecting wallets to sketchy sites. Also useful for accountants and tax prep (full transaction log). HOW IT WORKS: 1. Buy — file delivered instantly 2. Add your coins and transactions 3. Update current prices (or paste from CoinGecko) — dashboard and P&L recalculate themselves 4. Check performance any time, anywhere, fully offline Your keys, your coins, your spreadsheet. Start tracking today.