Sheetize MCP Server
Sheetize MCP Server is a high‑performance service that exposes a comprehensive set of spreadsheet manipulation tools via a clean, fluent API. It lets you work with Excel, CSV, OpenOffice and other common formats, offering operations such as stripping comments, rotating, reversing, searching, parsing, replacing, clearing, charting, repairing, compressing, unlocking, protecting, watermarking, converting, merging and splitting files. The server can be called from any .NET client or from tools that support HTTP/JSON, and it integrates smoothly with AI‑assisted coding assistants like GitHub Copilot (Visual Studio Community 2026, Visual Studio Code), ChatGPT Desktop and Claude Desktop.
Key Capabilities
Massive Spreadsheet Toolkit
- Remove comments – strip all comment objects from a workbook.
- Rotate / Reverse – rotate sheets, flip rows/columns, reverse data order.
- Search & Parse – locate cells, extract patterns, parse embedded data.
- Replace & Clear – bulk replace values or clear ranges.
- Chart – generate or modify charts programmatically.
- Repair & Compress – fix corrupted files and reduce file size.
- Unlock / Protect – toggle worksheet and workbook protection.
- Watermark – embed visual watermarks.
- Conversion – convert between XLSX, CSV, ODS, etc.
- Merge & Split – combine multiple workbooks or split one into many.
AI‑Powered Assistance
- Generate natural‑language prompts to drive the server.
- Receive instant summaries and insights.
- Ask questions about a spreadsheet in plain English and get precise answers.
Getting Started
Prerequisites
- .NET 6+ runtime.
- Access token for your Sheetize MCP Server instance.
- Optional: one of the supported AI assistants (GitHub Copilot, ChatGPT Desktop, Claude Desktop).
Sample: Removing Comments from an Excel File
Remove comments of the file path\to\file.xlsxSample: Removing Comments from the Excel Files
Remove comments of the files in path\to\folderSample: Convert multiple files to PDF
Convert the files in path\to\folder to PDFSample: Convert multiple files to PDF and export to an output folder
Convert the files in path\to\folder to PDF and save them to path\to\folderSample: Rotate a Worksheet
Rotate 270 degree the file path\to\file.xlsxIntegration with AI Coding Assistants
| Assistant | Supported IDE / App | Typical Use |
|---|---|---|
| GitHub Copilot | Visual Studio Community 2026 | Autogenerate client calls, suggest parameters |
| GitHub Copilot | Visual Studio Code | Inline snippets for MCP operations |
| ChatGPT Desktop | Stand‑alone app | Generate prompts, explore API docs |
| Claude Desktop | Stand‑alone app | Draft complex transformation pipelines |
Simply type a comment such as Use Sheetize MCP to split this workbook path\to\file.xlsx and Copilot will offer the appropriate method call.