메뉴
Generate an Excel (.xlsx) workbook or a CSV file — tables, financial models, data exports, formatted reports with charts. Use when the user wants a spreadsheet or CSV. Built with openpyxl + pandas (Python).
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Analyze spreadsheet data intelligently - understand structure, choose right analysis tool (SQL/pivot/chart), apply formatting, present insights.
Create charts and visualizations in Google Sheets — detect data structure, select chart type, format for clarity, present insights
Generate an editable Microsoft Word (.docx) document — reports, letters, memos, structured docs. Use when the user wants a Word file. Built with docx-js (Node) for high fidelity.
Generate a polished, printable PDF — reports, letters, invoices, resumes, one-pagers. Use when the user wants a PDF document. Typst is the primary engine; LaTeX (tectonic) is the fallback for niche packages or specific academic/journal templates.
Generate a PowerPoint (.pptx) slide deck — pitch decks, reviews, summaries. Use when the user wants slides. Built with pptxgenjs (Node) for native, editable slides and charts.
Complete guide for GAIA tracked todos — philosophy, two modes (immediate/long-running), canvas activity logging, scheduling/recurrence, and institutional memory.
| name | create-spreadsheet |
| title | Create Spreadsheet |
| description | Generate an Excel (.xlsx) workbook or a CSV file — tables, financial models, data exports, formatted reports with charts. Use when the user wants a spreadsheet or CSV. Built with openpyxl + pandas (Python). |
| target | docgen_agent |
The deliverable is .xlsx or .csv. For Google Sheets use the googlesheets skill.
There is no spreadsheet recalc engine in the sandbox. If you write a formula like =SUM(...), Excel shows it as blank until the user opens and recalculates. So:
=FORMULA when the user explicitly wants an editable formula — and when you do, also write the computed value in an adjacent labeled cell so the number is visible immediately.A template here is a Python program (openpyxl + pandas) that writes the workbook. You adapt the data and structure, then the build script runs it and validates the file.
Skill directory: /workspace/integrations/docgen/agent/skills/create-spreadsheet — templates/, reference.md, and scripts/ live here; read them by absolute path. Your work goes in ./scratch/.
mkdir -p ./scratch/xlsx-<short-name>.read /workspace/integrations/docgen/agent/skills/create-spreadsheet/templates/report.py, then write the edited program to ./scratch/xlsx-<name>/sheet.py. Read /workspace/integrations/docgen/agent/skills/create-spreadsheet/reference.md for openpyxl building blocks and the values rule.bash /workspace/integrations/docgen/agent/skills/create-spreadsheet/scripts/build.sh ./scratch/xlsx-<name>/sheet.py ./scratch/xlsx-<name>/out.xlsx
OK: <path> (sheets=N) or ERROR: ....ERROR, read the message, fix, re-run. Cap at 5 attempts.mv ./scratch/xlsx-<name>/out.xlsx ./artifacts/<final-name>.xlsx, then report the full path.CSV is plain text — write it directly with bash and deliver:
python3 - <<'PY'
import csv
rows = [["name","amount"], ["Acme", 1200], ["Globex", 980]]
with open("./artifacts/<final-name>.csv", "w", newline="") as f:
csv.writer(f).writerows(rows)
PY
No toolchain, no validation step — just confirm the file is in ./artifacts/ and report the path.
The build script provisions openpyxl + pandas on first use; the first workbook may take a little longer, then it's fast.
= formulas as the only representation of a computed number (no recalc → blank cells). Write the value../scratch/. Never skip build/validate for .xlsx.report.py — formatted workbook: styled header, data rows, a computed totals row, number formats, column widths, and a bar chart.