CSV Power Editor
Download
Model Context Protocol

Let AI clean the file you can see.

CSV Power Editor ships a loopback MCP server for local agents. The app stays visible while the agent reads headers, previews rows, filters, edits, dedupes, trims, exports, and saves.

CSV Power Editor app window showing a spreadsheet grid, Power Tools sidebar, filters, and MCP status.
MCP appears in the app inspector and status bar while the workbook remains visible.
21 tools

Three safety tiers, clear boundaries.

MCP is available during the 14-day trial or after Lifetime Pro is unlocked. Destructive tools are gated behind an explicit setting.

Tier 1: read-only

Always available when MCP is enabled.

pingcsv.openedFilecsv.listSheetscsv.selectedSheetcsv.headerscsv.previewcsv.rowCountcsv.activeFilterscsv.columnProfilecsv.search

Tier 2: non-destructive UI

Open files, switch sheets, filter, clear filters, and sort.

csv.openFilecsv.selectSheetfilter.addfilter.clearsort.byColumn

Tier 3: destructive gated

Default off. Requires the Allow destructive tools toggle.

csv.editCellcsv.findAndReplacecsv.removeDuplicatescsv.trimcsv.exportVisibleRowscsv.saveWorkbook
Safety

Automation with human visibility.

The MCP server is intentionally local and visible. The user keeps the app open, sees the workbook state, and can undo edits.

Bearer token auth

Every request requires the token shown inside the app.

Loopback only

The server binds to 127.0.0.1 on the local Mac.

Destructive toggle

Edit, replace, dedupe, trim, export, and save are gated.

Audit log

Calls are written to an append-only JSONL log.

Example client config

The app generates the real token snippet locally.

{
  "mcpServers": {
    "csv-power-editor": {
      "url": "http://127.0.0.1:55173/mcp",
      "headers": {
        "Authorization": "Bearer <token-from-app>"
      }
    }
  }
}
Claude Code
Claude Desktop
Codex CLI
Cursor