excel-analytics — Claude Code skill: what it does, how to install
excel-analytics builds structured Excel workbooks to track Xiaohongshu content metrics, follower gains, and engagement rates without dedicated BI tools.
no license 281 installs ★ 564 updated 2026-01-23
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a claude-codeWhat excel-analytics does
The skill defines a ten-sheet workbook template tailored to Xiaohongshu performance tracking. It covers raw export storage, post logs, audience growth, competitor benchmarks, and high-level KPI dashboards, complete with a strict data dictionary for impressions, saves, shares, and reactions.
It also supplies standard formulas for rolling averages, period-over-period changes, and engagement rates, alongside cleanup steps for CSV exports. This setup relies entirely on spreadsheets, so it will fall short if your team needs real-time telemetry or heavy statistical modeling.
What it helps with
- organize a multi-sheet spreadsheet for social media performance tracking
- compute post engagement rates from raw interaction counts
- clean exported CSV data before building pivot tables
- track audience growth rates and week-over-week trends
Example prompts for the agent
- Set up an Excel workbook structure to track Xiaohongshu post metrics
- Show me the formula for calculating post engagement rate from raw reach and reactions
- How should I structure the raw data import sheet for my exported CSV files?
How to install excel-analytics
1Skills CLI (Vercel)
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a claude-code2Manually: put the files in place
~/.claude/skills/excel-analytics/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/excel-analytics/
1Skills CLI (Vercel)
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a codex2Manually: put the files in place
.agents/skills/excel-analytics/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a cursor2Manually: put the files in place
.cursor/skills/excel-analytics/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install vivy-yi/xiaohongshu-skills skills/03-数据分析/excel-analytics2Manually: put the files in place
.github/skills/excel-analytics/SKILL.md1Skills CLI (Vercel)
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a gemini-cli2Platform CLI
gemini skills install https://github.com/vivy-yi/xiaohongshu-skills --path skills/03-数据分析/excel-analyticsManually: put the files in place
.devin/skills/excel-analytics/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about excel-analytics
How to install excel-analytics in Claude Code?
Run npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a claude-code. Alternatively, save the file manually to ~/.claude/skills/excel-analytics/SKILL.md.
What does excel-analytics do?
It guides the agent in setting up organized spreadsheets, schemas, and formulas to evaluate Xiaohongshu content performance.
Can this skill handle live streaming analytics?
No, it targets periodic manual entries and CSV imports rather than real-time platform telemetry.