Basis
OnlineNewThe Excel engine for AI agents: read, check and edit Excel models over MCP.
What it can do: 26 tools
parse_workbookread-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 csubmit_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 dostream_jobread-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) todiff_workbooksread-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 changeevaluate_formularead-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 Libraryclose_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 checkpoinlist_sessionsread-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, memBytadd_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 itrename_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 namedelete_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 becset_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, "Sheet1set_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_iget_outputsread-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!H2define_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 ndelete_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 workinspect_modelread-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 yexport_workbookread-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 (darecalc_workbookread-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 forget_formula_rangeread-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 {worcommit_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. Checkpoinrestore_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 setrace_dependenciesread-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 eacaudit_workbookread-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 fsave_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_filesread-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 mcp add --transport http basis https://api.basis1.tech/mcpSettings → Connectors → Add custom connector
URL: https://api.basis1.tech/mcp{
"mcpServers": {
"basis": {
"url": "https://api.basis1.tech/mcp"
}
}
}{
"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
-
Microsoft Learn MCPOnlineOfficialPopular
Official Microsoft Learn MCP Server – real-time, trusted docs & code samples for AI and LLMs.
-
Microsoft Sentinel Data ExplorationOnline · sign-in requiredOfficialPopular
Find relevant security data from Sentinel data lake for building effective agents. More:aka.ms/s/de
-
NVIDIA CUDA DocsOnline · sign-in requiredOfficialPopular
Search NVIDIA CUDA documentation and code samples from AI coding agents.
-
Atlassian Rovo MCP ServerOnline · sign-in requiredOfficialPopular
Connect to Atlassian Jira, Confluence, Loom, and more to search, create, and manage your work.
-
SiemensOnlineOfficialPopularNew
Search public Siemens web content, products, references, contacts, documents, podcasts and media.
-
Claude Platform DocsOnlineOfficialPopular
Search and read the Claude Platform documentation and API reference.