Generate a formatted FF&E specification schedule from raw product data — notes, CSV, or pasted lists. Outputs a structured schedule compatible with the 33-column master schema.
Takes raw, unstructured product data and formats it into a proper FF&E specification schedule. Input can be notes, a CSV, a pasted spreadsheet, or a conversation. Output is a formatted schedule as markdown, CSV, or written to a Google Sheet — using the same 33-column schema as /product-research, /product-spec-bulk-fetch, and other product skills.
The designer provides product data in any format:
Raw notes:
3x Eames Lounge Chair, Herman Miller, walnut/black leather, $5,695 each
2x Nelson Platform Bench 48", Herman Miller, natural maple, $2,195
1x Noguchi Coffee Table, Herman Miller, walnut/glass, $2,095
Pendant light for above the table - something by Flos, budget $800-1200
Pasted spreadsheet or CSV:
Product, Brand, Qty, Price
Eames Lounge Chair, Herman Miller, 3, $5695
Nelson Bench 48, Herman Miller, 2, $2195
A file path:
/product-data-import ~/Documents/project/product-list.csv
Conversational:
"We need 8 task chairs — Steelcase Leap V2, black, about $1,200 each.
Also 4 monitor arms, any brand, under $300."
Accept whatever the designer gives. Don't ask for more structure — work with what you have.
For each product in the input:
../../schema/product-schema.mdItem number prefixes are defined in ../../schema/product-schema.md under Item Number Prefixes. Read that file for the full mapping of canonical categories to prefixes (e.g. Chair → S, Table → T, Light → L).
Show the formatted schedule as a markdown table:
## FF&E Schedule — [Project Name if known]
[n] items · [total qty] units · $[total extended] estimated
| Item # | Product | Brand | Qty | W | D | H | Unit | Materials | Finish | Unit $ | Ext $ | Lead | Notes |
|--------|---------|-------|-----|---|---|---|------|-----------|--------|--------|-------|------|-------|
| S-01 | Eames Lounge Chair | Herman Miller | 3 | 32.75 | 32.5 | 33.5 | in | Molded plywood, leather | Walnut/Black | $5,695 | $17,085 | 8-12w | |
| T-01 | Nelson Platform Bench 48" | Herman Miller | 2 | 48 | 18.5 | 14 | in | Solid maple | Natural | $2,195 | $4,390 | 6-8w | |
| T-02 | Noguchi Coffee Table | Herman Miller | 1 | 50 | 36 | 15.75 | in | Walnut, glass | — | $2,095 | $2,095 | 6-8w | |
| L-01 | TBD Pendant | Flos | 1 | — | — | — | — | — | — | $800-$1,200 | $800-$1,200 | — | Needs specification |
**Subtotals by category:**
- Seating: $17,085 (3 units)
- Tables: $6,485 (3 units)
- Lighting: $800-$1,200 (1 unit, TBD)
- **Total: $24,370-$24,770**
Ask the designer how they want the schedule:
.csv to the current directory or a specified pathIf the designer doesn't specify, default to saving a CSV file.
Save as product-data-import-[date].csv with these columns:
Item #, Product Name, Brand, Category, Qty, W, D, H, Unit, Materials, Finish, Unit Price, Extended Price, Lead Time, Notes
If the designer provides a Sheet ID or says "save to my sheet", write to the 33-column master schema. Read ../../schema/product-schema.md (relative to this SKILL.md) for the full column reference, field formats, and category vocabulary. Read ../../schema/sheet-conventions.md for CRUD patterns with MCP tools.
Skill-specific column values:
product-data-importspecifiedQty: 3 · Ext: $17,085 (quantity and extended price, since the schema has no dedicated Qty column)The master sheet is one row per product, not per unit. Put the quantity in the Notes column (e.g., "Qty: 3") since the 33-column schema doesn't have a dedicated quantity column. Also include the extended price in Notes: "Qty: 3 · Ext: $17,085".
After saving:
✓ FF&E Schedule saved to [path or sheet]
[n] line items · [total qty] units · $[total] estimated
[n] items fully specified, [n] items need specification (TBD)
If there are TBD items, offer to research them:
Want me to research the TBD items? I can use /product-research to find specific products for:
- L-01: Flos pendant, $800-$1,200 budget
/product-research — research specific products to fill TBD slots/product-spec-bulk-fetch — pull full specs from product URLs/product-data-cleanup — normalize the schedule after assembly/product-enrich — auto-tag categories, colors, and materials/csv-to-sif — convert the schedule to SIF for dealer procurement