CoinGecko: Live Crypto Prices & Market Data

Bring the power of CoinGecko’s world-leading cryptocurrency data directly into your Excel™ spreadsheets.

Designed for professional analysts and DeFi traders, this add-in provides institutional-grade access to 18,000+ coins and 30 million+ onchain tokens aggregated across 1,700+ exchanges and 250+ networks.

Key Features

Live Price and Market Data

Fetch real-time cryptocurrency prices using simple, native Excel formulas:

• =CG.PRICE("bitcoin") — Current Bitcoin price in USD
• =CG.PRICE("solana") — Current Solana price in USD

Onchain and DEX Data

Track decentralized exchange prices for any token with a contract address—powered by GeckoTerminal:

• =CG.ONCHAIN("eth", "0xa0b...eb48") — Ethereum network token
• =CG.ONCHAIN("solana", "2zM...ds76") — Solana SPL token

Perfect for meme coin hunters, DeFi researchers, and long-tail altcoin portfolio trackers.

NFT Floor Prices

Monitor NFT collection floor prices directly in your spreadsheet — no third-party tools needed:

• =CG.NFT("pudgy-penguins") — Pudgy Penguins floor price

Historical Price Data

Build backtesting models, analyze price trends, or power your crypto trading journal:

• =CG.HISTORY("bitcoin", "2021-12-31") — Bitcoin price on a specific date (UTC 00:00)

Market Cap Rankings

Import up to 5,000 tokens in a single formula:

• =CG.TOP(100) — Top 100 cryptocurrencies by market cap
• =CG.TOP(50, "decentralized-exchange") — Top 50 DEX tokens

High Performance

Built with streaming technology to handle up to 10,000 rows without freezing Excel.

Getting Started

1. Install the add-in from Microsoft Marketplace or the Excel Add-ins store.
2. Open any Microsoft Excel™ document.
3. Get your API key (free Demo plan or a paid Pro plan) at https://www.coingecko.com/en/api/pricing
4. Enter your key via Add-ins → CoinGecko → Settings.
5. Start tracking: Type =CG.PRICE("bitcoin") in any cell and press Enter.

Pricing

The add-in itself is free to install. API usage is billed through your CoinGecko API plan:

• Demo API (Free): Suitable for personal portfolio tracking and casual use.
• Pro API (Paid): Higher rate limits and access to 10 years+ historical data for power users and professionals.

Support and Resources

For full documentation and advanced guides, visit: https://docs.coingecko.com/docs/excel

Stop copy-pasting and start automating your crypto research today.