Comment
Author: Admin | 2025-04-28
Kept it simple and included just four columns: Ticker, Price, Change, Price Change % and Market Cap.How to Import Live Crypto Prices into Excel SpreadsheetsThe easiest way to import live crypto prices is by using Excel's "Data from Web" feature, and connecting it with CoinGecko's crypto API endpoint /coins/markets. Head over to our comprehensive API documentation to retrieve this endpoint's Request URL.Coins List with Market Data is one of the most commonly used crypto API endpoints that traders, developers, projects and analysts rely on to fetch real-time crypto price data. With only two API calls on this endpoint, you can retrieve data of the top 500 cryptocurrencies listed on CoinGecko, which is typically enough for most. To import data for coins beyond the top 500 or smaller market cap cryptocurrencies, simply adjust the ‘Page’ parameters accordingly (each page displays 250 coins data).Provide your API key and fill in the parameters:Tip: If you’d like to import coins data for specific crypto categories rather than pulling in a whole list of top 250 or 500 cryptocurrencies, input the respective category id in the ‘category’ parameter field.In the example below, we’ll look at pulling data for the ‘telegram-bots’ category.Click on the ‘Execute’ button to generate the Request URL.In our example, the Request URL for the top 250 cryptocurrencies is:https://api.coingecko.com/api/v3/coins/markets?vs_currency=usdℴ=market_cap_desc&per_page=250&page=1&sparkline=false&price_change_percentage=1h%2C24h&locale=en&precision=3The Request URL for the next 250 cryptocurrencies (top 251 to 500) is:https://api.coingecko.com/api/v3/coins/markets?vs_currency=usdℴ=market_cap_desc&per_page=250&page=2&sparkline=false&price_change_percentage=1h%2C24h&locale=en&precision=3As highlighted in yellow above, the key difference between the two Request URLs generated is the page number.Finally, the Request URL for the
Add Comment