> ## Documentation Index > Fetch the complete documentation index at: https://docs.messari.io/llms.txt > Use this file to discover all available pages before exploring further. # Microsoft Excel Add-In 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 You can find the Add-In in the Microsoft Marketplace: [https://marketplace.microsoft.com/en-us/product/WA200010088](https://marketplace.microsoft.com/en-us/product/WA200010088) Microsoft Marketplace Messari Add-In ### 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. * If you are an existing Messari user, you can view / generate your API key under account settings: [https://messari.io/account/api](https://messari.io/account/api) * If you are not a Messari user, you can sign up for an enterprise account here: [https://messari.io/enterprise/signup](https://messari.io/enterprise/signup) 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](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](https://06jiny4c1wy.typeform.com/to/CHPpGGYb) ### Terms of Service: [https://messari.io/terms-of-service](https://messari.io/terms-of-service) ### Privacy Policy: [https://messari.io/privacy-policy](https://messari.io/privacy-policy)