Sif To CSV Agent Skill

Parse a SIF (Standard Interchange Format) input into a readable preview and optionally append canonical product rows to the project's CSV library. Use when asked to convert or inspect SIF dealer data. For the reverse direction use /as:csv-to-sif.

2k tokens

context cost

the whole folder, loaded on every use

files

instructions only

copies elsewhere

how many repositories repackaged it

302

stars on the repo

on the repository, not the skill itself

Install

one command, takes just this skill from the repository

npx skills add https://github.com/AlpacaLabsLLC/skills-for-architects --skill sif-to-csv

What comes with it

2 016 bytes besides the instruction

README.md

The instruction itself

16 sections, as written by the author

/as:sif-to-csv — SIF to CSV Converter

Converts a SIF input from a dealer or procurement system into a human-readable preview and canonical product rows. Translates field codes, expands options and attributes, calculates pricing, and computes totals.

When to Use

Received a SIF file from a dealer and need to review it as CSV data
Importing dealer pricing back into your FF&E schedule
Comparing a dealer quote (SIF) against your original specification
Loading dealer data into the project's product-library.csv

SIF Format Reference

SIF is a text-based key-value format. Each line is CODE=VALUE, terminated by CRLF. Products are separated by records starting with PN=.

Core fields

| 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 |

Pricing fields

| 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) |

Product detail fields

| 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 |

Link fields

| 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 |

Alternate manufacturer codes

| System | Code | Purpose |

|--------|------|---------|

| Standard | MC | 3-5 char manufacturer code |

| Cyncly | MG | Manufacturer code (replaces MC) |

| CET | EC | Manufacturer code (alt) |

Step 1: Accept Input

SIF file:

/as:sif-to-csv ./dealer-quote.sif

Pasted SIF content:

/as: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

Step 2: Parse SIF

Read the file and parse each record:

Header fields: Extract SF and ST
Records: Split on PN= boundaries
For each record, extract all fields
Detect manufacturer code variant: look for MC, MG, or EC — normalize to brand name
Detect price variant: look for PL, P1, I1 — use whichever is present
Detect quantity variant: look for QT or NT
Calculate derived values:
Sell Price: PL - (PL × S- × 0.01) if discount present
Net Price: PL × (P% × 0.01) if purchase % present
Extended List: PL × QT
Extended Sell: Sell Price × QT

Manufacturer code expansion

| 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.

Options and attributes

Multiple ON/OD pairs → concatenate into "Options" column, separated by |
Multiple AN/AD pairs → concatenate into "Attributes" column, separated by |
If AN=DIM, parse dimension string back into W/D/H if possible

Step 3: Present Preview

## 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%)

Step 4: Output

Show the parsed table in Markdown. For persistence, write only to the nearest project-root product-library.csv. Read ../../schema/product-schema.md, ../../schema/csv-conventions.md, and ../../schema/sif-crosswalk.md. Map by these named fields:

Link ← ProductURL; Product Name ← PD; SKU ← PN; Brand ← expanded MC
Category ← GC or PRC; dimensions ← AD where AN=DIM; Weight ← WT
List Price ← PL/P1/I1; Sale Price ← calculated sell price; Selected Color/Finish ← OD
Image URL ← ImageURL; Tags ← TG; Status ← quoted; Source ← sif-to-csv
Notes ← From SIF: {ST}. Discount: {S-}%. Qty: {QT} · Ext: ${ext_sell}

Preview the complete batch's row mappings, totals, warnings, and target path, then use the single confirmation gate. After approval, serialize all complete rows as one JSON array and invoke python3 "${CLAUDE_PLUGIN_ROOT}/skills/master-schedule/scripts/csv-library.py" append product --project <project-root> --row-json <batch.json> exactly once. The helper validates the complete batch and library before one atomic replacement; never loop per row.

Step 5: Summary

✓ 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: ./product-library.csv

Pairs With

/as:csv-to-sif — round-trip: create SIF, send to dealer, parse their quote back
/as:product-data-cleanup — normalize the parsed data
/as:product-data-import — reformulate dealer data into a formatted schedule
/as:product-enrich — add categories and tags to imported products

Other skills for the same job

different authors, same section of the catalogue

XLSX

by anthropics

vendor ×15

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like \"the xlsx in my downloads\") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.

Query openFDA API for drugs, devices, adverse events, recalls, regulatory submissions (510k, PMA), substance identification (UNII), for FDA regulatory data analysis and safety research.

MATLAB and GNU Octave numerical computing for matrix operations, data analysis, visualization, and scientific computing. Use when writing MATLAB/Octave scripts for linear algebra, signal processing, image processing, differential equations, optimization, statistics, or creating scientific visualizations. Also use when the user needs help with MATLAB syntax, functions, or wants to convert between MATLAB and Python code. Scripts can be executed with MATLAB or the open-source GNU Octave interpreter.

UMAP dimensionality reduction. Fast nonlinear manifold learning for 2D/3D visualization, clustering preprocessing (HDBSCAN), supervised/parametric UMAP, for high-dimensional data.

Creating interactive data visualisations using d3.js. This skill should be used when creating custom charts, graphs, network diagrams, geographic visualisations, or any complex SVG-based data visualisation that requires fine-grained control over visual elements, transitions, or interactions. Use this for bespoke visualisations beyond standard charting libraries, whether in React, Vue, Svelte, vanilla JavaScript, or any other environment.

Access AlphaFold 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.

7k tokens

How to use it

Copy the folder

Take alpacalabsllc/sif-to-csv from the repository into ~/.claude/skills for personal use, or into .claude/skills inside a project.

Check the name does not clash

The agent identifies a skill by the name field in its header. Two skills with the same name cannot sit side by side — one of them will be ignored.