REBYTE.AI

spreadsheet-builder

Build and edit online spreadsheets using Univer. Use when user wants to create data tables, trackers, or reports that can be shared via link. Triggers include "build spreadsheet", "create spreadsheet", "spreadsheet for", "expense tracker", "budget spreadsheet", "data table", "financial model", "tracking spreadsheet". Do NOT use for Excel file manipulation (use xlsx skill instead).

Published by rebyteai

Run in Cloud Browse All Skills

Cloud-native skill

Runs in the cloud

No local installation

Dependencies pre-installed

Ready to run instantly

Secure VM environment

Isolated per task

Works on any device

Desktop, tablet, or phone

Documentation

Spreadsheet Builder

Build and edit professional online spreadsheets using Univer. Better than Excel for sharing - recipients can view instantly via link without installing Office.

For Non-Technical Users

IMPORTANT: This skill is designed for non-technical users.

  • DO NOT explain commands or show bash/terminal syntax to the user
  • DO NOT ask the user to run commands themselves
  • DO NOT give technical instructions like "run this command"
  • JUST EXECUTE and show results directly
  • Keep responses focused on outcomes, not technical steps

Common Mistakes to Avoid

  • Showing dev server output: Never show "localhost:3000" or similar - the user can't access it and doesn't care
  • Running npm run dev: Don't start dev servers and show the output. Export/build instead.
  • Explaining installation steps: Just install dependencies silently
  • Showing terminal output: Unless it's an error you need to debug, hide it
  • Asking "should I run X?": Just run it

Authentication

IMPORTANT: All API requests require authentication. Get your auth token and API URL by running:

AUTH_TOKEN=$(/home/user/.local/bin/rebyte-auth)
API_URL=$(python3 -c "import json; print(json.load(open('/home/user/.rebyte.ai/auth.json'))['sandbox']['relay_url'])")

Include the token in all API requests as a Bearer token, and use $API_URL as the base for all API endpoints.

Artifact Store

If this skill produces output files (PDFs, images, exports, etc.), you MUST upload them to the artifact store. Without this, users cannot access the files - they only exist inside the VM.

Upload whenever you generate:

  • Exported documents (PDF, Word, Excel, PowerPoint)
  • Images (screenshots, generated graphics, charts)
  • Media files (videos, audio)
  • Any file the user asked to "download" or "export"
curl -X PUT "$API_URL/api/artifacts" \
  -H "Authorization: Bearer $AUTH_TOKEN" \
  -F "files=@/path/to/file.pdf"

Multiple files:

curl -X PUT "$API_URL/api/artifacts" \
  -H "Authorization: Bearer $AUTH_TOKEN" \
  -F "files=@file1.png" \
  -F "files=@file2.png"

Allowed file types:

  • Documents: .pdf, .doc(x), .xls(x), .ppt(x), .csv, .tsv, .rtf, .epub, .html
  • Archives: .zip, .tar, .gz, .tgz
  • Images: .png, .jpg, .gif, .webp, .svg, .tiff, .bmp, .avif
  • Videos: .mp4, .webm, .mov, .avi, .mkv
  • Audio: .mp3, .wav, .ogg, .aac, .flac, .m4a

Not allowed: Source code, config files, or development files.

API Endpoints

Create Spreadsheet

curl -X POST "$API_URL/api/data/spreadsheet/create" \
  -H "Authorization: Bearer $AUTH_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "title": "My Spreadsheet",
    "commands": [...]
  }'

Response:

{
  "success": true,
  "docId": "ss-Kj2mN8xQ1pRt3Y5z",
  "workspaceId": "54a8f3c3-5e94-4296-85d4-6fceee344922",
  "title": "My Spreadsheet",
  "commandCount": 15,
  "url": "https://.../workspace/54a8f3c3-5e94-4296-85d4-6fceee344922/spreadsheets/ss-Kj2mN8xQ1pRt3Y5z"
}

Get Spreadsheet

Retrieve an existing spreadsheet by its docId. Returns metadata and all commands.

curl -X POST "$API_URL/api/data/spreadsheet/get" \
  -H "Authorization: Bearer $AUTH_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "docId": "ss-Kj2mN8xQ1pRt3Y5z"
  }'

Response:

{
  "success": true,
  "docId": "ss-Kj2mN8xQ1pRt3Y5z",
  "workspaceId": "54a8f3c3-5e94-4296-85d4-6fceee344922",
  "title": "My Spreadsheet",
  "createdAt": "2024-01-15T10:30:00Z",
  "updatedAt": "2024-01-15T14:20:00Z",
  "commandCount": 15,
  "commands": [...],
  "url": "https://.../workspace/54a8f3c3-5e94-4296-85d4-6fceee344922/spreadsheets/ss-Kj2mN8xQ1pRt3Y5z"
}

Append to Spreadsheet

Add more commands to an existing spreadsheet. Use this to update data, add rows, or modify cells.

curl -X POST "$API_URL/api/data/spreadsheet/append" \
  -H "Authorization: Bearer $AUTH_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "docId": "ss-Kj2mN8xQ1pRt3Y5z",
    "commands": [...]
  }'

Response:

{
  "success": true,
  "docId": "ss-Kj2mN8xQ1pRt3Y5z",
  "workspaceId": "54a8f3c3-5e94-4296-85d4-6fceee344922",
  "commandsAppended": 5,
  "startSeq": 16,
  "endSeq": 20,
  "url": "https://.../workspace/54a8f3c3-5e94-4296-85d4-6fceee344922/spreadsheets/ss-Kj2mN8xQ1pRt3Y5z"
}

Command Format

Each command has this structure:

{
  "id": "sheet.mutation.set-range-values",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "range": { "startRow": 0, "endRow": 0, "startColumn": 0, "endColumn": 2 },
    "value": [[{ "v": "Cell A1" }, { "v": "Cell B1" }, { "v": "Cell C1" }]]
  }
}

Notes:

  • ts is optional (auto-generated if missing)
  • unitId should be "workbook-1"
  • subUnitId should be "sheet-1" (or "sheet-2" for additional sheets)

Command Types

1. Set Cell Values (sheet.mutation.set-range-values)

The main command for setting cell data.

Single cell:

{
  "id": "sheet.mutation.set-range-values",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "range": { "startRow": 0, "endRow": 0, "startColumn": 0, "endColumn": 0 },
    "value": [[{ "v": "Hello World" }]]
  }
}

Row of data:

{
  "id": "sheet.mutation.set-range-values",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "range": { "startRow": 0, "endRow": 0, "startColumn": 0, "endColumn": 3 },
    "value": [[
      { "v": "Name", "s": "header" },
      { "v": "Age", "s": "header" },
      { "v": "City", "s": "header" },
      { "v": "Salary", "s": "header" }
    ]]
  }
}

Multiple rows:

{
  "id": "sheet.mutation.set-range-values",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "range": { "startRow": 1, "endRow": 3, "startColumn": 0, "endColumn": 3 },
    "value": [
      [{ "v": "Alice" }, { "v": 28 }, { "v": "NYC" }, { "v": 85000 }],
      [{ "v": "Bob" }, { "v": 34 }, { "v": "LA" }, { "v": 92000 }],
      [{ "v": "Carol" }, { "v": 31 }, { "v": "Chicago" }, { "v": 78000 }]
    ]
  }
}

2. Cell Value Types

Text:

{ "v": "Hello" }

Number:

{ "v": 1234.56 }

Formula:

{ "v": "", "f": "=SUM(B2:B10)" }

With style reference:

{ "v": "Total", "s": "header" }

3. Set Column Width (sheet.mutation.set-worksheet-col-width)

{
  "id": "sheet.mutation.set-worksheet-col-width",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "colIndex": 0,
    "width": 150
  }
}

4. Set Row Height (sheet.mutation.set-worksheet-row-height)

{
  "id": "sheet.mutation.set-worksheet-row-height",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "rowIndex": 0,
    "height": 30
  }
}

5. Set Sheet Name (sheet.mutation.set-worksheet-name)

{
  "id": "sheet.mutation.set-worksheet-name",
  "params": {
    "unitId": "workbook-1",
    "subUnitId": "sheet-1",
    "name": "Sales Data"
  }
}

6. Add New Sheet (sheet.mutation.insert-sheet)

Create additional sheets in the workbook:

{
  "id": "sheet.mutation.insert-sheet",
  "params": {
    "unitId": "workbook-1",
    "sheet": {
      "id": "sheet-2",
      "name": "Summary"
    },
    "index": 1
  }
}

Notes:

  • id is the subUnitId you'll use when adding data to this sheet
  • index determines the tab position (0 = first, 1 = second, etc.)
  • After creating a sheet, use subUnitId: "sheet-2" in your data commands

Formula Reference

Basic Formulas

Formula Description Example
=SUM(range) Sum of values =SUM(B2:B10)
=AVERAGE(range) Average of values =AVERAGE(C2:C20)
=COUNT(range) Count of numbers =COUNT(A1:A100)
=MAX(range) Maximum value =MAX(D2:D50)
=MIN(range) Minimum value =MIN(D2:D50)
=IF(condition, true, false) Conditional =IF(A1>100,"High","Low")

Financial Formulas

Formula Description Example
=PMT(rate, nper, pv) Loan payment =PMT(0.05/12, 360, -200000)
=NPV(rate, values) Net present value =NPV(0.1, B2:B10)
=IRR(values) Internal rate of return =IRR(A1:A5)
=FV(rate, nper, pmt) Future value =FV(0.08, 10, -1000)

Text Formulas

Formula Description Example
=CONCATENATE(a, b) Join text =CONCATENATE(A1, " ", B1)
=LEFT(text, n) Left characters =LEFT(A1, 3)
=RIGHT(text, n) Right characters =RIGHT(A1, 4)
=LEN(text) Text length =LEN(A1)
=UPPER(text) Uppercase =UPPER(A1)

Lookup Formulas

Formula Description Example
=VLOOKUP(value, range, col, exact) Vertical lookup =VLOOKUP(A1, D1:F10, 2, FALSE)
=HLOOKUP(value, range, row, exact) Horizontal lookup =HLOOKUP("Q1", A1:D5, 3, FALSE)
=INDEX(range, row, col) Get cell by position =INDEX(A1:C10, 5, 2)
=MATCH(value, range, type) Find position =MATCH("Apple", A1:A10, 0)

Date Formulas

Formula Description Example
=TODAY() Current date =TODAY()
=NOW() Current date/time =NOW()
=YEAR(date) Extract year =YEAR(A1)
=MONTH(date) Extract month =MONTH(A1)
=DATEDIF(start, end, unit) Date difference =DATEDIF(A1, B1, "D")

Complete Examples

Example 1: Simple Data Table

{
  "title": "Employee Directory",
  "commands": [
    {
      "id": "sheet.mutation.set-worksheet-name",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "name": "Employees"
      }
    },
    {
      "id": "sheet.mutation.set-worksheet-col-width",
      "params": { "unitId": "workbook-1", "subUnitId": "sheet-1", "colIndex": 0, "width": 120 }
    },
    {
      "id": "sheet.mutation.set-worksheet-col-width",
      "params": { "unitId": "workbook-1", "subUnitId": "sheet-1", "colIndex": 1, "width": 80 }
    },
    {
      "id": "sheet.mutation.set-worksheet-col-width",
      "params": { "unitId": "workbook-1", "subUnitId": "sheet-1", "colIndex": 2, "width": 150 }
    },
    {
      "id": "sheet.mutation.set-range-values",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "range": { "startRow": 0, "endRow": 0, "startColumn": 0, "endColumn": 2 },
        "value": [[
          { "v": "Name", "s": "header" },
          { "v": "Age", "s": "header" },
          { "v": "Email", "s": "header" }
        ]]
      }
    },
    {
      "id": "sheet.mutation.set-range-values",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "range": { "startRow": 1, "endRow": 3, "startColumn": 0, "endColumn": 2 },
        "value": [
          [{ "v": "Alice Smith" }, { "v": 28 }, { "v": "alice@company.com" }],
          [{ "v": "Bob Johnson" }, { "v": 34 }, { "v": "bob@company.com" }],
          [{ "v": "Carol White" }, { "v": 31 }, { "v": "carol@company.com" }]
        ]
      }
    }
  ]
}

Example 2: Financial Model with Formulas

{
  "title": "Q4 Revenue Analysis",
  "commands": [
    {
      "id": "sheet.mutation.set-worksheet-name",
      "params": { "unitId": "workbook-1", "subUnitId": "sheet-1", "name": "Revenue" }
    },
    {
      "id": "sheet.mutation.set-range-values",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "range": { "startRow": 0, "endRow": 0, "startColumn": 0, "endColumn": 4 },
        "value": [[
          { "v": "Month", "s": "header" },
          { "v": "Revenue", "s": "header" },
          { "v": "Costs", "s": "header" },
          { "v": "Profit", "s": "header" },
          { "v": "Margin %", "s": "header" }
        ]]
      }
    },
    {
      "id": "sheet.mutation.set-range-values",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "range": { "startRow": 1, "endRow": 3, "startColumn": 0, "endColumn": 4 },
        "value": [
          [{ "v": "October" }, { "v": 150000 }, { "v": 95000 }, { "f": "=B2-C2" }, { "f": "=D2/B2*100" }],
          [{ "v": "November" }, { "v": 180000 }, { "v": 110000 }, { "f": "=B3-C3" }, { "f": "=D3/B3*100" }],
          [{ "v": "December" }, { "v": 220000 }, { "v": 125000 }, { "f": "=B4-C4" }, { "f": "=D4/B4*100" }]
        ]
      }
    },
    {
      "id": "sheet.mutation.set-range-values",
      "params": {
        "unitId": "workbook-1",
        "subUnitId": "sheet-1",
        "range": { "startRow": 5, "endRow": 5, "startColumn": 0, "endColumn": 4 },
        "value": [[
          { "v": "Total", "s": "header" },
          { "f": "=SUM(B2:B4)" },
          { "f": "=SUM(C2:C4)" },
          { "f": "=SUM(D2:D4)" },
          { "f": "=D6/B6*100" }
        ]]
      }
    }
  ]
}

Workflow

  1. Create - Call create with title and initial commands → get back docId
  2. Append - Call append with docId to add/update data (repeat as needed)

The get endpoint is only needed when user provides a docId/URL from elsewhere and you need to see the current state.

Tips

  • Set column widths first for better layout
  • Use "s": "header" for header cells (bold styling)
  • Use "s": "title" for title cells (larger font)
  • Formulas use Excel-style syntax: =SUM(A1:A10), =B2*C2, etc.
  • Row/column indices are 0-based (row 0 = Excel row 1)
  • Build data row by row for cleaner code
  • For multi-sheet references, use 'Sheet Name'!A1:B10 syntax
  • Create sheets first with insert-sheet, then populate them with data

Skill as a Service

Everyone else asks you to install skills locally. On Rebyte, just click Run. Works from any device — even your phone. No CLI, no terminal, no configuration.

  • Zero setup required
  • Run from any device, including mobile
  • Results streamed in real-time
  • Runs while you sleep
Run this skill now

Compatible agents

Claude Code

Gemini CLI

Codex

Cursor, Windsurf, Amp

rebyte.ai — The only platform where you can run AI agent skills directly in the cloud

No downloads. No configuration. Just sign in and start using AI skills immediately.

Use this skill in Agent Computer — your shared cloud desktop with all skills pre-installed. Join Moltbook to connect with other teams.