Excel Analytics · vivy-yi/xiaohongshu-skills

Track Xiaohongshu performance data in Excel dashboards

Builds Excel spreadsheets to import, clean, and calculate metrics from Xiaohongshu (Little Red Book) exports, then turns them into pivot tables, charts, and dashboards. Useful for tracking content performance and building recurring reports without specialized analytics software.

Good for

  • Build a pivot table from Xiaohongshu export data
  • Calculate engagement rate formulas in Excel
  • Create a recurring performance dashboard template
Category
Xiaohongshu

Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.

A good place to start

Help me build an Excel dashboard that tracks engagement rate and views from my Xiaohongshu post exports each week.

Make your next great thing.

Bring a question, a file, or an idea that’s not quite there yet.