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.
- You will need to input an API query from CoinGecko API Documentation. To pull the coin list, we will use the “GET /coins/list” endpoint. It returns https://api.coingecko.com/api/v3/coins/list which you can copy into Microsoft Excel.
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.
- You would need to expand the columns as well in order for the data to be displayed nicely.
- Once done you should expect to see a table with 3 columns, like so:
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
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.
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!
Extra: Exploring the /coins/markets endpoint for price, market cap, volume and more
- Select GET /coins/markets as an example this time.
- Enter the prefixes into the empty spaces for the desired outcome. You may follow the description of these tiles to get an idea of what to input as your data..
- Hit the execute button once completed to generate the Request URL
- (example API call to get a list of 100 coins) – https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&order=market_cap_desc%2Cvolume_desc&per_page=100&page=1&sparkline=false&price_change_percentage=1h%2C24h%2C7d
- Once the API url is obtained, proceed to repeat steps 2-5 from the guide above into your Excel sheets.
56 thoughts on “Import CoinGecko Cryptocurrency Data into Microsoft Excel”
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
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.
Am Available incase you find it difficult am an cryptocurrency investor alright you can text me on necolecoybig67@gmail.com
Did you get any idea about how do we use this for excel for mac?
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!
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
That is a cool guide, we will import all our client data using it. Thank you so much.
Amazing guide ! Great work !
Thanks for this blog. Very valuable information and i really like this.
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 hours ago — The 2022 Saab 9-3 is a compact control car, originally developed by Swedish carmaker Saab. Saab is based on the 9.3 GM Epsilon platform and …https://www.gtopcars.com/
I read more about it here https://cryptoine.com/bitcoin-era/
I selected CoinGecko’s API due to the fact the alternative most important virtual asset facts site, CoinMarketCap, is infamous for publishing faux extant records on coins.
Please get me back if you need people to work with the team, I’d love to join coingecko
These examples have been automatically selected and may contain sensitive content. Read more… They will be looking at a cutting-edge treatment to help with the …https://clickmorestuff.com/cutting-edge-example/
If your miner cannot operate normally, You need a professional tester for hash board. An Antminer universal chip fixture test fixture is required to locate the faulty chip, which is accurate and efficient, and the inspection time is short. Make your miner run normally as soon as possible.
https://www.zeusbtc.com/ASIC-Miner-Repair/Parts-Tools-Details.asp?ID=212
Impressive, very nice information. Thanks for spreading this knowledge. look once Online Exam Assistance
I am interest for this post. Very helpful information.
Online Marketing Agency
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.
After exporting to Excel, I ran it in google spreadsheets. That’s what I was looking for, thanks.
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.
How to Convert Your Youtube Video For Free using Flvto converter 200: A blog on how to convert your youtube video.
Hello. I need Twitter, Reddit and Telegram for all the coins. How can I have all this together in Excel?
thank you
It is an amazing post and you explained it in a detailed way. Nice to see this here. I will bookmark your blog for more details. Keep sharing new things like this.
Token Development Company |
Unifarm is the best platform for your crypto staking and farming. It pays huge interest. http://www.unifarm.co
Hi
How can I api all tokens (full list) including market data and their relevant categories. The list below is only downloading 250 tokens into excel ?
GET
/coins/markets
List all supported coins price, market cap, volume, and market related data
Cryptosheets is not reliable. They just cancel user accounts without any notice and don’t respond to support requests…Please find an alternative way to make your info available to Mac users.
Are You A Crazy Car Lover? Or Just A Casual Car User? CarFirst Blog is Best Car Tips, Reviews & Industry News Source for You. Subscribe (Fisker Karma)Our Blog For Automotive News and Updates.
METAMUSK team is launching the first token Airdrop of 500kk METAMUSK (2.5 BNB).
Get on official website –> https://muskmetaverse.me
Unifarm is the best Cryptocurrency token currently. You stake one and farm all. You are rewarded with bout four good tokens and enjoy the best a DeFi platform can offer. With Unifarm the issue of pump and dump is almost eradicated and you have nothing to be afraid of holding the token
Very well informative knowledge. You make to easier to understand about crypto for anyone. Good work! Butcher Suppliers
I find this right place for this content. Reddit
This article is more informative and useful to me. Thanks for sharing!
During this period of uncertainty in the crypto market, we need the help of an expert in the form of a financial advisor that specializes in beating the market makers and maximizing profits for clients. Contact Mr Kyle Morgan on whatsapp +12087322211
He is trustworthy. Verified ✅
Thank you very much for sharing your knowledge and information; it has greatly aided me in my job and personal life.
Thank you for the info!
hey mates search potustrumpnft on telegram , join to mint free nft , giveaway going on !
You have explained the whole process in a very beautiful manner, Never knew it would be this easy to import your coingecko data to micrsoft excel.
Thank you very much for sharing your knowledge and information; it has greatly aided me in my job and personal life.
Will this work with open office calc ?
This lets you execute the full power of microsoft excel
Thanks for sharing. Great Information.
Do you have questions about pain management, acute injuries, and physical therapy? If you are not sure that you would benefit from physiotherapy care and would like to schedule a free physiotherapy consultation in Dubai, please get in touch via the form below. We would be happy to help! https://www.thelabphysio.ae/
“An Odd Tale” is a curated platform of artists and designers from the Middle East and North Africa.The works we carefully select and present, reflect and celebrate the local visual narratives of our vibrant region. https://anoddtale.com/
Try Play Deposit 20 Get 100 Free at PG Slot Experience the enjoyment and enjoyment to the fullest with more slot games. 500+ makes the game progress through the website.
Create your own crypto tokens with Binance BEP20 token development. Leverage decentralized finance on binance smart chain with cross-chain compatibility.
Best guide. Great working!
Megagame Online Slot #1 Entrance Play Slots Easiest To Crack PG Games Break Frequent Promotions Bonuses and Free Credits Maximum online slots require MEGASLOTGAME everything via automation.
I think this is an educational post and it is helpful and learned.
As a result, before employing any best essay write my essay reviews service provider, consider the following factors.
Cryptocurrency exchanges today are diverse and popular, attracting the interest of investors. Accordingly, you should also grasp how to register for the MEXC floor first before you can grasp how it works. If you are trading virtual currency, it should be done at a quality exchange to ensure safety. read more: https://vietkita.com/dang-ky-san-mexc/
Megagame online slots No. 1, the entrance to play slots, the easiest to break, PG games, often broken, promotions, bonuses and free credits, the highest online slots, must be megaslotgame.com, everything goes through an automatic system.
I adore this article for its well-researched content and great wording.
Thank you so much for such a useful information. I will subscribe.