Import CoinGecko Cryptocurrency Data into Microsoft Excel

A sample portfolio tracker built using Microsoft Excel with CoinGecko's API

Did you know that you are able to extract data from API into Microsoft Excel using the in-built Power Query feature? CoinGecko’s API is completely free to use, and you can enjoy the full capability of it without needing to code at all.

By the end of this guide, you’ll be able to pull live prices and build a portfolio of your favorite cryptocurrencies directly onto your very own Excel spreadsheet with a bit of elbow grease!

Note: Power Query is currently only available for Windows users and not available for Microsoft Excel on MacOS. For Mac users, you may use the Cryptosheets plugin for Microsoft Excel. For Google Sheet users, you may also refer to our Google Sheets API guide.

Let’s get started!

Step 1: Get these tabs open before the mapping exercise

  • Microsoft Excel: Open a new spreadsheet
  • Web browser: You will be referring to CoinGecko’s API documentation page frequently, so have this page open too: CoinGecko API Documentation.

Step 2: Pulling list of coins from CoinGecko’s API

  • On Microsoft Excel, click on the “Data Tab”. Select “From Web” in the respective menu in the tab.
2.1. Open the Data Tab and select from “From Web”
2.2. Proceed to the CoinGecko Documentation Website to obtain API link query
2.3. Input the queries into the Excel Sheet pop-up box after clicking “From Web”

Step 3: Convert the data into Table format on Power Query Tab

  • Next, some raw data that says “Record” would be loaded in a column onto a Power Query tab. We’ll convert it to a table format before using it by clicking on the “To Table” icon.
3.1 Click “To Table” to convert the data to table format
  • You would need to expand the columns as well in order for the data to be displayed nicely.
3.2 Click on the icon to expand the table. Proceed to select “ok”
  • Once done you should expect to see a table with 3 columns, like so:
3.3 Expanded table

Step 4: Close and Load your data to the excel spreadsheet

  • The data should load in the spreadsheet selected.
  • Select the filter button to sort data in accordance with your preference
4.1. Close and load the table to your excel sheets
4.2.Choose the cell which you wish to load the data to.

Step 5: Click on the Refresh All button to call data from our API to fetch live data

  • The data will load to live prices once you select the “refresh all” button on the Data tab.
5.1 Click on the “Refresh All” button to fetch live data

And that is all there is to pulling data through API – You can easily replicate this across other API endpoints as well. Do check out the CoinGecko API Documentation page, and if you run into any issues – our FAQ section is available for reference.

We hope you find this guide useful! Here is a sample Excel document (.xlsx) that you may download and modify accordingly.

Closing thoughts

Lastly, this guide uses Power Query, which is only available for Windows Microsoft Excel users. For Mac users, your alternatives are to use the Cryptosheets plugin for Microsoft Excel or Google Sheets where we’ve also prepared a guide here!

That said, this is probably more suitable for more advanced work/analysis uses. If you want something quick, easy and syncs across web/mobile app – check out CoinGecko’s Portfolio which works right out of the box complete with charts, transactions tracking, Profit & Loss and more!

This image has an empty alt attribute; its file name is kBltzoPSD_CpQyOcYIhz4tDcyBnpYEbeNNeScQutI2e_LzCo-efHVZa07M9xkoUCgh7BUUAQS4_cSvqVbCQeyuXUfbgpl8x3GR4EkBTQ2FaVfs9OEL39MszwhzkPovSdTO8yNz8Q

Extra: Exploring the /coins/markets endpoint for price, market cap, volume and more

Input details in empty fields
Input final details and copy API link to Excel Sheets
Share on twitter
Twitter
Share on telegram
Telegram
Share on facebook
Facebook
Share on linkedin
LinkedIn
Share on email
Email

21 thoughts on “Import CoinGecko Cryptocurrency Data into Microsoft Excel”

  1. I need help setting up a spreadsheet that will show me the coins I have the percentages, and cost average. I trying to figure out how to best DCA

  2. Hi this is great. Is this possible for excel on Mac? And are you planning on having a step by step walkthrough for the Mac version. It seems a little harder for some reason. Let me know thanks.

  3. Cryptocurrency market has been changing day by day at a rapid pace due to nature of dealing with marketing needs! I have been working as a worker at this https://lesbi.land/ website and help people with wonderful girls and women around the world. I hope the marketplace will be updated soon for the investors!

  4. Hello, I’ve been trying this for a while but seem to have an issue when it comes for Excel to connect to the API. I.e. Excel loads forever or crashes. Who can I contact for technical assistance? Thanks

  5. airriflehunting

    Cryptocurrency market has been changing day by day at a rapid pace due to nature of dealing with marketing needs! Before you buy your next hunting knife sit down make a list of what you expect out of the knife you want to buy https://theoutdoorchamp.com/ . That perfect knife is out there somewhere! You may end up with several knives for different applications. The main thing to remember is you need a good knife as bad as you need your hunting permit!

  6. With cryptocurrency, nothing is for certain. However, it may be a very good idea to take a risk and experiment with BTC on some of our best Bitcoin casinos in Australia https://casinority.com/au/pokies/. Regular cash doesn’t shift its value as frequently, but cryptocurrency may fill your digital pockets with some real rewards.

  7. It’s very sad to see a business that has shown great results before literally falling apart in the digital marketing era.
    After all, many agencies would gladly take on such a brand, because with a recognizable brand it is always easier to achieve a result.
    As a result, projects like chatroulette, which develop only through digital marketing, have advanced much further over the past ten years than the marketing giants from the 90s.

Leave a Comment

Your email address will not be published. Required fields are marked *