CoinMarketCap.com has grown to be one of the most popular websites in the world.

With cryptocurrencies going bonkers in 2017, readers flocked to the website on a daily basis, getting rapidly updated on market capitalizations, daily volumes, prices, and new coins added to the mix.

The market has attracted 100’s of billions of dollars, and sprouted a whopping 1,200+ different coins (the majority of which are different from one another…I say majority, because of copycat coins).

But using the site for actual analysis is…difficult.

Spreadsheets allow us to do quick and dirty analysis that can be limited from a website, or too cumbersome to code. Everyone knows how to use it, it’s easy to store data, and it includes many powerful formulas.

After setup, we will have a simple dashboard that will give even quicker insight into what coins are the big gainers and movers.

Here’s what I can guarantee you:

Several high-level insights into the cryptocurrency market

A better understanding of how the Spreadstreet Google Sheets add-in can make analysis easier

Instructions on how to set everything up yourself

Why should I use a spreadsheet? Why not just use the site?

CoinMarketCap.com is one of my favorite websites, but a non-programmer struggles with getting the data on the front page into the analysis tool of choosing.

They offer an API, but most non-programmers do not know how to use an API.

What if I want to see the top gainers and losers at different market caps? I have to go through multiple steps in order to achieve this, whereas after a one-time setup in Google Sheets, I am good to go.

Google Sheets has a plethora of advantages.

It is easy to use and learn

It is a lightweight and straightforward way to store data

The formulas are powerful and plentiful

Sharing with friends and customers is a piece of cake

Querying a dataset is super easy with Google Query Language

If we can properly setup the sheet, we can save many hours a month not having to copy data, paste into spreadsheet and spot check.

Pulling in CoinMarketCap data to a Google Sheet