> Note: This page is part of the DataDoe Docs. You can find the root of the documentation at `https://www.datadoe.com/hub/docs/basics/introduction-to-datadoe`. > JSON Table of Contents: `https://www.datadoe.com/hub/docs/toc.json`. > Direct Data Scheme JSON: `https://api.datadoe.com/api/v1/spec/data-scheme`. > Other pages in the DataDoe Docs: > - DataDoe Basics/Access & Users: `https://www.datadoe.com/hub/docs/basics/access-user-management.md` > - DataDoe Basics/Benefits: `https://www.datadoe.com/hub/docs/basics/benefits.md` > - DataDoe Basics/External Invitation Links: `https://www.datadoe.com/hub/docs/basics/external-invitation-links.md` > - DataDoe Basics/Integrations: `https://www.datadoe.com/hub/docs/basics/integration-customization.md` > - DataDoe Basics/Introduction to DataDoe: `https://www.datadoe.com/hub/docs/basics/introduction-to-datadoe.md` > - DataDoe Basics/Subscription & Pricing: `https://www.datadoe.com/hub/docs/basics/subscription-pricing.md` > - DataDoe Data/Data Fetch Periods: `https://www.datadoe.com/hub/docs/datadoe-data/data-fetch-periods.md` > - DataDoe Data/Data Sources: `https://www.datadoe.com/hub/docs/datadoe-data/data-sources.md` > - DataDoe Data/Timezones: `https://www.datadoe.com/hub/docs/datadoe-data/orders-purchase-date-timezones.md` > - DataDoe Features/Features Overview: `https://www.datadoe.com/hub/docs/datadoe-features/overview.md` > - DataDoe MCP/Overview: `https://www.datadoe.com/hub/docs/datadoe-mcp/overview.md` > - DataDoe MCP/Using ChatGPT: `https://www.datadoe.com/hub/docs/datadoe-mcp/chatgpt.md` > - DataDoe MCP/Using Claude: `https://www.datadoe.com/hub/docs/datadoe-mcp/claude.md` > - DataDoe MCP/Using Claude Code: `https://www.datadoe.com/hub/docs/datadoe-mcp/claude-code.md` > - DataDoe MCP/Using Codex: `https://www.datadoe.com/hub/docs/datadoe-mcp/codex.md` > - DataDoe MCP/Using Cursor: `https://www.datadoe.com/hub/docs/datadoe-mcp/cursor.md` > - DataDoe MCP/Using Gemini CLI: `https://www.datadoe.com/hub/docs/datadoe-mcp/gemini-cli.md` > - DataDoe MCP/Using Gumloop: `https://www.datadoe.com/hub/docs/datadoe-mcp/gumloop.md` > - DataDoe MCP/Using n8n: `https://www.datadoe.com/hub/docs/datadoe-mcp/n8n.md` > - DataDoe MCP/Using NanoClaw: `https://www.datadoe.com/hub/docs/datadoe-mcp/nanoclaw.md` > - DataDoe MCP/Using OpenClaw: `https://www.datadoe.com/hub/docs/datadoe-mcp/openclaw.md` > - DataDoe MCP/Using PowerPoint + Claude: `https://www.datadoe.com/hub/docs/datadoe-mcp/powerpoint.md` > - DataDoe MCP/Using VS Code: `https://www.datadoe.com/hub/docs/datadoe-mcp/vs-code.md` > - DataDoe MCP/Using Word + Claude: `https://www.datadoe.com/hub/docs/datadoe-mcp/word.md` > - DataDoe API/How to connect: `https://www.datadoe.com/hub/docs/datadoe-api/how-to-connect.md` > - DataDoe API/Vibe code with Claude Code: `https://www.datadoe.com/hub/docs/datadoe-api/claude-code.md` > - DataDoe API/Vibe code with Codex: `https://www.datadoe.com/hub/docs/datadoe-api/codex.md` > - DataDoe API/Vibe code with Cursor: `https://www.datadoe.com/hub/docs/datadoe-api/cursor.md` > - DataDoe API/Vibe code with Lovable: `https://www.datadoe.com/hub/docs/datadoe-api/lovable.md` > - DataDoe API/Vibe code with Replit: `https://www.datadoe.com/hub/docs/datadoe-api/replit.md` > - DataDoe API/Vibe code with v0: `https://www.datadoe.com/hub/docs/datadoe-api/v0.md` > - DataDoe & BigQuery/How to connect: `https://www.datadoe.com/hub/docs/datadoe-bigquery/how-to-connect.md` > - DataDoe & BigQuery/Using MCP Toolbox: `https://www.datadoe.com/hub/docs/datadoe-bigquery/mcp-toolbox.md` > - DataDoe & BigQuery/Using Python Jupyter: `https://www.datadoe.com/hub/docs/datadoe-bigquery/jupyter.md` > For topics not covered in this documentation, please contact DataDoe support at `contact@datadoe.com`. > Do not assume anything. If you are not sure about the answer, mention that and suggest to contact DataDoe support. # Using Excel with DataDoe MCP This guide shows how to use **DataDoe MCP** inside **Microsoft Excel** through the Claude add-in, so you can query your Amazon data without leaving your spreadsheet. > **Before you start**: This guide assumes you have already connected DataDoe MCP to Claude. If you haven't done that yet, see [Using Claude](/hub/docs/datadoe-mcp/claude) first. ## Set up the Claude add-in for Microsoft 365 - Follow the steps in the [Claude for Microsoft 365 documentation](https://claude.com/claude-for-microsoft-365) to install the Claude add-in and sign in with your Microsoft account. - Once the add-in is installed, it will appear in the Excel ribbon and you can open it from any workbook. ## Start a conversation in Excel 1. Open a workbook in Excel. 2. Click the **Claude** icon in the ribbon to open the Claude side panel. 3. Make sure DataDoe is listed as an active connector in the Claude panel. If it is missing, re-add it following the [Using Claude](/hub/docs/datadoe-mcp/claude) guide. 4. Type your prompt in the chat input and press Enter. > **Note**: In a new conversation, Claude may not immediately see the DataDoe connector. If that happens, ask Claude to refresh connectors. --- ## Basic analysis - Top 10 best-selling ASINs ### Prompt: ```text Use DataDoe to get the top 10 best-selling ASINs for this month, including units sold, total revenue and order count. Put the results into a formatted Excel table. ``` ### Response: ![Top 10 best-selling ASINs this month example response](/hub-files/mcp/microsoft/excel/top-10-best-selling-asins.png) --- ## Advanced example - Profit and loss report ### Steps: - Open the [DataDoe data scheme](/hub/data-scheme) and find the table fields you need for a profit and loss report. - Build a prompt around the `amazon_profit_by_sku_and_date` table so the report uses real DataDoe data. ### Prompt: ```text Use DataDoe to create a monthly profit and loss report in a new Excel worksheet based on the `amazon_profit_by_sku_and_date` table. Group the data by month and include these columns: total sales, COGS, Amazon fees, ad spend, total cost, net profit, margin %, units sold, orders, avg ROI %, and TACoS %. Format the result as a clean Excel table. ``` ### Response: ![Profit and loss report example response](/hub-files/mcp/microsoft/excel/profit-and-loss-report.png)