How to get all live crypto rates in Google Sheets or Excel to create a portfolio tracker. This is totally free and works for any local currency like USD, EUR, AUD, etc

I made a helpful tool to get live crypto rates in Google Sheets or Excel.

This method is completely free and can get the rates in any local currency, USD / EUR / AUD / etc.

You can see it in action on the example sheet here (it's formatted for desktop, but just scroll to the right for pretty charts):

https://docs.google.com/spreadsheets/d/1nu7EYtzxrizrypDvnrtz5FrfTBDpFLkjk7Lw80blUEc/edit?usp=sharing

Data is updated every 30 minutes and you can get the live rate for any of the top 4000 coins by market cap.

To use it in an existing workbook, just create a blank sheet and put this in A1:

=IMPORTDATA("https://cryptorates.ai/files/standard.csv") 

I know there are various hacks to get the data from CMC etc, but they're all rate limited and start to cause issues once you make too many requests. The other benefit is that it's just a single formula - paste it into any workbook and you're done.

For Excel, you would go to Data > From Web, and paste the URL above.

If you want the full dataset (includes volume, market cap, 24h change, etc), use full.csv instead of standard. For the full dataset, it's the top 2000 coins to keep the import filesize small.