Paste your API key from CoinMarketCap in the box beside. Then, under HTTP request header parameters type X-CMC_PRO_API_KEY in the dropdown box. In this case, I have used to get the latest prices of BTC and LTC. Enter the API URL you would like to get data from in the top box of URL parts. Make sure the Advanced radio button is selected. Next, we need to input the URL we want to use and setup our API key as a header item to authenticate with CoinMarketCap. Under the Data tab in the ribbon, select Get Data > From Other Sources > From Web.

To pull the data into Excel, we use a web query. Step 1: Setup the CoinMarketCap Web Request in Excel For this example, I will use the symbol parameter. In order for proper data to be returned, a proper API key ( sign up on their website) must be passed as a header item and cryptocurrencies to return selected by the id/slug/symbol parameters. With the CoinMarketCap API, current quotes are handled by the endpoint. If you are using Excel 2013 or prior, you will need to install Power Query before attempting these steps. Be aware that this works best with Excel 2016 or greater, and doesn’t work with Excel for Mac. In this article, I will show you how to use a query to import current prices into Excel and have them updated regularly using the methods shown in the Import JSON Data in Excel article. If it is your wish to use Excel to import CoinMarketCap API data, and have it updated live, look no further. If you know a way please leave a comment.The CoinMarketCap Pro API is a great source for cryptocurrency data on current and historical prices, exchange information and more. I can't seem to figure out a way for it to have the same format - it looks like raw data but totally comprehensible. Click - Data - Get External Data - Run Web Query - (Pick the API file you saved in the first step) - click ok.Save the API link as plain text - make sure it has the.The steps should be similar for all platforms and Excel versions but this is specifically for a Mac Excel 2016. Although, for this you would need an API link from the website that you're trying to pull the data from. This could be helpful with websites such as where you can pull all the coin data from the website and have it update automatically in your file if you're using that data for statistics, algorithms, and etc.Īfter doing some research I figured out a way to do so in Excel. I thought I could do the same with Excel but unfortunately that did not work. One day one of my co-workers showed me a formula where you could pull data from different websites, that contained lists and tables and have it update it automatically in Google Sheets. I have been doing quite a bit of data entry work at my internship using excel.

Coinmarketcap api for excel mac