Agents Index

Basis

OnlineNew

The Excel engine for AI agents: read, check and edit Excel models over MCP.

Visit publisherConnectJSON

What it can do: 26 tools

  • parse_workbook read-onlyParse an .xlsx workbook (or a .csv/.tsv file, read as one sheet) in one call and return its full semantic NDJSON: one JSON record per line (workbook_meta, sheet, cell, edge, image, image_summary, audit), covering every c
  • submit_jobStart an async parse of an .xlsx workbook (or a .csv/.tsv file) and return at once with a job handle {job_id, status: "processing", status_url, stream_url}. Use it instead of parse_workbook for large files or when you do
  • stream_job read-onlyCheck on or read a parse job started by submit_job. By default it returns the job's NDJSON records once it has completed: the same output parse_workbook returns, one JSON record per line. Pass wait_seconds (up to 60) to
  • diff_workbooks read-onlyCompare two .xlsx (or .csv) files cell by cell and return the differences as JSON: {summary, added, removed, changed, format_changed}. Cells are matched on (sheet title, cell ref); changed covers value and formula change
  • evaluate_formula read-onlyEvaluate an Excel formula locally and return the computed result: a quick way to check what a formula returns on a few sample values before you put it in a workbook. Pass data as a map of cell references to values (e.g.
  • create_sessionOpen a workbook in a session that the other workbook tools then use by session_id: the starting point for reading, editing, recalculating and exporting a model. Pass at most one of library_file_id (a file in your Library
  • close_sessionEnd a session and discard its workbook: the session_id stops working and the session can't be reopened. Edits not saved with save_to_library (or downloaded with export_workbook) are lost, and its commit_session checkpoin
  • list_sessions read-onlyList the sessions open for this API key, to recover a session_id you've lost or to see how many are open before create_session. Returns {sessions: [{id, documentId, libraryFileId, createdAt, updatedAt, sheetCount, memByt
  • add_sheetAdd an empty sheet at the end of a session's workbook and make it the active sheet (the one unqualified refs like "B4" point to). Only for sessions created blank (create_session with no file); on an imported workbook it
  • rename_sheetRename a sheet in a session's workbook, found by its 0-based index (see the sheets list from create_session or inspect_model). Formulas, named ranges and validations that reference the sheet are rewritten to the new name
  • delete_sheetDelete a sheet from a session's workbook, found by its 0-based index (see the sheets list from create_session or inspect_model), the way Excel does: formulas on other sheets that referenced it now read #REF! (Gone!A1 bec
  • set_inputsWrite values or formulas into cells of a session and recalculate: the way to run a scenario on a model ("what if Revenue is 1.2M?"). Keys are defined names (e.g. "Revenue") or cell refs ("B4" on the active sheet, "Sheet1
  • set_calc_settingsTurn iterative calculation on or off for a session and recalculate. Needed for circular models (e.g. development pro formas where loan size depends on cost, which includes the loan's interest and fees): with it on, set_i
  • get_outputs read-onlyRead computed values from a session by defined name, cell or range: the way to check what a model's formulas return, e.g. after set_inputs. Pass names as defined names, cell refs ("B4", "Sheet1!B4") or ranges ("Sheet1!H2
  • define_variableCreate a defined name for a cell, or repoint an existing one, so set_inputs and get_outputs can use a readable key ("Revenue") instead of a cell ref. A name that already exists in the same scope is overwritten with the n
  • delete_variableDelete a defined name from a session's workbook, e.g. one you made with define_variable and no longer need. Only the name goes; the cell it pointed to keeps its value and formula. Match is by name, ignoring case, in work
  • inspect_model read-onlySummarize a session's structure: each sheet's index, name and used rows and columns, every defined name with its target, the iterative-calc settings, and counts of cells, memory, edit events and commits. Use it to find y
  • export_workbook read-onlyGet a session's workbook back as an .xlsx file with every formula's computed value saved in it. Recalculates first. Call this when you need the file itself: to give it to the user, or to read it with pandas, openpyxl (da
  • recalc_workbook read-onlyRecalculate an .xlsx file (or a .csv, returned as .xlsx) and return it with the computed values saved in every formula cell. Use this after you create or edit a workbook with openpyxl or any other library that writes for
  • get_formula_range read-onlyRead the formulas and computed values of one cell or a rectangular range in a session: the way to check what a cell or a block of cells computes. Pass a single cell ("B4", "Sheet1!B4") or a range ("A1:D10"). Returns {wor
  • commit_sessionCreate a named checkpoint of the session's current state, e.g. before a risky edit. Returns {commit_id, message, total_commits}; pass commit_id to restore_session to roll back. Every call adds a new checkpoint. Checkpoin
  • restore_sessionRoll a session back to a checkpoint from commit_session: every cell edit made after it is undone, calc settings included, and the workbook is recalculated. Use it to throw away a what-if or a bad edit; it rewinds this se
  • trace_dependencies read-onlyFollow formula references from one cell in a session, breadth first, up to depth levels (1-5): direction "precedents" walks to the cells it reads, "dependents" to the cells that read it, and "both" (the default) does eac
  • audit_workbook read-onlyCheck a session's whole workbook for modeling problems and return a JSON report: broken references, circular references and whether they converge, hardcoded plugs (a constant or odd formula breaking a run of consistent f
  • save_to_librarySave the session's workbook to the user's Library for durable storage. If the session was loaded from the Library or was previously saved, this creates a new version of that file. Otherwise it creates a new Library file.
  • list_library_files read-onlyList the workbooks in the user's Library: the files this account owns, newest-updated first, including everything save_to_library saved. Use it to find a library_file_id to open with create_session, or to check that a sa

Connect it

Claude Code
claude mcp add --transport http basis https://api.basis1.tech/mcp
Claude.ai / ChatGPT
Settings → Connectors → Add custom connector
URL: https://api.basis1.tech/mcp
Cursor (~/.cursor/mcp.json)
{
  "mcpServers": {
    "basis": {
      "url": "https://api.basis1.tech/mcp"
    }
  }
}
VS Code (.vscode/mcp.json)
{
  "servers": {
    "basis": {
      "type": "http",
      "url": "https://api.basis1.tech/mcp"
    }
  }
}

Questions

What does Basis do?

The Excel engine for AI agents: read, check and edit Excel models over MCP. It exposes 26 tools to AI assistants.

What tools does Basis provide?

26 tools, including parse_workbook, submit_job, stream_job, diff_workbooks, evaluate_formula, create_session, close_session, list_sessions, add_sheet, rename_sheet, delete_sheet, set_inputs….

How do I connect Basis to Claude, ChatGPT or Cursor?

Add the remote MCP endpoint https://api.basis1.tech/mcp as a custom connector or MCP server. Copy-paste setup is on this page.

Does Basis require an account or API key?

No sign-in was needed to list its tools. Individual tools may still need an account or API key.

Is Basis online?

As of 2026-11-19 our probe found it online. It answered 100% of our last 3 checks.

Who publishes Basis?

basis1.tech. The official MCP Registry verified that the publisher controls this domain before accepting the listing.

Similar in Productivity & Docs