Skip to content

Using Amalgam with Claude in Excel

Connect Claude to your Amalgam Excel add-in so you can ask it, in plain English, to pull reports, sync resources, switch integrations, and navigate Amalgam without clicking around the sidebar.

Example: “Pull a Q1 P&L from our main QuickBooks integration.” Claude finds the right report, creates a sheet, sets the period filter, and runs it for you.

If you want to use Amalgam from Claude without Excel, in the Claude app, Claude Code or ChatGPT, use the Amalgam MCP connector instead: Connect Amalgam to Claude or ChatGPT.

  • A Claude account on any plan. Skills need Code execution and file creation turned on under Settings > Capabilities. On Team and Enterprise plans an organization owner may need to allow user-created skills.
  • The Amalgam Excel add-in installed and signed in. Claude drives the add-in, so it still needs to be running.
  • Excel for Windows or Mac (desktop), which the add-in requires.

Download amalgam-automation.zip and save it somewhere you can find it. You do not need to unzip it. Claude accepts the zip directly.

  1. Go to claude.ai and sign in.
  2. Open Customize > Skills.
  3. Click +, then Create skill, then Upload a skill.
  4. Select the amalgam-automation.zip you downloaded.
  5. Amalgam Automation appears in your skills list. Make sure its switch is on.

The skill is now available anywhere you use Claude on this account, including Claude in Excel.

Step 3: Turn On Automation Mode in Amalgam

Section titled “Step 3: Turn On Automation Mode in Amalgam”

In Excel, open the Amalgam sidebar:

  1. Click the hamburger menu at the top of the sidebar.
  2. Click Enable Automation Mode.

A new sheet called AMALGAM_CONTROLS (cyan tab) appears in your workbook. This is how Claude and the add-in talk to each other. You do not need to touch it, but do not delete it while you are working.

Tip: Automation Mode is per workbook. Turn it on in any workbook where you want Claude to help.

Open Claude in Excel (or claude.ai with your workbook open) and try one of these:

  • “List the QuickBooks reports available.”
  • “Create a General Ledger report for our main QBO integration.”
  • “Run the report I just made with no row limit.”
  • “What integrations do we have for Brex?”
  • “Switch this sheet to use the staging QuickBooks integration instead.”
  • “Refresh the dropdowns on this resource sheet.”

Claude narrates what it is doing in chat and writes the results into your workbook.

  • Sidebar clicks always win. If you click around in the Amalgam sidebar while Claude is working, your clicks take priority. Claude re-checks state and adapts.
  • Do not edit column A of an Amalgam-managed sheet. Column A holds the link between the sheet and your provider and integration. If it is edited, the sheet has to be recreated.
  • Reports are read-only output. Resources are writeable. Claude knows the difference and uses the right verb (run for reports, sync for resources).

Claude says Automation Mode is not enabled. Open the Amalgam sidebar’s hamburger menu and click Enable Automation Mode. The AMALGAM_CONTROLS sheet should appear.

Nothing happens when you ask Claude. Check that the skill is installed and switched on under Customize > Skills, that you are signed in to Amalgam in the sidebar, and that the AMALGAM_CONTROLS sheet exists in this workbook.

Claude is operating on the wrong sheet. This usually happens after clicking a different worksheet tab while Claude is mid-task. Tell Claude: “Switch back to the [SheetName] sheet and try again.”

It says you are not signed in. Sign in via the Amalgam sidebar, then ask Claude to retry.

Does this work in Claude Desktop, Claude Code or ChatGPT? The skill drives the Excel add-in, so it only makes sense next to Excel. For everything else, the Amalgam MCP connector gives those tools direct access to your Amalgam account: Connect Amalgam to Claude or ChatGPT.

Is my data sent to Anthropic? The skill itself is just instructions. It does not send data anywhere on its own. When Claude reads or writes cells in your workbook, that activity follows the same data handling as your normal Claude session. See Anthropic’s privacy documentation for details.

Can Claude make changes I did not ask for? Claude only writes to cells when you ask it to. The skill instructs Claude to confirm destructive actions and never to edit Amalgam’s internal metadata column.

How do I uninstall it? Go to Customize > Skills, click Amalgam Automation, switch it off, click the … button next to the switch and choose Delete.