How To Extract The Cryptocurrency Market To Excel

How to extract the cryptocurrency market to excel

Your Answer

Hello Stemians! :)

Today i was looking for a way to import data from coinmarketcap to excel because i need to update information about curencies, i use this for track how valuable are my savings.

Cryptocurrency price live charts

And I found resolving!

Now you can import this data to your sheets;).

1. You should download „Microsoft Power Query for Excel”. When you finished, install it.

2. Run your Excel – now you should have a new tab „Power query” - click it

3.

How to extract the cryptocurrency market to excel

Next click „FROM WEB”. Now should apper window. Copy ticker API (https://api.coinmarketcap.com/v1/ticker/) and paste in new window in Excel.

Bitcoin Explained: How to import live cryptocurrency prices to Excel Spread Sheet

Click "OK"

This api provide all data about every cryptocurrency on coinmarketcap. If you want you can use other api (https://coinmarketcap.com/api/) to select currency or select another data.

On this API is all data you can get from this site. In my opinion the better way is select data inside Excel.

7. Now you see table of many record, but not data.

BOOM! You’re good to go!

Go click buton „To Table”. In next windows don't change anything.

How to extract the cryptocurrency market to excel

Click "OK"

8. Ok, now We want see any data.

Click a small icon (with two opposite arrows) next Column1.

How to extract the cryptocurrency market to excel

There you can select columns what you interested. I recomended select all.

How to extract the cryptocurrency market to excel

Click "OK"

10. On This steps you can change columns names.

Invest in bitcoin fidelity

But if you don't want do on now, you can change it later, normally in sheet. When you finish, click "Close & Load"

12.

Reader Interactions

From this time, when you click „Refresh all” buton, the information on this sheet wil be upadted.

------------------------------------------------------------------------------------------------------------------------------------

If you like post with tricks and hack let me know.

In future i try post more information about solutions that make everyday work easier.

If you think my post is helpful, go upvote :) 

Thank you!