# excel-analytics

excel-analytics builds structured Excel workbooks to track Xiaohongshu content metrics, follower gains, and engagement rates without dedicated BI tools.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 281 installs · ★ 564 repo stars
- Author: vivy-yi
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/vivy-yi/xiaohongshu-skills/tree/HEAD/skills/03-数据分析/excel-analytics/SKILL.md
- Updated: 2026-01-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/excel-analytics

## What it 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.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/excel-analytics/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/excel-analytics/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/excel-analytics/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/excel-analytics/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install vivy-yi/xiaohongshu-skills skills/03-数据分析/excel-analytics
```

2. **Manually: put the files in place**
- File: `.github/skills/excel-analytics/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/vivy-yi/xiaohongshu-skills --path skills/03-数据分析/excel-analytics
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/excel-analytics/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill excel-analytics -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/vivy-yi/xiaohongshu-skills/tree/HEAD/skills/03-数据分析/excel-analytics/SKILL.md

## When to use it
- 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
- 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?

## Similar
- [excel](https://affpapa.org/en/nevibecode/skills/sundial-org-excel.md) — skill · 294 installs
- [Excel MCP Server](https://affpapa.org/en/nevibecode/mcp/excel-mcp-server.md) — MCP server · ★ 4321 repo stars
- [excel-vision-mcp](https://affpapa.org/en/nevibecode/mcp/excel-vision-mcp.md) — MCP server · ★ 20 repo stars
- [excel-macro-creator](https://affpapa.org/en/nevibecode/skills/excel-macro-creator.md) — skill · 4 installs
- [excel-formula-generator](https://affpapa.org/en/nevibecode/skills/excel-formula-generator.md) — skill · 2 installs
- [analytics-and-reporting](https://affpapa.org/en/nevibecode/skills/analytics-and-reporting.md) — skill · 1500 installs

From the same set: [vivy-yi/xiaohongshu-skills](https://affpapa.org/en/nevibecode/by/vivy-yi/xiaohongshu-skills.md) — 100 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
