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

# Microsoft Excel

> Install the Messari by Blockworks add-in for Microsoft Excel and pull Blockworks data into your workbook with native formulas or the Formula Builder.

The Messari by Blockworks add-in for Microsoft Excel pulls Blockworks market, onchain, and
social data directly into your workbook, either with native formulas or through the built-in
Formula Builder. The add-in is listed in the Microsoft Marketplace and in the Excel ribbon
under the **Messari** name, and its formulas carry the `messari_` prefix.

You can use it to:

* Pull latest or historical metrics
* Build dashboards and models
* Compare assets, networks, exchanges, and sectors

## Installation

### Microsoft Marketplace

Install the add-in from the Microsoft Marketplace:
[marketplace.microsoft.com/en-us/product/WA200010088](https://marketplace.microsoft.com/en-us/product/WA200010088).

<img src="https://mintcdn.com/blockworksdocs/vDpnGk-ikoW5GBXD/images/spreadsheets/excel-listing.png?fit=max&auto=format&n=vDpnGk-ikoW5GBXD&q=85&s=b2755a50b3f682a003dbc8fe6e8f1b57" alt="Messari by Blockworks listing in the Microsoft Marketplace" width="2280" height="1590" data-path="images/spreadsheets/excel-listing.png" />

### Sideloading on Excel for Web

<Steps>
  <Step title="Download the manifest">
    Download the **Messari** manifest file.
  </Step>

  <Step title="Open a workbook">
    Open Excel for Web, then open an existing workbook or create a new one.
  </Step>

  <Step title="Upload the manifest">
    Select **Add-ins** from the toolbar, choose **Advanced**, then **Upload custom add-in**,
    and upload the manifest file.
  </Step>
</Steps>

Once installed, the add-in appears in the task bar. Click it to open the sidebar.

### Sideloading on Excel for Mac

<Steps>
  <Step title="Open the wef folder">
    Open Finder and press `Cmd + Shift + G`, then navigate to:

    ```
    ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef
    ```

    If the `wef` folder does not exist, create it.
  </Step>

  <Step title="Add the manifest">
    Copy or move the manifest file into that folder.
  </Step>

  <Step title="Restart Excel">
    Restart Excel and open a new workbook.
  </Step>

  <Step title="Enable the add-in">
    Go to **Add-ins**, find **Messari Data** under **Developer Add-ins**, and click it to
    enable the Formula Builder.
  </Step>
</Steps>

## Launch the add-in

On the **Home** menu, go to **Messari** > **Show Taskpane**.

<img src="https://mintcdn.com/blockworksdocs/vDpnGk-ikoW5GBXD/images/spreadsheets/excel-1.png?fit=max&auto=format&n=vDpnGk-ikoW5GBXD&q=85&s=117422d0eae3a3814122a90b4977feca" alt="Launching the add-in taskpane from the Home menu" width="1454" height="1160" data-path="images/spreadsheets/excel-1.png" />

### Authentication

After selecting **Get Started**, you are prompted to authenticate with your API key.

Generate or view your key at
[app.blockworks.com/account/api](https://app.blockworks.com/account/api). Once you have it,
click **Sign in** and enter the key.

Each user must authenticate individually. In shared spreadsheets, formulas only run for
authenticated users.

<img src="https://mintcdn.com/blockworksdocs/vDpnGk-ikoW5GBXD/images/spreadsheets/excel-2.png?fit=max&auto=format&n=vDpnGk-ikoW5GBXD&q=85&s=f5fd930762f9959358de341e6b551994" alt="Sign In" width="1476" height="1204" data-path="images/spreadsheets/excel-2.png" />

<img src="https://mintcdn.com/blockworksdocs/vDpnGk-ikoW5GBXD/images/spreadsheets/excel-3.png?fit=max&auto=format&n=vDpnGk-ikoW5GBXD&q=85&s=c3c219e0dd710ce0ec18ff90b662b83f" alt="Enter API Key" width="1456" height="1186" data-path="images/spreadsheets/excel-3.png" />

## Using the Formula Builder

The Formula Builder is the easiest way to get started and to discover what data is
available.

<Steps>
  <Step title="Select an entity">
    Choose what you want to analyze:

    * Assets
    * Assets on a specific network
    * Projects
    * Projects on a specific network
    * Networks
    * Exchanges
    * Exchanges on Networks
    * Sectors
    * Sub-Sectors
    * Markets

    Use search to find the entity quickly.
  </Step>

  <Step title="Select a metric">
    After selecting an entity, choose a metric such as market cap, volume, price, TVL,
    revenue, or mindshare.

    <Note>
      If no metrics appear after selecting an entity, there may be no data coverage for
      that entity and metric combination, or the metric may not be included in your API
      access.
    </Note>
  </Step>

  <Step title="Select a time period">
    Choose how the data comes back: latest, a specific date, the last 7, 14, or 30 days, or
    a custom date range.
  </Step>

  <Step title="Insert or copy the formula">
    Click **Insert Formula** to drop the formula into the selected cell. You can also copy
    it and paste it into any cell manually.
  </Step>
</Steps>

## Formula syntax

You can always write formulas directly without the builder.

### `=messari_point`

Returns the value for a specific date.

**Syntax**

```
=messari_point("metric", "entity", "date")
```

**Examples**

```
=messari_point("mcap", "ethereum", "2025-01-01")
```

Ethereum market cap on Jan 1, 2025

```
=messari_point("market.volume", "coinbase:BTC/USDT", "2025-01-01")
```

Coinbase BTC/USDT volume on Jan 1, 2025

```
=messari_point("sector.mcap", "DeFi", "2025-01-01")
```

DeFi sector market cap on Jan 1, 2025

### `=messari_latest_point`

Returns the most recent daily value.

**Syntax**

```
=messari_latest_point("metric", "entity")
```

**Examples**

```
=messari_latest_point("volume", "ethereum")
```

Latest daily volume for Ethereum

```
=messari_latest_point("asset.circulating.supply", "solana")
```

Latest daily circulating supply for Solana

### `=messari_series`

Returns a time series over a date range.

**Syntax**

```
=messari_series( "metric","entity", "startDate","endDate",includeHeaders,includeDateCol)
```

`includeHeaders` and `includeDateCol` are optional parameters.

**Examples**

```
=messari_series( "exchange.volume", "binance","2025-01-01","2025-01-30", true,true)
```

```
=messari_series( "asset.revenue", "chainlink", "2025-01-01","2025-01-30", true, true)
```

## Access to metrics

Which metrics you can pull is determined by your organization's API permissions. Datasets
such as onchain metrics, mindshare, and sentiment require the corresponding API access.

Review the APIs and permissions available to you at
[app.blockworks.com/account/api](https://app.blockworks.com/account/api). If a metric does
not appear in the Formula Builder, it is likely not included in your current access.