Excel

Create and edit Excel workbooks, read and update worksheets, cells, and ranges, search workbooks, scan for data issues, and manage comments.

От сообществаРаботаетБез входаГлобальныйБесплатноМожет изменять данные

Что умеет

  • Arcade ListApps: See the apps the current caller can act on and whether they are connected. Returns each app's id, name, connected state, and (when connected) the account it is connected as. Call this
  • MicrosoftExcel AddWorksheet: Add a new worksheet to the workbook. Note: The new worksheet name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). P
  • MicrosoftExcel AggregateWorksheet: Summarize a worksheet by grouping rows and computing per-group aggregates in one call. Use this instead of reading and paginating raw rows when you need totals, aver

Какие данные видит

Нужен ли аккаунт

Не нужен: сервер работает без входа

Create and edit Excel workbooks, read and update worksheets, cells, and ranges, search workbooks, scan for data issues, and manage comments.

Как подключить

Как подключить Excel к Claude

Адрес сервера, который нужно вставить в настройках Claude:

https://excel.run.tools

  1. Откройте Claude (сайт claude.ai или приложение для компьютера).
  2. Перейдите в Настройки → Коннекторы (в английском интерфейсе: Settings → Connectors).
  3. Нажмите Добавить пользовательский коннектор (Add custom connector).
  4. Вставьте адрес сервера, скопированный ниже, в поле URL удалённого MCP-сервера и нажмите Добавить.
  5. В чате нажмите + → Коннекторы и включите новый коннектор.

Пользовательские коннекторы доступны на тарифах Free, Pro, Max, Team и Enterprise. На Free можно добавить только один. В Team и Enterprise коннектор сначала добавляет владелец организации в Настройки организации → Коннекторы.

Авторизация

После нажатия Добавить откроется окно входа в сервис. Войдите под своим аккаунтом и подтвердите доступ. Пароль Claude не видит.

Как подключить Excel к ChatGPT

Адрес сервера, который нужно вставить в настройках ChatGPT:

https://excel.run.tools

  1. Откройте ChatGPT в браузере (chatgpt.com). Нужен тариф Plus, Pro, Business, Enterprise или Edu.
  2. Один раз включите режим разработчика: Настройки → Приложения → Дополнительные настройки → Режим разработчика (Settings → Apps → Advanced settings → Developer mode).
  3. Откройте Настройки → Коннекторы и нажмите Создать (Create).
  4. Заполните форму: Название (любое), Описание (одна фраза, что делает сервис), URL MCP-сервера (скопируйте ниже).
  5. В поле Аутентификация выберите OAuth, если сервис требует вход, иначе Нет. Нажмите Создать.
  6. В новом чате откройте + → Приложения/Коннекторы и включите коннектор.

Название раздела у OpenAI менялось (Connectors → Apps/Plugins). Если пункт называется иначе, ищите «режим разработчика» в настройках. В рабочих пространствах Business/Enterprise администратор должен разрешить пользовательские коннекторы.

Авторизация

При первом использовании ChatGPT откроет окно входа в сервис. Войдите и подтвердите доступ.

Как подключить Excel к Cursor

Адрес сервера, который нужно вставить в настройках Cursor:

https://excel.run.tools

Быстрый способ: нажмите кнопку Открыть в Cursor ниже, Cursor сам предложит добавить сервер.

Вручную:

  1. В Cursor откройте Settings → Cursor Settings → MCP и нажмите Add new global MCP server.
  2. Вставьте JSON, скопированный ниже, в открывшийся файл ~/.cursor/mcp.json (для одного проекта: .cursor/mcp.json в корне проекта).
  3. Сохраните файл. Сервер появится в списке MCP; при необходимости пройдите авторизацию по кнопке рядом с ним.

Авторизация

Если сервис требует вход, рядом с сервером в списке MCP появится кнопка авторизации.

Список инструментов сервера (18)

Технические названия из tools/list. Нужны только разработчикам.

Arcade_ListAppsSee the apps the current caller can act on and whether they are connected. Returns each app's id, name, connected state, and (when connected) the account it is connected as. Call this to answer "what apps do I have?" or when the caller's connection state may have changed since the session started.
MicrosoftExcel_AddWorksheetAdd a new worksheet to the workbook. Note: The new worksheet name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). Pass the returned ``session_id`` to subsequent calls that reference the new worksheet to mitigate this.
MicrosoftExcel_AggregateWorksheetSummarize a worksheet by grouping rows and computing per-group aggregates in one call. Use this instead of reading and paginating raw rows when you need totals, averages, counts, or min/max broken down by one or more columns (e.g. revenue by region). Columns can be referenced by letter (group_by) or by header name (group_by_headers) — use whichever is more convenient. Groups are returned in first-seen order and capped by ``limit``. Always check each aggregate's ``numeric_count`` field: non-numeric and formula-error cells are silently skipped for sum/average/min/max, so a clean-looking total may exclude rows — the ``warnings`` list will name every column and group where this occurred.
MicrosoftExcel_CreateOrEditWorkbookCreate a new .xlsx workbook or edit an existing one in OneDrive for Business. Omit `item_id` to create (an empty workbook is created from `filename`, then the operations are applied); provide `item_id` to edit. To create a populated workbook, pass `filename` plus set_values operations; name the target tab via `worksheet` (or reference one consistent sheet name in the operations) and the new workbook's initial sheet is renamed to match. By default, when creating a workbook for a person to read, build a clean, professional-looking table rather than a bare value dump: preserve typed numbers and dates, apply appropriate number formats, turn tabular data into a native Excel table (add_table), and ALWAYS resize columns (format_columns with autofit=true over every used column — agents usually omit this and labels get truncated). If autofit still clips a long label, set an explicit column_width. Keep sheet names and headers plain text (no emojis). Only skip the polish when the user asks for raw data or a specific style. Each entry in `operations` selects a behavior via its `type`: write/clear cells, format cells (font, fill, borders, alignment, wrap, row height), size rows and columns, sort, add/restyle tables (style, totals, banding, filter), add/move/restyle charts (anchor cell, size, title, legend, axis titles), manage worksheets and named ranges, protect a sheet, and recalculate. See the `operations` parameter for per-type fields and examples. For a workbook you already have as a complete .xlsx file, upload its bytes rather than rebuilding it cell-by-cell.
MicrosoftExcel_CreateWorkbookCreate a new Excel workbook (.xlsx) in OneDrive for Business. Only .xlsx files are supported. OneDrive Consumer (personal accounts) is NOT supported.
MicrosoftExcel_DeleteWorksheetDelete a worksheet from the workbook. Cannot delete the last worksheet in a workbook. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
MicrosoftExcel_GetWorkbookMetadataGet a workbook's structure: worksheets, named ranges, and optionally extents and objects. Call this first when exploring an unfamiliar workbook: it surfaces hidden worksheets and workbook-scoped named ranges. Use `include_used_ranges` to also learn where data lives (used ranges, protection state, and worksheet-local named ranges) before reading, and `include_objects` to enumerate tables and charts. Both add a per-worksheet fan-out, so leave them off for a quick worksheet listing.
MicrosoftExcel_GetWorksheetDataRead cell values from a worksheet. Returns data in sparse dict format where data[ROW][COL] has userEnteredValue and formattedValue for each non-empty cell. Includes pagination hints if more data exists beyond the requested range. Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
MicrosoftExcel_ListWorkbookCommentsList a workbook's comments, or the replies on a specific comment thread. Provide a comment ID to retrieve that thread's replies instead of the top-level comments.
MicrosoftExcel_ReadWorksheetRead a worksheet range with the detail you choose, with guardrails for large sheets. Request `annotations` for formulas, cell types, number formats, or the range's fill/font/borders; `filter_column` + `filter_contains` to keep matching rows; `columns` to project a subset; `export` for csv/tsv. Reads are bounded to the used range and capped by a row limit and cell budget, paginating via `next_range` rather than returning a whole large sheet at once. Set `row_format="records"` (with `has_header=true`) to get a `record` dict on each data row, keying cell values by the header row (the top row of the worksheet's used range) — useful when agents need to map values to named columns without tracking positional indices. The header is carried across pages, so paginated reads via `next_range` stay correctly keyed. Each row still includes `values`. To verify formulas, types, or number patterns in the returned cells, pass `annotations` (e.g. `["formulas", "types"]`); annotation values land under `annotations` keyed by A1 address alongside the displayed values.
MicrosoftExcel_RenameWorksheetRename an existing worksheet in the workbook. Note: The new name may not be immediately visible to other tools due to a brief Graph API propagation delay (up to ~10 s). Pass the returned ``session_id`` to subsequent calls that reference the renamed worksheet to mitigate this. If referencing a recently added worksheet as the source, the same delay applies; retry with the ``session_id`` if a WorksheetNotFoundError occurs.
MicrosoftExcel_ReplyToWorkbookCommentPost a plain-text reply to an existing comment thread on a workbook. The reply is appended to the end of the thread.
MicrosoftExcel_ScanForDataIssuesScan a worksheet (or the whole workbook) for data-quality problems as a structured list. Each issue carries a ``severity`` field (``"high"``, ``"medium"``, or ``"low"``) and the list is ordered high → low before any truncation cap is applied, so critical findings are never dropped in favour of lower-priority ones. By default the scan is sheet-scoped (the named worksheet, or the first sheet when ``worksheet`` is omitted). Pass ``worksheet='*'`` for a workbook-wide audit: every sheet is scanned in one call and each issue carries its own ``worksheet`` field. Detects formula-error cells (``severity="high"``), type outliers within a column — a column mostly one type with a few cells of another — (``severity="medium"``), inconsistent_column for a column that mixes cell types without a strong majority (``severity="medium"``), accidental duplicate values in mostly-unique columns (``severity="medium"``), and blank cells inside an otherwise-populated region (``severity="low"``). Categorical columns (where repetition is expected) are not flagged as duplicates, and the header row is excluded from type-outlier and duplicate checks. A clean sheet returns an empty issues list. Detection is deterministic. Results are capped; when the cap is reached ``truncated`` is True and a warning is added. Merged cells are a known limitation: Microsoft Graph reports only the merge anchor as populated and every covered cell as empty, so cells hidden under a merge may be flagged as blanks. A worksheet cannot be scanned when its used range exceeds an internal cell limit (this tool takes no range argument): a single-sheet scan raises an error asking you to reduce the data, while a whole-workbook scan skips the oversized sheet and names it in a warning so the rest of the workbook is still scanned.
MicrosoftExcel_SearchWorkbooksFind Excel workbooks in OneDrive by keyword or folder, returning their item_ids. Provide `query` to search the whole drive by name/content, or leave it empty and pass `parent_folder_id` to list one folder; only .xlsx files are returned. Use a returned `item_id` to read, edit, scan, or comment on a workbook you did not create this session.
MicrosoftExcel_UpdateCellUpdate a single cell value in an Excel workbook. Supports strings, numbers, booleans, and formulas (values starting with '='). Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
MicrosoftExcel_UpdateRangeUpdate multiple cells in a worksheet using sparse dict format. Only specified cells are updated; unspecified cells remain unchanged. The data format is the same as Google Sheets update_cells. Internally, a single PATCH request is sent covering the bounding box of all specified cells. Cells within the box that are not in the input are sent as ``null``, which the Graph API treats as "skip". Note: If referencing a recently added or renamed worksheet, pass the ``session_id`` from that operation. A brief Graph API propagation delay (up to ~10 s) may cause a WorksheetNotFoundError; retry with the ``session_id`` if this occurs.
MicrosoftExcel_UploadWorkbookUpload a complete .xlsx file into OneDrive for Business, preserving it byte-for-byte. Use this to store a workbook you already have as a complete file — one the user provided, or one produced elsewhere with formatting, formulas, and charts intact. To build and format a workbook from data, apply formatting operations when creating it rather than uploading bytes. Large files are uploaded via a resumable upload session automatically.
MicrosoftExcel_WhoAmIGet information about the current user and their Microsoft Excel environment.