Excel Analytics
If you're tracking Xiaohongshu performance and need custom analysis beyond what the platform gives you, this walks through building Excel spreadsheets that actually work. It covers the full workflow from importing data exports to setting up pivot tables, calculating engagement rates with formulas, and creating reusable dashboards. The spreadsheet architecture is solid: separate sheets for raw data, content logs, competitor tracking, and visualizations. You get specific formulas for metrics like week-over-week growth and moving averages, plus conditional formatting rules to highlight what matters. Best for manual or semi-automated analysis when you need flexibility. Skip it if you need real-time monitoring or have access to proper BI tools.
- skills.sh installs
- 277
- GitHub stars
- 539
- last updated
- Aug 21, 2026
Install
$ npx -y skills add vivy-yi/xiaohongshu-skills --skill excel-analytics --agent claude-codeInstalls into .claude/skills of the current project.
Files
Excel Analytics (Excel数据分析)
Overview
Excel analytics is the systematic use of spreadsheet software to organize, analyze, visualize, and report on Xiaohongshu performance data, enabling custom analysis, flexible reporting, and data-driven insights without requiring specialized analytics tools.
When to Use
Use when:
- Building custom tracking spreadsheets for Xiaohongshu data
- Analyzing exported data from platform analytics
- Creating personalized dashboards and reports
- Conducting custom calculations and metrics
- Visualizing performance trends and patterns
- Learning data analysis fundamentals
- Comparing multiple time periods or content types
- Creating executive summaries for stakeholders
Do NOT use when:
- Real-time monitoring needed (use platform analytics)
- Complex statistical analysis required (use specialized tools)
- Automated reporting at scale (use BI tools)
- Simple quick checks (use platform native analytics)
Core Pattern
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/vivy-yi/xiaohongshu-skills
- Categories
- Data Science & ML, Debugging, Marketing & SEO, Office & Documents
- First seen
- Jun 3, 2026
More from vivy-yi/xiaohongshu-skills
All 26- Private Domain275
- Topic Participation274
- Store Operations273
- Xinhong Data273
- Content Marketing268
- Viral Strategy266
- Sentiment Monitoring263
- Content Review256
- Competitor Analysis254
- Customer Service254
- Social Listening236
- Short Video Production780
- Copywriting Skills579
- Image Editing438
- Viral Creation351
- Jiaying Tool346
- Traffic Acquisition343
- Content Performance Analysis338
- Brand Operation335
- Product Selection326
- Livestream Sales325
- Graphic Content Creation321
- Meitu Xiuxiu302
- Photo Editing Tools289
Recommended
More Data Science & ML
mckinsey-researchabdullah4ai/mckinsey-researchRun a full McKinsey-level market research and strategy analysis using 12 specialized prompts. USE WHEN: - market research, competitive analysis, business strate272skills.sh installs
content-research-writerpedronauck/skillsAssists in writing high-quality content by conducting research, adding citations, improving hooks, iterating on outlines, and providing real-time feedback on ea270skills.sh installs
prospecting-researchguia-matthieu/clawfu-skillsConduct deep account and contact research to personalize outreach and identify compelling angles for engagement269skills.sh installs
keyword-research-and-clusteringmanojbajaj95/claude-gtm-pluginResearch, expand, and cluster keywords for content strategy. Use when planning content topics, building keyword lists, expanding seed keywords, clustering by to259skills.sh installs
parallel-researchcasper-studios/casper-marketplaceAI-powered deep research using Parallel AI APIs for chat, research reports, entity discovery, and data enrichment. Use this skill when doing web research, compe257skills.sh installs
performance-analyticsanthropics/knowledge-work-pluginsAnalyze marketing performance with key metrics, trend analysis, and optimization recommendations. Use when building performance reports, reviewing campaign resu253skills.sh installs