This guide will help you integrate live cryptocurrency prices into Google Sheets, enabling you to build a customized crypto portfolio tracker. Even if you're new to Google Sheets, follow the step-by-step instructions below—complete with a video tutorial and access to a free stocks and crypto portfolio tracker template.
Why Google Finance Falls Short for Crypto Prices
Google Finance offers limited crypto data, covering only major coins like Bitcoin (BTCUSD) and Ethereum (ETHUSD). To fetch Bitcoin’s price, you’d use:
=GOOGLEFINANCE("BTCUSD")However, with 21,000+ cryptocurrencies listed on CoinMarketCap (and counting), Google Finance’s coverage is insufficient for altcoin enthusiasts.
Pulling Prices Directly from CoinMarketCap
Step 1: Copy the CoinMarketCap URL
Each cryptocurrency has a dedicated page (e.g., Ethereum’s page). Paste the URL into your Google Sheet.
Step 2: Use the IMPORTXML Formula
Insert this formula next to the URL:
=IMPORTXML(B2, "//div[@class='priceValue ']")Ensure B2 references the cell containing the URL. Prices will auto-populate.
Step 3: Enable Auto-Refresh (Optional)
- Prices update when reopening the sheet.
- For real-time updates, use a macro to re-paste the formula periodically.
Pro Tips
- Troubleshooting: If prices stop updating, CoinMarketCap may be undergoing maintenance. Check the YouTube tutorial for updates.
- Portfolio Tracker: Expand your sheet with additional columns (e.g., holdings, value) for a comprehensive tracker.
FAQ
Why does IMPORTXML fail sometimes?
CoinMarketCap occasionally modifies its HTML structure. Adjust the formula’s class parameter if needed.
Can I track multiple coins at once?
Yes! Repeat Steps 1–2 for each cryptocurrency URL.
How often do prices update?
Every 1–2 minutes when the sheet is open.
👉 Ready to automate your crypto tracking? Start here
Disclaimer: This guide is for educational purposes only. Not financial advice.
### Keywords
- Crypto portfolio tracker
- Google Sheets crypto prices
- IMPORTXML CoinMarketCap
- Real-time cryptocurrency data