Completely free live crypto rates for Google Sheets and Excel

Free live rates for the top 5000 coins. There's nothing to install. Just copy and paste the formula below into Google Sheets and you've got your first live rate!

=QUERY(IMPORTDATA("https://cryptorates.ai/files/standard.csv", ",", "en_US"), "SELECT Col3 WHERE Col1 = 'BTC'", 0)

For Excel you'll need to follow the Excel instructions.

If you track the prices of a lot of different coins, have a look at the VLOOKUP method, otherwise click through to the next page for more details and a demo sheet.

Features

• Data is updated every 5 minutes and includes the top 5000 coins by 24h volume.
• Includes crypto symbol, name, current price, global rank, market cap, total supply, 24 hour trading volume, 24 hour price change, 7 day price change, all-time high (ATH) price and date, all-time low (ATL) price and date.
• REST API for fetching rates in any app.
• And no rate limits. Use this as much as you want, wherever you want.

Commercial / Public use

This tool is free for both private and commercial use.

The only requirement of using the data in a public or commercial project is that you add an attribution link back to https://cryptorates.ai