> ## Documentation Index
> Fetch the complete documentation index at: https://docs.coingecko.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CoinGecko for Microsoft Excel (Official)

> The CoinGecko Official Excel Add-in brings the world's most comprehensive crypto data directly into your spreadsheet workflow — live prices, historical data, NFT floor prices, on-chain token prices, and market cap rankings, all refreshable with a single click.

<Frame>
  <img src="https://mintcdn.com/coingecko/wbgsV6iJoz8KuwY_/images/CoinGecko-for-Excel-1-%E2%80%93-1366-x-768-2.png?fit=max&auto=format&n=wbgsV6iJoz8KuwY_&q=85&s=bdd122e79021e2a91eb946bed4123fd1" alt="Coin Gecko For Excel 1 – 1366 X 768 2" width="1366" height="768" data-path="images/CoinGecko-for-Excel-1-–-1366-x-768-2.png" />
</Frame>

<Check>
  Your privacy is our priority. The add-in only communicates with the CoinGecko API using your saved API key. No personal data is sent to any third party.

  If you have any questions or feedback, please share with us [**here**](https://forms.gle/Ndm7qRC3QVE4YYhB7).
</Check>

***

## 1. Quick Start

<Steps>
  <Step title="Install the Add-in">
    Search for '**CoinGecko**' and Install directly from the Excel Add-ins store, or visit the [Microsoft Marketplace](https://marketplace.microsoft.com/en-us/product/office/WA200010662).

    <Frame>
      <img src="https://mintcdn.com/coingecko/2PxBJfCoivqbzO0q/images/Screenshot-2026-04-29-at-12.22.33-PM-1.png?fit=max&auto=format&n=2PxBJfCoivqbzO0q&q=85&s=e80e0a99dfddefbc0fdb5d9d4812002c" alt="Screenshot 2026 04 29 At 12 22 33 PM 1" width="868" height="511" data-path="images/Screenshot-2026-04-29-at-12.22.33-PM-1.png" />
    </Frame>
  </Step>

  <Step title="Open the Taskpane">
    Go to **Home → CoinGecko** in the Excel ribbon to open the taskpane sidebar.
  </Step>

  <Step title="Set Your API Key">
    Enter your [CoinGecko API key](https://www.coingecko.com/en/api/pricing), then click **Save Settings**. A green status dot confirms a valid connection.

    <Frame>
      <img src="https://mintcdn.com/coingecko/2PxBJfCoivqbzO0q/images/Screenshot-2026-04-29-at-12.26.44-PM.png?fit=max&auto=format&n=2PxBJfCoivqbzO0q&q=85&s=b0d8775e4a911874d5ac52f22e010641" alt="Screenshot 2026 04 29 At 12 26 44 PM" width="2492" height="1386" data-path="images/Screenshot-2026-04-29-at-12.26.44-PM.png" />
    </Frame>
  </Step>
</Steps>

***

## 2. Formulas

All formulas use the `CG` namespace. Enter them in any cell like a standard Excel formula.

<Tip>
  **Pro Tip:**

  * Use the **Coin ID** (e.g., `bitcoin`, `ethereum`) rather than the ticker symbol for the most reliable results.
  * You can find the coin API ID in the URL on CoinGecko, i.e. [coingecko.com/en/coins/bitcoin](https://www.coingecko.com/en/coins/bitcoin)
  * You can also get the full list via this [endpoint](/reference/coins-list-new) or [Google Sheet](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0).
</Tip>

***

### `=CG.PRICE(id)`

Returns the **current USD price** of a coin.

| Parameter | Type   | Description                                                                                                                                                                                   |
| :-------- | :----- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `id`      | string | CoinGecko coin ID (e.g. `"bitcoin"`, `"ethereum"`)<br /><br />View full [**Coin IDs**](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0). |

**Returns:** Number — current price in USD

```text theme={null}
=CG.PRICE("bitcoin")        → 95000
=CG.PRICE("ethereum")       → 3400
=CG.PRICE("solana")         → 180
```

***

### `=CG.HISTORY(id, date)`

Returns the **historical USD price** of a coin on a specific date.

| Parameter | Type   | Description                                                                                                                                                                                   |
| :-------- | :----- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `id`      | string | CoinGecko coin ID (e.g. `"bitcoin"`, `"ethereum"`)<br /><br />View full [**Coin IDs**](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0). |
| `date`    | string | Date in `YYYY-MM-DD` format                                                                                                                                                                   |

**Returns:** Number — USD price on that date

```text theme={null}
=CG.HISTORY("bitcoin", "2023-12-31")     → 16541.77
=CG.HISTORY("ethereum", "2021-12-31")    → 3682.45
```

<Note>
  Date must be in `YYYY-MM-DD` format. Example: February 1, 2023 = `"2023-02-01"`
</Note>

***

### `=CG.NFT(id)`

Returns the **current floor price (USD)** of an NFT collection.

| Parameter | Type   | Description                                                                                                                                                                                                           |
| :-------- | :----- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `id`      | string | CoinGecko NFT collection ID (e.g. `"bored-ape-yacht-club"`)<br /><br />View full [**NFT IDs**](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=207968092#gid=207968092). |

**Returns:** Number — floor price in USD

```text theme={null}
=CG.NFT("bored-ape-yacht-club")    → 24500
=CG.NFT("cryptopunks")             → 68000
=CG.NFT("pudgy-penguins")          → 8200
```

***

### `=CG.ONCHAIN(network, address)`

Returns the **current USD price of an on-chain token** by its network and contract address.

| Parameter | Type   | Description                                                                                                                                                                                                           |
| :-------- | :----- | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `network` | string | Network ID (e.g. `"eth"`, `"bsc"`, `"solana"`)<br /><br />Get full [**Onchain network IDs**](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=1120233236#gid=1120233236). |
| `address` | string | Token contract address                                                                                                                                                                                                |

**Returns:** Number — token price in USD

```text theme={null}
=CG.ONCHAIN("eth", "0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48")
=CG.ONCHAIN("bsc", "0x55d398326f99059ff775485246999027b3197955")
```

**Common network IDs:**

| Network         | ID         |
| :-------------- | :--------- |
| Ethereum        | `eth`      |
| BNB Smart Chain | `bsc`      |
| Solana          | `solana`   |
| Arbitrum        | `arbitrum` |
| Base            | `base`     |

***

### `=CG.TOP(limit, [category])`

Returns a **ranked table of top coins by market cap**.

<Frame>
  <img src="https://mintcdn.com/coingecko/wbgsV6iJoz8KuwY_/images/Screenshot-2026-04-24-at-4.31.50-PM.png?fit=max&auto=format&n=wbgsV6iJoz8KuwY_&q=85&s=23bb05c5c46bd764eb00eaa339bf6fd0" alt="Screenshot 2026 04 24 At 4 31 50 PM" width="1750" height="1124" data-path="images/Screenshot-2026-04-24-at-4.31.50-PM.png" />
</Frame>

| Parameter  | Type                | Description                             |
| :--------- | :------------------ | :-------------------------------------- |
| `limit`    | number              | Number of coins to return (1-10000)     |
| `category` | string *(optional)* | CoinGecko category ID to filter results |

```text theme={null}
=CG.TOP(10)                            → Top 10 coins by market cap
=CG.TOP(100)                           → Top 100 coins by market cap
=CG.TOP(50, "decentralized-exchange")  → Top 50 DEX tokens
=CG.TOP(20, "layer-1")                 → Top 20 Layer-1 coins
```

<Note>
  Enter `=CG.TOP(...)` in a **single cell** and let the results spill automatically into adjacent rows and columns. Do not pre-select a range.
</Note>

<Tip>
  **Tip:**

  * Find category IDs by browsing the [CoinGecko categories page](https://www.coingecko.com/en/categories) and copying the ID from the URL.
  * You can also get the full list via this [endpoint](https://docs.coingecko.com/reference/coins-categories-list) or [Google Sheet](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=214581757#gid=214581757).
</Tip>

***

## 3. Taskpane Actions

#### Refresh All Data 🔄

Clears the in-memory cache and forces all `=CG.*` formulas in the workbook to recalculate with fresh data from the API.

#### Save 💾

Saves your API key and plan selection. Automatically validates the key against the API and clears the cache.

<Frame>
  <img src="https://mintcdn.com/coingecko/wbgsV6iJoz8KuwY_/images/CoinGecko-for-Excel-2-%E2%80%93-1366-x-768-1.png?fit=max&auto=format&n=wbgsV6iJoz8KuwY_&q=85&s=7430e0306ee9c7a535b382659c227d7e" alt="Coin Gecko For Excel 2 – 1366 X 768 1" width="1366" height="768" data-path="images/CoinGecko-for-Excel-2-–-1366-x-768-1.png" />
</Frame>

***

## 4. Troubleshooting & FAQ

**Why is my formula showing #NAME??**

* Ensure the add-in is installed and loaded. The `CG` namespace is only available when the add-in is active.

**How do I find a Coin ID or NFT ID?**

* You can get the full list of supported CoinGecko API IDs [**here**](https://docs.google.com/spreadsheets/d/1wTTuxXt8n9q7C4NDXqQpI3wpKu1_5bGVmP9Xz0XGSyU/edit?gid=0#gid=0), or visit [**CoinGecko.com**](https://www.coingecko.com) - the Coin ID can also be found in the "API ID" section on the right sidebar of the coin or NFT's page.

**Why am I seeing Error: Invalid API Key?**

* Open the taskpane, re-enter your API key, and click **Save**.

**Why am I seeing Error: Rate Limit — wait and retry?**

* You have exceeded the API rate limit. Wait a moment, then click **Refresh All Data** in the taskpane.

**Why does =CG.HISTORY return no data?**

* Confirm the date is in `YYYY-MM-DD` format and that the coin existed on that date.

**Why does =CG.TOP only show one cell?**

* Make sure the cells below and to the right are empty so the array can spill. Excel requires free space for spill ranges.

**What is your privacy policy?**

* Please view the full details of our privacy policy [**here**](https://docs.coingecko.com/docs/excel/privacy-policy).

**How do I share feedback?**

* Please share feedback with us [**here**](https://forms.gle/Ndm7qRC3QVE4YYhB7).