In this article:

Free Crypto Portfolio Tracker for Google Sheets (2024 Update)

May 8, 2024

Google Sheets Crypto Tracker

A crypto portfolio tracker for Google Sheets is useful for real-time monitoring of cryptocurrency investments, enabling informed decisions and financial strategy optimization.

Access our free crypto tracker for Google Sheets here.

google sheets crypto tracker

Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’.

crypto portfolio tracker google sheets

How to Use the Crypto Portfolio Tracker for Google Sheets

Follow the steps below to use the Google Sheets crypto portfolio tracker. 

1. Understand Your Template

Your template has two parts: Summary and Transactions. The Summary shows your overall portfolio. Transactions list all your buys, sells, and transfers.

Summary: Check cryptocurrencies, investments, and returns here.

Transactions: Enter details of your crypto activities.

google sheets crypto portfolio tracker

2. Modify the Summary

You can add new cryptocurrencies or indicators in the Summary.

To add a cryptocurrency: Add a row, type its name, and enter initial details.

free crypto portfolio tracker google sheets

To add an indicator: Insert a column and name it after the new indicator.

The template have example transactions. Delete these rows to start fresh.

3. Add Your Transactions

Record every crypto transaction in the Transactions section. Fill in the date, type, cryptocurrency, exchange, coins, and price. Use the green cells for inputs.

5. Keep Your Portfolio Updated

Check and update your tracker regularly. Add new transactions as they happen. This helps you stay on top of your investments and see how they are doing.

We hope that you now have a better understanding of how to use our free crypto portfolio tracker for Google Sheets. If you enjoyed this article, you might also like our article on our free options tracker for Google Sheets or our article on employee training tracker.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->