Import CoinGecko Cryptocurrency Data into Microsoft Excel

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!