API Reference

OpenOfficeAI lets you create spreadsheets and documents with a single API call. You get back a shareable URL that opens a full editor in the browser. No SDK needed — just HTTP.

Quick Start

Create a spreadsheet in 3 steps:

curl -X POST https://openofficeai.com/api/v1/sheets \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "My First Sheet",
    "sheets": [{
      "rows": [
        ["Name", "Email", "Role"],
        ["Arjav Jain", "arjav@example.com", "Founder"],
        ["Vaibhav Jain", "vaibhav@example.com", "Co-founder"]
      ]
    }]
  }'

{
  "id": "x7k2m9p3",
  "url": "https://openofficeai.com/s/x7k2m9p3",
  "type": "sheet",
  "title": "My First Sheet",
  "edit_token": "tok_...",
  "created_at": "2026-03-24T10:00:00.000Z"
}

Authentication

All write operations (POST, PUT, DELETE) require a Bearer token. GET requests are public and free.

Authorization: Bearer YOUR_API_KEY

Generate API keys from your Dashboard under the API Keys tab.

Creates a new spreadsheet with optional pre-filled data. Returns a shareable URL.

Request Body

Example — Simple rows

curl -X POST https://openofficeai.com/api/v1/sheets \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "Sales Report Q1",
    "sheets": [
      {
        "name": "Revenue",
        "rows": [
          ["Product", "Revenue", "Units Sold"],
          ["Widget A", 50000, 1200],
          ["Widget B", 32000, 800],
          ["Widget C", 78000, 2100]
        ]
      },
      {
        "name": "Costs",
        "rows": [
          ["Category", "Amount"],
          ["Marketing", 12000],
          ["Engineering", 45000]
        ]
      }
    ]
  }'

Response

{
  "id": "x7k2m9p3",
  "type": "sheet",
  "title": "Sales Report Q1",
  "url": "https://openofficeai.com/s/x7k2m9p3",
  "edit_token": "tok_NEwHxoaxrJ1bILIa...",
  "created_at": "2026-03-24T10:00:00.000Z"
}

Use the cells object instead of rows for per-cell control. Keys are cell references like "A1", "B2", etc.

Cell Properties

Example

curl -X POST https://openofficeai.com/api/v1/sheets \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "Budget Calculator",
    "sheets": [{
      "name": "Summary",
      "cells": {
        "A1": { "value": "Category", "bold": true, "bgColor": "#1e1e1e", "fontColor": "#ffffff" },
        "B1": { "value": "Budget", "bold": true, "bgColor": "#1e1e1e", "fontColor": "#ffffff" },
        "C1": { "value": "Actual", "bold": true, "bgColor": "#1e1e1e", "fontColor": "#ffffff" },
        "D1": { "value": "Diff", "bold": true, "bgColor": "#1e1e1e", "fontColor": "#ffffff" },
        "A2": { "value": "Marketing" },
        "B2": { "value": 15000 },
        "C2": { "value": 12300 },
        "D2": { "formula": "=B2-C2" },
        "A3": { "value": "Engineering" },
        "B3": { "value": 50000 },
        "C3": { "value": 48700 },
        "D3": { "formula": "=B3-C3" },
        "A4": { "value": "Total", "bold": true },
        "B4": { "formula": "=SUM(B2:B3)", "bold": true },
        "C4": { "formula": "=SUM(C2:C3)", "bold": true },
        "D4": { "formula": "=B4-C4", "bold": true, "fontColor": "#10b981" }
      }
    }]
  }'

Creates a rich text document with headings, paragraphs, and formatting.

Content Block Properties

Example

curl -X POST https://openofficeai.com/api/v1/docs \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "Project Brief",
    "content": [
      { "type": "heading", "level": 1, "text": "Project Brief: OpenOfficeAI" },
      { "type": "heading", "level": 2, "text": "Overview" },
      { "type": "paragraph", "text": "OpenOfficeAI is an API-first document platform that lets developers and AI agents create spreadsheets and documents programmatically." },
      { "type": "heading", "level": 2, "text": "Goals" },
      { "type": "paragraph", "text": "1. Launch public beta by end of March" },
      { "type": "paragraph", "text": "2. Reach 500 API keys in first month" },
      { "type": "paragraph", "text": "3. Achieve $2k MRR by Q2" },
      { "type": "heading", "level": 2, "text": "Timeline" },
      { "type": "paragraph", "text": "Week 1: API docs + SDK. Week 2: Stripe billing. Week 3: Product Hunt launch." }
    ]
  }'

Retrieve a document by ID. Returns the full data. No authentication required — anyone with the ID can read it.

curl https://openofficeai.com/api/v1/sheets/x7k2m9p3

Replace the document data. Requires authentication. The data field should contain the full Univer snapshot object (the same format returned by GET).

curl -X PUT https://openofficeai.com/api/v1/sheets/x7k2m9p3 \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{ "data": { ... } }'

Permanently delete a document. Requires authentication. This cannot be undone.

curl -X DELETE https://openofficeai.com/api/v1/sheets/x7k2m9p3 \
  -H "Authorization: Bearer YOUR_API_KEY"

Export a document in various formats. No authentication required.

# Download spreadsheet as Excel
curl -O https://openofficeai.com/api/v1/download/x7k2m9p3?format=xlsx

# Download document as PDF
curl -O https://openofficeai.com/api/v1/download/p3n8q2w1?format=pdf

Sharing & Permissions

Rate Limits

API calls are counted per user per month. GET requests are free and unlimited. Usage resets on the 1st of each month.

When you hit the limit, the API returns 429 Too Many Requests. Existing documents remain accessible.

Error Responses

All errors return JSON with an error field.