Skip to main content
The Messari Microsoft Excel Add-In lets you pull Messari’s market, on-chain, and social data directly into Microsoft Excel 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

​
Microsoft Marketplace

Coming soon

​
Sideloading - 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.

​
Sideloading - 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

​
Launch Add-On

Go to the “Home” Menu under “Messari” > Select “Show Taskpane” Add-On Launch

​
Authentication

After selecting “Get Started”, you’ll be prompted to authenticate with your Messari API key. Once you have your API key, click Sign in and enter your API key Each user must authenticate individually. In shared spreadsheets, formulas will 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 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
Note: If you don’t see any metrics after selecting an entity, Messari may not currently have data coverage for that entity and metric combination, or the metric may not be included in your current API access.

​
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_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 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)

​
Access to Metrics

Access to specific metrics in the Messari spreadsheet plugin is determined by your organization’s API permissions. By default, enterprise organizations have access to market, exchange, and asset metrics. Access to additional datasets such as on-chain metrics, mindshare, and sentiment requires the corresponding API permissions. You can view your available APIs and permissions in your account settings:
https://messari.io/account/api . If a metric does not appear in the Formula Builder, it may not be included in your current API access.

​
Share Feedback Here

​
Terms of Service: https://messari.io/terms-of-service

​
Privacy Policy: https://messari.io/privacy-policy