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

Set up the Claude add-in for Microsoft 365

• Follow the steps in the Claude for Microsoft 365 documentation (opens in a new tab) 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 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:

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:

Advanced example - Profit and loss report

Steps:

• Open the DataDoe 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:

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: