spreadsheet-builder

Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.

사용해야 할까요

품질 및 안전성

A
설명 품질
100%
스키마 완전성
86%
이름 품질
80%
오염 위험
100%
권한 일치
100%
프로토콜 준수
100%

도구 정의와 프로토콜 준수에 대한 자동 분석을 기반으로 합니다.

컨텍스트 비용

~3,058토큰 (도구 정의)
~1.7 KB일반적인 응답 크기
상당한 주의 영향 (128k 컨텍스트의 2.39%)

이는 서버의 도구가 모델의 컨텍스트에 로드될 때마다 소비되는 대략적인 토큰 수입니다. 수치가 높을수록 다른 작업에 사용할 수 있는 주의가 줄어듭니다.

설치

원클릭 설치

`claude_desktop_config.json` 파일에 다음을 추가하세요:

{
  "mcpServers": {
    "spreadsheet-builder": {
      "command": "uvx",
      "args": [
        "https://github.com/theluckystrike/mcp-servers/releases/download/v0.21.0/spreadsheet.mcpb"
      ]
    }
  }
}

실행 가능한 패키지

mcpbhttps://github.com/theluckystrike/mcp-servers/releases/download/v0.21.0/spreadsheet.mcpb0.21.0stdio

원격 엔드포인트

https://mcp.zovo.one/mcp/spreadsheet-builderstreamable-http

할 수 있는 일

도구 목록

도구 (13)

🟢 읽기 전용🟡 쓰기🔴 삭제⚪ 알 수 없음
🟢license_status

Report this endpoint's licence state for your token as JSON: the product, the tier free or pro, why it is not Pro, and the checkout URL. Call it to explain a free-tier refusal. No arguments, nothing changes.

입력 스키마

{
  "type": "object",
  "properties": {},
  "$schema": "http://json-schema.org/draft-07/schema#"
}
⚪license_activate(key)

Turn Pro on for this connection with key, an MCPL1.<payload>.<signature> issued at checkout for this server or the bundle. Data under your token stays; a wrong or expired key changes nothing. license_status confirms it.

입력 스키마

{
  "type": "object",
  "properties": {
    "key": {
      "type": "string",
      "description": "License key from checkout, MCPL1.<payload>.<signature>"
    }
  },
  "required": [
    "key"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🔴sheet_load(name, csv, xlsx_base64, url)

Upload data to work on. This hosted endpoint has no filesystem, so instead of a file path you send the data once with sheet_load and then pass its name as `path` to sheet_info, sheet_read, sheet_query, sheet_stats, sheet_find, sheet_add_column, sheet_convert and sheet_write. Give exactly one of csv (raw text, comma or tab separated), xlsx_base64 (a base64-encoded .xlsx workbook) or url. url: fetch a public file instead of pasting base64 (recommended above about 10 KB): the url is fetched here with a 10 second timeout, at most 3 redirects, public http(s) hosts only, and a 2 MB cap, and a fetched file is stored as an .xlsx when it carries the PK zip header and as delimited text otherwise. Loaded sheets are kept for your token and survive between calls; the total is capped at 2 MB per token. Files the other tools write come back as a download link that is valid for one hour.

입력 스키마

{
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 70,
      "description": "Name to refer to this data by: 1-64 characters of letters, digits, underscore or dash, e.g. \"sales\" or \"sales.csv\""
    },
    "csv": {
      "type": "string",
      "description": "Raw CSV or TSV text, including the header row"
    },
    "xlsx_base64": {
      "type": "string",
      "description": "Base64-encoded .xlsx workbook"
    },
    "url": {
      "type": "string",
      "description": "url: fetch a public file instead of pasting base64 (recommended above about 10 KB). Public http(s) only; private, link-local and this endpoint's own zone are refused"
    }
  },
  "required": [
    "name"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_files

List the sheets loaded for this token, with their sizes and the storage left under the 2 MB cap.

입력 스키마

{
  "type": "object",
  "properties": {},
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🔴sheet_unload(name)

Delete one sheet loaded for this token, freeing its space under the 2 MB cap.

입력 스키마

{
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 70
    }
  },
  "required": [
    "name"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_info(path)

Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Start here: sheet names, size, header row, column types and samples.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)"
    }
  },
  "required": [
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_read(path, sheet, range, limit, offset, ...)

Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Reads rows as a table, JSON or CSV; page with limit/offset or an A1 range.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string"
    },
    "sheet": {
      "type": "string",
      "description": "Sheet name; defaults to the first sheet"
    },
    "range": {
      "type": "string",
      "description": "A1 range such as A1:D50; overrides limit/offset"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 100000,
      "description": "Rows to return, default 100"
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Rows to skip, default 0"
    },
    "as": {
      "type": "string",
      "enum": [
        "table",
        "json",
        "csv"
      ],
      "description": "Output format, default table"
    }
  },
  "required": [
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_query(path, sheet, where, select, group_by, ...)

Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Filter, group, aggregate and sort in one call; never hand sums over sheet_read rows.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Path to the .xlsx or .csv file"
    },
    "sheet": {
      "type": "string"
    },
    "where": {
      "type": "string",
      "description": "Filter, e.g. [Qty] >= 5 AND ([Status] = \"open\" OR [Status] = \"new\")"
    },
    "select": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Column names to return; default all (with group_by, defaults to the group columns plus the aggregates)"
    },
    "group_by": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Group rows by these columns before aggregating, e.g. [\"Rep\"] or [\"Region\",\"Rep\"]"
    },
    "aggregate": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "col": {
            "type": "string",
            "description": "Column to aggregate, or \"*\" to count rows"
          },
          "fn": {
            "type": "string",
            "enum": [
              "sum",
              "count",
              "avg",
              "min",
              "max"
            ],
            "description": "sum | count | avg | min | max"
          },
          "as": {
            "type": "string",
            "description": "Output name for this aggregate, e.g. total_units"
          }
        },
        "required": [
          "col",
          "fn"
        ],
        "additionalProperties": false
      },
      "description": "Aggregates per group, e.g. [{\"col\":\"Units\",\"fn\":\"sum\",\"as\":\"total_units\"}]. Defaults to a row count when group_by is given."
    },
    "sort": {
      "type": "object",
      "properties": {
        "col": {
          "type": "string"
        },
        "dir": {
          "type": "string",
          "enum": [
            "asc",
            "desc"
          ]
        }
      },
      "required": [
        "col"
      ],
      "additionalProperties": false,
      "description": "Sort column; may be an aggregate alias such as total_units"
    },
    "limit": {
      "type": "integer",
      "minimum": 1,
      "maximum": 100000,
      "description": "Default 100"
    },
    "as": {
      "type": "string",
      "enum": [
        "table",
        "json",
        "csv"
      ]
    }
  },
  "required": [
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_stats(path, sheet, columns)

Call this tool for any spreadsheet or CSV file path; built-in file readers cannot parse spreadsheets and must not be used for them. Whole-column statistics: count, empty, distinct, min, max, sum, mean, median.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string"
    },
    "sheet": {
      "type": "string"
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "Limit to these columns; default all"
    }
  },
  "required": [
    "path"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟢sheet_find(path, text, sheet)

Call this tool to search every cell of a spreadsheet or CSV for text; built-in file readers cannot parse spreadsheets. Matching is case insensitive. Returns cell addresses with a preview of the row each hit is on.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Path to the .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded)"
    },
    "text": {
      "type": "string",
      "description": "Text to look for; matched case insensitively anywhere inside a cell. Up to 200 hits are returned"
    },
    "sheet": {
      "type": "string",
      "description": "Sheet name; default searches every sheet"
    }
  },
  "required": [
    "path",
    "text"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟡sheet_write(path, sheet, rows, mode, out_path)

Call this tool to write rows to an xlsx, csv, tsv or json file; the extension of out_path picks the format. mode is new_file, append or overwrite. Other sheets are kept. Free: 500 rows per file.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Source file for append/overwrite, or the intended file for new_file (~ is expanded)"
    },
    "sheet": {
      "type": "string",
      "description": "Sheet to write; default is the first sheet of the source, or \"Sheet1\" for a new file. Other sheets of an existing workbook are kept unchanged"
    },
    "rows": {
      "type": "array",
      "items": {
        "anyOf": [
          {
            "type": "object",
            "additionalProperties": {}
          },
          {
            "type": "array"
          }
        ]
      },
      "description": "Array of objects, whose keys become the headers, or an array of arrays with the header row first"
    },
    "mode": {
      "type": "string",
      "enum": [
        "new_file",
        "append",
        "overwrite"
      ],
      "description": "new_file writes a brand new file and refuses to clobber an existing one; append adds the rows under the existing data; overwrite replaces the file contents"
    },
    "out_path": {
      "type": "string",
      "description": "Where to write; default is a new file next to the source for new_file, or the source itself for append/overwrite. The output format follows this extension: .xlsx, .csv, .tsv or .json. An extension is required"
    }
  },
  "required": [
    "path",
    "rows",
    "mode"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
🟡sheet_add_column(path, sheet, name, formula, decimals, ...)

Call this tool to add a computed column and save the result to a NEW file; the source is never modified unless out_path points at it. Returns the new file path, the row count and a preview of the first rows.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified"
    },
    "sheet": {
      "type": "string",
      "description": "Sheet name; default is the first sheet"
    },
    "name": {
      "type": "string",
      "description": "Name of the new column. It must not already exist on the sheet"
    },
    "formula": {
      "type": "string",
      "description": "Expression over the columns of each row, in the same expression language as sheet_query, e.g. \"[Qty] * [Unit Price]\" or '[Country] = \"PL\"'. Give either formula or values"
    },
    "decimals": {
      "type": "integer",
      "minimum": 0,
      "maximum": 10,
      "description": "Round numeric formula results to this many decimals. Default: the widest decimal count of the columns the formula reads, capped at 2 when they all hold 2 or fewer (money in, money out); otherwise no rounding beyond float cleanup"
    },
    "values": {
      "type": "array",
      "description": "Explicit values, one per data row, instead of a formula. Missing entries are left blank"
    },
    "out_path": {
      "type": "string",
      "description": "Output file; default <source>-plus-<column>.<same ext>. The source file is left untouched unless this points at it"
    }
  },
  "required": [
    "path",
    "name"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}
⚪sheet_convert(path, to, sheet, out_path)

Call this tool to convert a sheet between excel (xlsx), csv and json. Writes a new file next to the source unless out_path is given; the source is never modified. Returns the new file path with its row and column counts.

입력 스키마

{
  "type": "object",
  "properties": {
    "path": {
      "type": "string",
      "description": "Path to the source .xlsx/.xlsm/.xlsb/.ods/.csv/.tsv file (~ is expanded); it is never modified"
    },
    "to": {
      "type": "string",
      "enum": [
        "csv",
        "xlsx",
        "json"
      ],
      "description": "Target format; the default out_path takes this as its extension"
    },
    "sheet": {
      "type": "string",
      "description": "Sheet to convert; default is the first sheet. Only that one sheet is written"
    },
    "out_path": {
      "type": "string",
      "description": "Where to write; default is the source name with the new extension, next to the source. It must differ from the source path"
    }
  },
  "required": [
    "path",
    "to"
  ],
  "additionalProperties": false,
  "$schema": "http://json-schema.org/draft-07/schema#"
}

커뮤니티

이 서버 평가하기

증거

최근 관측

검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개
검증됨버전이 기록되지 않음도구 13개