Cryptosheets - Pull cryptocurrency real-time and historical data into Excel or Google Sheets

As cryptocurrency enthusiasts or professionals we either use different tools to track our assets from the portfolio or do our own thing in Excel or Google Sheets. Working with excel sheets gives you more customization capabilities (@nealmcspadden knows this better) and you can track your cryptocurrencies the way that you want and you can try different calculations, arbitrage opportunities, comparison, returns or any other analysis.

As I am also an excel sheet user, I stumbled upon Cryptosheets which is an Excel or Google Sheets plugin that pull real-time and historical data into Excel in seconds from hundreds of data sources and providers. You don't need any programming skills to make use of it or to understand the links behind it and you have on hand formulas or widgets to retrieve and analyze anything you need on your cryptocurrencies. It offers a Free Forever subscription along with other paid ones, which is limited to 1,000 Monthly Requests which might be good enough for common activities.

Cryptosheets offers an impressive number of features through which the following are most important:

• Over 7,000 cryptocurrency assets
• Over 800 exchanges
• Over 500 unique providers
• Live API consoles for testing
• Powerful custom functions
• Customizable workspaces
• Dashboard widgets
• Smart lookup
• Integrated research
• Load sample templates no downloads required
• Browse charts and load data instantly
• Import your portfolio or trading account

The addon provides use cases for any kind of user:

• Investor
• Analyst
• Journalist
• Trader
• Portfolio Management
• Accountant
• Hobbyist
• Student

It brings numerous benefits, through which some important ones are:

• Mix and match to compare data sources
• No downloads required
• Access everything from one place
• Leverage the unparalleled power of Excel
• Use powerful new generation custom functions
• Use on any device or OS (Mac, iOS, Windows, Online)

To use it you need to use an e-mail address and that should do it. Adjacently you can make use of templates or use them for later use which is quite great because this can be shared between users. Pretty powerful to be able to bring the data at your fingertips and be able to perform live calculations or any other computations based on that. A simple example can be seen at

I think this can enhance anyone's use of the sheets tracking and being able to get live price data or any other information on it. Instead of manually checking prices on different sites and bringing them where your data is sometimes is time consuming and usually might not be kept updated. This avoids that and brings live information which can be used for different purposes. Hopefully this helps and you can enrich your cryptocurrency analys, tracking and portfolio management.