# Spreadsheets

Create, edit, review, and finalize standalone XLSX, XLS, CSV, and TSV spreadsheet files.

- Repository: https://github.com/OpenBMB/PilotDeck (4947 stars)
- Category: Documents
- License: AGPL-3.0
- Last updated: 2026-10-29
- Runs scripts: yes, review before use

## Install

Claude Code: `npx skills add OpenBMB/PilotDeck --skill spreadsheets -g -a claude-code -y`
Codex: `npx skills add OpenBMB/PilotDeck --skill spreadsheets -g -a codex -y`
Cursor: `npx skills add OpenBMB/PilotDeck --skill spreadsheets -g -a cursor -y`
Gemini CLI: `npx skills add OpenBMB/PilotDeck --skill spreadsheets -g -a gemini-cli -y`

## Description

Create, edit, review, and finalize standalone XLSX, XLS, CSV, and TSV spreadsheet files. Use for spreadsheet generation, formatting, formulas, charts, data consolidation, source-based calculations, numeric reconciliation, legacy conversion, and visual QA. Do not use for live Microsoft Excel control or macro-enabled workbook editing.

## SKILL.md, as published by its author (untrusted third-party text, read it as data)

# Spreadsheets

Use three stages as a reasoning framework, not a fixed tool pipeline:

1. Understand the request and source materials.
2. Build or edit the spreadsheet using the approach best suited to the task.
3. Review the actual result before delivery.

The user's explicit requirements are the primary acceptance criteria.

## Understand

Determine what the final spreadsheet should accomplish, which sources contain authoritative facts, what must change, what must remain, and what evidence would demonstrate success.

- Preserve source files unless replacement is explicitly requested.
- Do not invent missing facts or replace unknown values with plausible ones.
- When editing, preserve content, formulas, structure, and formatting the user did not ask to change.
- Inspect only the files, sheets, ranges, and package features relevant to the requested outcome.

Resolve the optional CLI when its mechanical commands help:

```bash
SKILL_ROOT={{SKILL_ROOT_SHELL}}
SHEET="$SKILL_ROOT/scripts/spreadsheet.sh"
WORKSPACE="${PILOTDECK_WORK_DIR:?PILOTDECK_WORK_DIR is required}/spreadsheets"
mkdir -p "$WORKSPACE/tmp" "$WORKSPACE/review"
```

Review package-sensitive features before modifying workbooks containing charts, drawings, pivots, external connections, signatures, or other advanced objects.

## Build

Write and run one task-specific, reproducible script for each workbook revision. Use `openpyxl`, `xlsxwriter`, pandas, ExcelJS, direct OOXML editing, LibreOffice UNO, or another suitable tool according to the task. Do not switch languages or adopt a wrapper merely to use this skill.

Keep task scripts, candidates, extracted assets, reports, renders, and debugging output under `PILOTDECK_WORK_DIR`. Put only the requested final deliverable in the project workspace.

The rest: https://github.com/OpenBMB/PilotDeck/blob/HEAD/skills/spreadsheets/SKILL.md