Skip to main content

​
Overview

The Messari Spreadsheet Plugin lets you pull Messari’’s market, on-chian, and social data directly into Excel and Google Sheets using native formulas or the built-in Formula Builder. You can use it to:
  • Pull latest or historical metrics
  • Build dashboards and models
  • Compare assets, networks, exchanges, and sectors

​
Installation

​
Beta - Excel (Web)

  1. Download the Messari manifest file
  2. Open Excel for Web
  3. Open an existing workbook or create a new one
  4. Select Add-ins from the toolbar
  5. Choose Advanced
  6. Select Upload custom add-in
  7. Upload the manifest file
Once installed, the Messari plugin will appear in the task bar. Click it to open the sidebar.

​

Beta - Excel (Mac)
  1. Open Finder and press Cmd + Shift + G
  2. Navigate to: 
    ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef
    • If the wef folder does not exist, create it
  3. Copy or move the manifest file into this folder
  4. Restart Excel
  5. Open a new workbook
  6. Go to Add-ins
  7. Find Messari Data under Developer Add-ins
  8. Click to enable the Formula Builder

​
Google sheets

Coming soon

​
Excel - Desktop (Beta)

Coming soon

​
Getting Started

​
Authentication

When you open the plugin for the first time, you’ll be prompted to authenticate.
  • Existing Messari users: click Sign in and enter your API key
  • If you don’t have an API key, follow the link to generate one in account settings
Each user must authenticate individually. In shared spreadsheets, formulas will only run for authenticated users.

​
Using the Formula Builder

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

​
Step 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 correct entity quickly.

​
Step 2: Select a metric

After selecting an entity, choose a metric such as:
  • Market cap
  • Volume
  • Price
  • TVL
  • Revenue
  • Mindshare
If you don’t see any metrics after selecting an entity, that means Messari does not currently have data coverage for that entity-metric combination.

​
Step 3: Select a time period

Choose how you want the data returned:
  • Latest
  • Specific date
  • Last 7 / 14 / 30 days
  • Custom date range

​
Step 4: Insert or copy the formula

Click Insert Formula to insert the formula directly into the selected cell. You can also copy the formula and paste it into any cell manually.

​
Formula Syntax

You can always write formulas directly without using 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

Returns the most recent daily value. Syntax 
=messari_latest("metric", "entity")
Examples 
=messari_latest("volume", "ethereum")
Latest daily volume for Ethereum 
=messari_latest("network.tvl", "base")
Latest daily TVL for the Base network

​
=messari_series

Returns a time series over a date range. Syntax 
=messari_series( "metric","entity", "startDate","endDate",includeHeaders,includeDateCol)
The includeHeaders and inlcudeDateCol 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)

​
Share Feedback Here