Skip to main content
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. Messari by Blockworks listing in the Microsoft Marketplace

​
Sideloading on Excel for Web

1

Download the manifest

Download the Messari manifest file.
2

Open a workbook

Open Excel for Web, then open an existing workbook or create a new one.
3

Upload the manifest

Select Add-ins from the toolbar, choose Advanced, then Upload custom add-in, and upload the manifest file.
Once installed, the add-in appears in the task bar. Click it to open the sidebar.

​
Sideloading on Excel for Mac

1

Open the wef folder

Open Finder and press Cmd + Shift + G, then navigate to:
If the wef folder does not exist, create it.
2

Add the manifest

Copy or move the manifest file into that folder.
3

Restart Excel

Restart Excel and open a new workbook.
4

Enable the add-in

Go to Add-ins, find Messari Data under Developer Add-ins, and click it to enable the Formula Builder.

​
Launch the add-in

On the Home menu, go to Messari > Show Taskpane. Launching the add-in taskpane from the Home menu

​
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. 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. Sign In Enter API Key

​
Using the Formula Builder

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

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.
2

Select a metric

After selecting an entity, choose a metric such as market cap, volume, price, TVL, revenue, or mindshare.
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.
3

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.
4

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.

​
Formula syntax

You can always write formulas directly without the builder.

​
=messari_point

Returns the value for a specific date. Syntax
Examples
Ethereum market cap on Jan 1, 2025
Coinbase BTC/USDT volume on Jan 1, 2025
DeFi sector market cap on Jan 1, 2025

​
=messari_latest_point

Returns the most recent daily value. Syntax
Examples
Latest daily volume for Ethereum
Latest daily circulating supply for Solana

​
=messari_series

Returns a time series over a date range. Syntax
includeHeaders and includeDateCol are optional parameters. Examples

​
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. If a metric does not appear in the Formula Builder, it is likely not included in your current access.