Data Cleanup
sgharlow/claude-code-recipes
Clean and standardize messy tabular data (CSV, spreadsheet paste, system exports) into an analysis-ready dataset — consistent dates and names, typed columns, duplicates identified, missing values…
OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports.
Install Spreadsheet Analyst
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install ownpilot/OwnPilot spreadsheet-analyst --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .claude/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .claude/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .claude/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analystType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install ownpilot/OwnPilot spreadsheet-analyst --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .agents/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .agents/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .agents/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install ownpilot/OwnPilot spreadsheet-analyst --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .cursor/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .cursor/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/ownpilot/OwnPilot.git --path packages/gateway/data/example-skills/spreadsheet-analyst--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install ownpilot/OwnPilot spreadsheet-analyst --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .gemini/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .gemini/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install ownpilot/OwnPilot spreadsheet-analystInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .github/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .github/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .github/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install ownpilot/OwnPilot spreadsheet-analyst --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/ownpilot/OwnPilot.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/packages/gateway/data/example-skills/spreadsheet-analyst .opencode/skills/spreadsheet-analyst && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "spreadsheet-analyst" agent skill from https://github.com/ownpilot/OwnPilot/tree/main/packages/gateway/data/example-skills/spreadsheet-analyst into .opencode/skills/spreadsheet-analyst/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "spreadsheet-analyst", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
spreadsheet-analyst- GitHub stars
- 426
- Token cost
- ~341 tokens
- SKILL.md length
- 121 words
- Files
- 1
- Skills in repo
- 9
- Repo updated
- First seen
- Licence
- MIT
At a glance
OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports.
- Works in 6 steps: Identify the grain of the data: what one… → Check required columns, data types,… → Separate raw data, calculations,… → …
- The user works with spreadsheet-like data
- SKILL.md covers Analysis Workflow, Model Design, Output Format and Formula Guidance
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Spreadsheet Analyst is an agent skill from ownpilot/OwnPilot. OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports. Use when the user works with spreadsheet-like data.
Its SKILL.md is about 340 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Documents & Office, covering Excel spreadsheets and Data cleaning. The repository describes itself as: Privacy-first personal AI assistant platform with autonomous agents, tool orchestration, and multi-provider support. The licence is MIT.
When your agent uses it
- The user works with spreadsheet-like data
- Tasks that involve Excel spreadsheets
- Tasks that involve Data cleaning
Example prompts
- “/spreadsheet-analyst”
Workflow steps
6 steps, taken from the first numbered list in SKILL.md.
- Identify the grain of the data: what one row represents.
- Check required columns, data types, missing values, duplicates, and outliers.
- Separate raw data, calculations, assumptions, and presentation.
- Explain formulas in plain language before giving syntax.
- Prefer reproducible transformations over manual edits.
- Summarize insights with caveats and recommended next checks.
What it can do on your machine
Read from SKILL.md and the folder at commit eb4c27f. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Spreadsheet Analyst loads about 341 tokens when it runs. Until then it costs about 58 tokens; SKILL.md has 121 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from ownpilot/OwnPilot at commit eb4c27f, republished under its MIT licence (© ownpilot). 121 words, ~341 tokens.
Download SKILL.mdSave it as
.claude/skills/spreadsheet-analyst/SKILL.md (or your agent's skills folder).- name
- spreadsheet-analyst
- description
- OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports. Use when the user works with spreadsheet-like data.
- metadata.author
- OwnPilot Official
- metadata.version
- 1.0.0
- license
- MIT
Spreadsheet Analyst
Use this skill when the user needs help with spreadsheet design, tabular analysis, formulas, or reporting.
Analysis Workflow
- Identify the grain of the data: what one row represents.
- Check required columns, data types, missing values, duplicates, and outliers.
- Separate raw data, calculations, assumptions, and presentation.
- Explain formulas in plain language before giving syntax.
- Prefer reproducible transformations over manual edits.
- Summarize insights with caveats and recommended next checks.
Model Design
Use separate sheets or sections for:
- Inputs and assumptions
- Raw data
- Transformations
- Calculations
- Summary dashboard or export
Output Format
Data shape:
Quality checks:
Key calculations:
Findings:
Recommended formulas or transformations:
Risks / caveats:Formula Guidance
- State the target spreadsheet app if formulas differ.
- Avoid volatile formulas unless needed.
- Include sample formulas with named columns or clear cell references.
© ownpilot, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in packages/gateway/data/example-skills/spreadsheet-analyst of ownpilot/OwnPilot.
Open the folder on GitHubat commit eb4c27f
Compare with similar skills
Spreadsheet Analyst next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Spreadsheet Analyst this skillownpilot/OwnPilot | 426 | — | ~341 | Automated safety check: Pass | MIT | |
| Data Cleanupsgharlow/claude-code-recipes | 389 | — | ~566 | Automated safety check: Pass | Custom licence | |
| Sn Da Excel WorkflowMichaelYang-lyx/AIDABench | 111 | 1 repos | ~2.5k | Automated safety check: Pass | None | |
| Numeric Format NormalizationMichaelYang-lyx/AIDABench | 111 | 1 repos | ~505 | Automated safety check: Pass | None | |
| XLSX Spreadsheet ToolkitXiaomiMiMo/MiMo-Code | 14k | — | ~2.9k | Automated safety check: Pass | Apache-2.0 | |
| CSV and Excel MergerOneWave-AI/claude-skills | 323 | — | ~1.6k | Automated safety check: Pass | MIT |
Similar skills
Sn Da Excel Workflow
MichaelYang-lyx/AIDABench
Excel 数据分析多步编排器。覆盖：(1) 读取多 Sheet Excel 文件并统计行数，(2) 大文件检测（≥10k 行自动 Parquet 优化），(3) 数据清洗（缺失值、文本标准化、无效字符），(4) 条件筛选与分类提取，(5) 跨 Sheet 统计聚合，(6) 导出 Excel/CSV 并提供下载链接。覆盖从数据读取到报告生成全流程，按步骤编排 capability 子…
Numeric Format Normalization
MichaelYang-lyx/AIDABench
对 Excel 数据进行数值格式标准化与清洗，支持大规模数据的 Parquet 转换流程，并完成关键指标的合计核对与结果文件导出。
XLSX Spreadsheet Toolkit
XiaomiMiMo/MiMo-Code
Builds, edits, cleans, recalculates and reads Excel workbooks and CSV files with openpyxl and pandas, plus LibreOffice for recalculation and PDF export.
CSV and Excel Merger
OneWave-AI/claude-skills
Combines CSV, TSV and Excel files into one verified table with pandas, by stacking or joining, mapping columns, normalizing keys and removing duplicates.
- Official
Excel Spreadsheet Creation and Editing
anthropics/skills
Creates, edits and analyzes spreadsheets (.xlsx, .xlsm, .csv, .tsv) with openpyxl and pandas, writing live formulas and recalculating to confirm zero formula errors.
More from ownpilot/OwnPilot
All 9 skills in this repoCode Review
ownpilot/OwnPilot
Reviews code for quality issues, security vulnerabilities, performance problems, and best practices.
API Debugging
ownpilot/OwnPilot
Systematic approach to debugging REST APIs, HTTP errors, authentication issues, and network problems.
Git Workflow
ownpilot/OwnPilot
Guides you through Git workflows — branching strategies, commit conventions, merge conflict resolution, and release management.
Writing Assistant
ownpilot/OwnPilot
Helps improve writing quality — emails, documents, blog posts, and technical content.
Document Assistant
ownpilot/OwnPilot
OwnPilot official general skill for drafting, editing, restructuring, and reviewing long-form documents, reports, proposals, policies, and documentation.
Meeting Notes
ownpilot/OwnPilot
OwnPilot official general skill for converting rough meeting notes, transcripts, and call summaries into decisions, action items, owners, risks, and follow-ups.
Related
Categories
Questions about Spreadsheet Analyst
What does Spreadsheet Analyst do?
OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports. Spreadsheet Analyst is an agent skill from ownpilot/OwnPilot. OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports.
When should I use Spreadsheet Analyst?
Spreadsheet Analyst fits situations like: the user works with spreadsheet-like data; tasks that involve Excel spreadsheets; tasks that involve Data cleaning.
How do I install Spreadsheet Analyst in Claude Code?
Run `npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a claude-code`. Or copy the skill folder (packages/gateway/data/example-skills/spreadsheet-analyst in ownpilot/OwnPilot) into .claude/skills/spreadsheet-analyst in your project. Claude Code loads it when a task matches its description.
How do I install Spreadsheet Analyst in Codex?
Run `npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a codex`. Or copy the skill folder (packages/gateway/data/example-skills/spreadsheet-analyst in ownpilot/OwnPilot) into .agents/skills/spreadsheet-analyst in your project. Codex loads it when a task matches its description.
Can I use Spreadsheet Analyst in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/spreadsheet-analyst, .gemini/skills/spreadsheet-analyst, .github/skills/spreadsheet-analyst and .opencode/skills/spreadsheet-analyst in your project.
What does Spreadsheet Analyst need to run?
SKILL.md names no scripts, command-line tools or credentials: Spreadsheet Analyst is instructions for the agent only.
Does Spreadsheet Analyst access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Spreadsheet Analyst safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Spreadsheet Analyst use?
Spreadsheet Analyst is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Spreadsheet Analyst use?
About 341 tokens (SKILL.md is roughly 1.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Spreadsheet Analyst?
Skills that share tags, products or a category with Spreadsheet Analyst: Data Cleanup (sgharlow/claude-code-recipes, 389 stars), Sn Da Excel Workflow (MichaelYang-lyx/AIDABench, 111 stars), Numeric Format Normalization (MichaelYang-lyx/AIDABench, 111 stars) and XLSX Spreadsheet Toolkit (XiaomiMiMo/MiMo-Code, 14k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Spreadsheet Analyst?
ownpilot (a GitHub organization) maintains it in ownpilot/OwnPilot, which has 426 GitHub stars. The repository holds 9 skills in this directory. The repository was last updated on September 8, 2026.
Source: ownpilot/OwnPilot on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.