skills.rest
MeerkatAIChina
MeerkatAIChinaOFFICIAL
Explore all skills by this author →
WebsiteGitHub

product-roadmap-excel-generator

Convert requirement and product roadmap Markdown documents into structured Excel planning workbooks.

Updated Aug 25, 2026
Search Tags:#product roadmap#roadmap planning#conditional formatting#bcg matrix#excel generation#requirement prioritization#rice model
One-click install
npx skills add https://github.com/MeerkatAIChina/meerkat-skills-activity --skill product-roadmap-excel-generator-meerkataichina
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: product-roadmap-excel-generator
Source: https://github.com/MeerkatAIChina/meerkat-skills-activity/tree/main/skills/product-roadmap-excel-generator
Command: npx skills add https://github.com/MeerkatAIChina/meerkat-skills-activity --skill product-roadmap-excel-generator-meerkataichina

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Product teams often maintain requirement roadmaps and product roadmaps as scattered Markdown documents, making it hard to get a unified view, track priorities, and align product, technology, and design roadmaps. This Skill converts those documents into a structured Excel workbook with summary sheets and per-series timeline views. ## Core Features & Use Cases - Unified Roadmap Views: Generates a requirement roadmap summary sheet, a product roadmap summary sheet, and one timeline sheet per product series. - Priority & Risk Visualization: Applies P0-P3 priority levels, status colors, and high/medium/low risk conditional formatting based on defined mapping rules. - Three-Roadmap Alignment: Supports the three-roadmap-in-one methodology (product, technology, design) with RICE-based prioritization and BCG portfolio analysis guidance. - Use Case: A consumer electronics product manager has a requirement roadmap and a product roadmap in Obsidian. The Skill parses both documents and outputs an Excel file with 16 requirements, 11 products, and per-series quarterly timelines for roadmap review meetings. ## Quick Start Ask the assistant to generate a product roadmap Excel from your requirement roadmap document and product roadmap document, optionally specifying the output filename and quarter range.

Frequently Asked Questions about product-roadmap-excel-generator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a product roadmap Excel from Markdown documents?▼

Prepare a requirement roadmap and a product roadmap following the standard templates, then ask the assistant to generate the Excel. The output contains a requirement summary sheet, a product summary sheet, and one timeline sheet per product series.

What input format does the roadmap Excel generator require?▼

It requires Markdown documents following the defined templates: requirement entries with fields like ID, type, source, priority, and target quarter, plus product entries with series, role, price range, launch time, and status. Missing required fields can cause generation failures.

How are requirement priorities P0 to P3 determined?▼

Priorities are evaluated with the RICE model: Reach, Impact, Confidence, and Effort. The score is calculated as (Reach x Impact x Confidence) / Effort, then mapped to P0 strategic, P1 important, P2 planned, and P3 deferred levels.

Does the generated Excel support conditional formatting for risk and status?▼

Yes. The specification defines color rules: red/orange/yellow backgrounds for P0-P2 priorities, distinct colors for lifecycle states like in-development or mature, and red/orange/green for high, medium, and low risk levels.

Why does Excel generation fail for my roadmap document?▼

Common causes are incorrect document paths, non-standard document structure, missing required fields, or wrong time formats. Dates must use the quarter format such as 2024Q2, and documents must follow the templates in the specification.

Can I customize the timeline range in the generated Excel?▼

Yes. By default the timeline covers six quarters starting from the current quarter, but you can specify a custom range such as 2024Q1 to 2025Q4, and each product series sheet will include the full timeline view.

Related Skills

Explore More Product & Management Skills→
mlopscommunitymlopscommunity
37

product-research

Synthesize raw research data into product insights for competitive analysis.

Official
Advanced
SpaceZephyrSpaceZephyr
14

SPACE-roadmap-planner

Generate interactive HTML version roadmaps from quarterly OKRs with milestones and risk mitigation.

Community
Advanced
The13thNodeThe13thNode
3

roadmap-planning

Generate prioritized product roadmaps and aligned OKRs with RICE, ICE, and Kano scoring.

Community
Intermediate
archerliarcherli

roadmap-planning

Guide strategic product roadmap planning with prioritization and release sequencing.

Community
Advanced