# CSV Handoff Check 0.2.2-rc2 — exception export schema

One row per exception (changed, only-source, only-target); identical records omitted. Status filter affects UI only, never export scope. Both presence flags distinguish absent records from empty cell values. No joined-pipe fields or chronological before/after headings.

First six columns, in exact order:
key,status,source_key_header,target_key_header,source_record_present,target_record_present

Then, for EACH displayed comparison pair N, in pair order, four separate columns:
source_header_N,target_header_N,source_value_N,target_value_N

The metadata cells contain the actual source and target column labels. Keys are excluded from comparison pairs. For 2 pairs there are 14 columns; for 49 pairs, 202 columns. Even a zero-exception CSV retains its complete schema.

Demo exact header:
key,status,source_key_header,target_key_header,source_record_present,target_record_present,source_header_1,target_header_1,source_value_1,target_value_1,source_header_2,target_header_2,source_value_2,target_value_2

Demo: sku→sku keys, name→name and price→price pairs. Source and target each have 2 records: 1 identical, 1 changed, 0 only-source, 0 only-target. Only Beta→Beta revised changes; price remains 20→20. Alpha is not compared to 10. The local first-record preview is file-local, not a matched-key preview. Differing header names require explicit intentional-mapping confirmation.

CSV uses quoted cells, doubled internal quotes and CRLF. Potential formula prefixes receive an apostrophe on every exported cell, including metadata; this changes text and is not universal spreadsheet security, lossless migration import or a leading-zero guarantee. Excel/LibreOffice execution is unverified.

Capacity example: real synthetic RC2 output from 5000 records × 50 columns on each side; key id, f1→f1 through f49→f49. All 5000 are changed. Summary covers all records; detail includes only 50 exceptions, omits 4950. Detail is NOT the full report of all exception values. The CSV includes all 5000 exceptions for this particular short-label shape; no guarantee for other accepted input shapes.