AI spreadsheet automation for live Excel workbooks

Local-first MCP automation for live spreadsheets with safe backups, rollback, formulas, tables, and style fidelity.

npx -y @components-kit/open-workbook setupnpx skills add components-kit/open-workbook \--skill open-workbook-excel

Act as our accounting operations agent: review the May close workbook, compare actuals against budget, identify unusual expense movement, and prepare controller-ready variance notes.

Accounting teams can control spreadsheet agents with detailed instructions, workbook context, and approval rules.

Reviewing GL totals and variance thresholdsChecking journal notes and close ownership

I can update the workbook with variance labels, draft explanations, and a controller review status while preserving the existing formulas.

After the review, write the approved notes back to the close tracker and mark rows that need controller approval before export.

I found 4 expense outliers, added explanations, and refreshed Close Tracker.xlsx.

Summary ready: travel, software, and contractor spend need approval notes before the close package is exported.

AutoSave

⌂□↺

HomeInsertPage LayoutFormulasDataReviewViewTable

Paste

Calibri (Body)

Wrap Text

General

×✓fx

$11,050

Agent workspace ready

Update Excel from any AI workflow.

OpenWorkbook connects live Excel workbooks to MCP, letting agents inspect, edit, and validate spreadsheets from the terminal, code editors, or any compatible assistant while your workbook stays open.

AutoSave

⌂□↺

May Close Tracker

HomeInsertPage LayoutFormulasDataReviewViewTable

Paste

Calibri (Body)

Wrap Text

General

Account

Budget

Actual

Var.

Owner

Status

Software

$18.4K

$21.1K

+14.8%

M. Chen

Review

Travel

$9.2K

$11.1K

+20.1%

A. Wells

Needs note

Contractor

$24.0K

$26.5K

+10.4%

S. Kim

Ready

Facilities

$7.8K

$7.6K

-2.1%

N. Brooks

Ready

Training

$4.5K

$5.3K

+16.9%

J. Rivera

Review

Licenses

$12.0K

$12.4K

+3.3%

M. Chen

Ready

Payroll

$86.0K

$85.6K

-0.5%

S. Kim

Ready

Benefits

$18.0K

$19.2K

+6.7%

A. Wells

Review

Hosting

$15.5K

$16.0K

+3.2%

N. Brooks

Ready

Security

$6.2K

$7.1K

+14.5%

J. Rivera

Review

Supplies

$3.8K

$3.4K

-10.5%

A. Wells

Ready

Legal

$10.0K

$9.7K

-3.0%

M. Chen

Ready

Events

$5.0K

$6.2K

+24.0%

N. Brooks

Review

Banking

$1.2K

$1.1K

-8.3%

S. Kim

Ready

Taxes

$28.0K

$28.4K

+1.4%

M. Chen

Ready

workbook reviewExcel live

Workspace

May Close Tracker.xlsx

Accounting!A1:F16

Status column

Variance > 10%

DeepSeek V4 Flashvia MCP

Mark rows over 10% variance for review.

I'll inspect the open workbook and update only the Status column.

Called `openworkbook_excel_range_read_values`

Found five matching rows: Software, Travel, Contractor, Training, Security.

Called `openworkbook_excel_range_write_values`

Updated live Excel. Formulas passed and table styling stayed intact.

Ask the agent to inspect, edit, or validate this workbook...Send

workbook-agent

> Update Status for budget variances over 10% and keep Excel open.

I'll inspect the live workbook first, then update only the Accounting table cells that need review.

Explored 1 search

Open-Workbook-Excel

Called `openworkbook_excel_runtime_get_status` probeFileBridge=false

Called `openworkbook_excel_runtime_get_active_context`

Called `openworkbook_excel_workbook_get_workbook_map`

Called `openworkbook_excel_runtime_get_capabilities` includePreview=false

Called `openworkbook_excel_collab_get_status` workbookId=May Close Tracker.xlsx

The workbook has live monthly close data. I found the Accounting table and will read the active range before writing changes.

Called `openworkbook_excel_range_read_values` sheetName=Accounting address=A1:F16

Called `openworkbook_excel_range_write_values` sheetName=Accounting address=F2:F16

Called `openworkbook_excel_workbook_validate` formulas=true styles=true

Updated the workbook in real time: 5 over-threshold rows are marked for review, formulas passed, and Excel stayed open.

> Update the workbook and validate formulas

Excel: connectedmodel: DeepSeek V4 FlashMCP

Use the AI you already trust.

Connect Excel to open models, frontier models, and the workflows your team already uses.