Menu
Convert a SIF (Standard Interchange Format) file to a clean, readable CSV or Google Sheet.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Look up ACRIS property transaction records for any NYC property — deeds, mortgages, satisfactions, liens, and ownership history. Use when the user asks who owns a building, when it last sold or for how much, or whether there are mortgages or liens against it. NYC only; for permits or violations use the DOB skills.
Look up Board of Standards and Appeals (BSA) variances and special permits for any NYC property. Use when checking whether a lot carries zoning relief — variances, special permits, appeals — that modifies its as-of-right envelope. NYC only; for base zoning controls use /zoning-analysis-nyc.
Look up DOB permit and job filing history for any NYC building — new-building, alteration, and demolition filings with status and dates. Use when the user asks what work was filed or permitted at an address, or to gauge renovation history during due diligence. NYC only; for open violations use /nyc-dob-violations.
Look up open and resolved DOB and ECB violations for any NYC building, with class, status, and penalty detail. Use when the user asks whether a building has violations, stop-work orders, or outstanding ECB penalties. NYC only; for housing-code violations use /nyc-hpd.
Look up HPD violations, complaints, and building registration for residential buildings.
Check if a NYC building is landmarked or in a historic district using LPC data.
| name | sif-to-csv |
| description | Convert a SIF (Standard Interchange Format) file to a clean, readable CSV or Google Sheet. |
| allowed-tools | ["Read","Write","Edit","Bash","Glob","Grep","AskUserQuestion","mcp__google-sheets__get_sheet_data","mcp__google-sheets__update_cells","mcp__google-sheets__list_sheets"] |
Converts a SIF (Standard Interchange Format) file from a dealer or procurement system into a clean, human-readable CSV or Google Sheet. Translates field codes to column headers, expands options and attributes, calculates pricing, and computes totals.
SIF is a text-based key-value format. Each line is CODE=VALUE, terminated by CRLF. Products are separated by records starting with PN=.
| Code | Name | Description |
|---|---|---|
SF | Specification File | Project reference (header) |
ST | Specification Title | Display title (header) |
PN | Product Number | SKU — starts a new record |
PD | Product Description | Product name |
MC | Manufacturer Code | 3-5 char code |
MN | Manufacturer Name | Full name |
QT | Quantity | Integer |
NT | Quantity (alt) | Some systems use NT instead of QT |
GC | Category / Group Code | Product category |
G0 | Vendor / Group ID | Vendor identifier |
| Code | Name | Description |
|---|---|---|
PL | List Price | Unit list price |
P1-P5 | Price Tiers | Alternate price tiers |
I1 | Unit List Price (Cyncly) | Cyncly Worksheet |
I2 | Purchase Price (Cyncly) | Cyncly Worksheet |
S- / S% | Sell Discount % | Sell = PL - (PL × S- × 0.01) |
P% / B% | Purchase/Buy % | Cost = PL × (P% × 0.01) |
| Code | Name | Description |
|---|---|---|
TG | Side Mark / Tag | Room, area, or project tag |
ON / OD | Option | Number + description pair |
AN / AD | Attribute | Number + description pair |
WT | Weight | Product weight |
VO | Volume | Product volume |
PRC | Product Category (Cyncly) | Cyncly category |
| Code | Name | Description |
|---|---|---|
ProductURL | Product Page URL | Link to product page |
ImageURL | Product Image URL | Link to product image |
PV | Picture Path | Local file path |
| System | Code | Purpose |
|---|---|---|
| Standard | MC | 3-5 char manufacturer code |
| Cyncly | MG | Manufacturer code (replaces MC) |
| CET | EC | Manufacturer code (alt) |
SIF file:
/sif-to-csv ~/Documents/project/dealer-quote.sif
Pasted SIF content:
/sif-to-csv
SF=Project Alpha
ST=Dealer Quote - March 2026
PN=670
PD=Eames Lounge Chair and Ottoman
MC=HMI
QT=3
PL=5695.00
S-=42
TG=Executive Lounge
OD=Santos Palisander / Black MCL Leather
Read the file and parse each record:
SF and STPN= boundariesPL - (PL × S- × 0.01) if discount presentPL × (P% × 0.01) if purchase % presentPL × QTSell Price × QT| MC | Brand | MC | Brand |
|---|---|---|---|
| HMI | Herman Miller | BLU | Blu Dot |
| MKN | MillerKnoll | DWR | Design Within Reach |
| KNL | Knoll | FRH | Fritz Hansen |
| STC | Steelcase | VIT | Vitra |
| HAW | Haworth | ARP | Arper |
| TEK | Teknion | FLS | Flos |
| HUM | Humanscale | LPO | Louis Poulsen |
| KIM | Kimball | ART | Artemide |
| OFS | OFS | HBF | HBF |
| GEI | Geiger | BRN | Bernhardt |
For unknown codes, keep as-is and flag.
ON/OD pairs → concatenate into "Options" column, separated by |AN/AD pairs → concatenate into "Attributes" column, separated by |AN=DIM, parse dimension string back into W/D/H if possible## SIF Import: Project Alpha — Dealer Quote March 2026
3 records parsed from dealer-quote.sif
| # | SKU | Product | Brand | Qty | List $ | Disc % | Sell $ | Ext Sell | Options | Tag |
|---|-----|---------|-------|-----|--------|--------|--------|----------|---------|-----|
| 1 | 670 | Eames Lounge Chair | Herman Miller | 3 | $5,695 | 42% | $3,303 | $9,909 | Palisander/Black | Exec Lounge |
| 2 | 164-500 | Saarinen Table 54" | Knoll | 1 | $4,750 | 38% | $2,945 | $2,945 | Arabescato/White | Dining |
| 3 | 462-CG | Gesture Chair | Steelcase | 8 | $1,189 | 45% | $654 | $5,232 | Cogent/Licorice | Open Office |
**Totals:**
- List: $22,147 · Sell: $18,086 · Savings: $4,061 (18.3%)
Ask the user for output format:
Save as {input-name}-parsed.csv:
Item #, SKU, Product, Brand, Qty, List Price, Discount %, Sell Price, Ext List, Ext Sell, Category, Weight, Options, Attributes, Tag, Product URL, Image URL, MC Code
Write to the 33-column schema (defined in ../../schema/product-schema.md, CRUD patterns in ../../schema/sheet-conventions.md):
See ../../schema/sif-crosswalk.md for the full column-to-SIF mapping. Key fields:
Output the table in conversation.
✓ Parsed dealer-quote.sif
Specification: Project Alpha — Dealer Quote March 2026
3 records · 12 units
Total list: $22,147 · Total sell: $18,086 (18.3% avg discount)
Manufacturers: HMI (1), KNL (1), STC (1)
Saved to: ~/Documents/project/dealer-quote-parsed.csv
/csv-to-sif — round-trip: create SIF, send to dealer, parse their quote back/product-data-cleanup — normalize the parsed data/product-data-import — reformulate dealer data into a formatted schedule/product-enrich — add categories and tags to imported products