Spreadsheet Generator API

About this tool

Generate professional Excel (XLSX) or CSV files via a simple JSON API. Define multiple sheets, set column headers with automatic bold formatting and colored headers, and provide row data. The API generates the file, stores it temporarily, and returns a direct download URL. Files expire after 1 hour. Powered by ExcelJS for full XLSX support.

🧪 Try it live

API Key

Format

Filename

Quick Start

curl -X POST https://api.iteratools.com/spreadsheet/generate \
  -H "Authorization: Bearer YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "format": "xlsx",
    "filename": "sales-report",
    "sheets": [{
      "name": "Q1 Sales",
      "headers": ["Product", "Units", "Revenue"],
      "rows": [
        ["Widget A", 150, 1499.50],
        ["Widget B", 80, 3199.20],
        ["Widget C", 320, 639.80]
      ]
    }]
  }'

Response

{
  "success": true,
  "url": "https://api.iteratools.com/files/sales-report-1234567890.xlsx",
  "filename": "sales-report-1234567890.xlsx",
  "format": "xlsx",
  "size_bytes": 6616,
  "rows_count": 3,
  "sheets_count": 1,
  "expires_in": "1 hour"
}

Multiple Sheets (XLSX only)

{
  "format": "xlsx",
  "filename": "annual-report",
  "sheets": [
    {
      "name": "Q1",
      "headers": ["Month", "Revenue"],
      "rows": [["January", 5000], ["February", 6200]]
    },
    {
      "name": "Q2",
      "headers": ["Month", "Revenue"],
      "rows": [["April", 7100], ["May", 8300]]
    }
  ]
}

Details

Endpoint	POST /spreadsheet/generate
Price	$0.003 / file
Formats	xlsx, csv
File expiry	1 hour
Provider	ExcelJS (server-side)
Auth	Bearer token or x402 micropayment
Base URL	https://api.iteratools.com