Excel Export
Generate Excel (.xlsx) files from data arrays. Provide your data and column definitions, get a downloadable spreadsheet back. Supports custom headers, column widths, and formatting.
⚡ Built-in — No Setup Required
This integration is built into the WebsitePublisher platform. All endpoints are available immediately — no API key needed.
Endpoints (1)
POST
generate
Generate an Excel (.xlsx) file from a data array. Returns base64-encoded file content and a suggested filename. Use upload_asset to persist the file, or decode the base64 client-side for direct download.
| Field | Type | Required | Description |
|---|---|---|---|
data |
array | ✓ Yes | Array of data rows. Each row is an object with field names as keys. Example: [{"naam": "Acme BV", "plaats": "Amsterdam", "score": 5}, ...] |
columns |
array | No | Column definitions. Array of objects with: "field" (data key), "header" (display name), "width" (optional, in chars). If omitted, columns are auto-detected from the first data row. Example: [{"field": "naam", "header": "Bedrijfsnaam", "width": 30}, {"field": "plaats", "header": "Plaats", "width": 20}] |
title |
string | No | Worksheet title (shown on the sheet tab). Default: "Export". Max 31 characters. |
filename |
string | No | Suggested filename (without .xlsx extension). Default: "export_{date}". Example: "leadcompass_den_haag_q2". |
freeze_header |
boolean | No | Freeze the header row so it stays visible when scrolling. Default: true. |
auto_filter |
boolean | No | Add auto-filter dropdowns to the header row. Default: true. |
MCP Tool Names
When using this integration through an AI assistant (Claude, ChatGPT, Cursor, etc.), the endpoints are available as MCP tools:
| Endpoint | MCP Tool Name |
|---|---|
| generate | xlsx-export_generate |