Separate controlled import data from spreadsheet text.
This synthetic export keeps all 5 records. Four formula-like strings receive an apostrophe prefix in a separate spreadsheet-safe copy. The numeric negative string -12.50 stays unchanged. The normalized export retains the original values for controlled software import.
Demonstration work for Clean Sheet Sprint; no client result is claimed. The original file and issue log document exactly what changed.
0
23
CSV record counts should follow records, not physical lines.
In this synthetic support export, an embedded newline and comma survive CSV round-tripping. 5 input records reconcile to 4 retained records and 1 wholly blank record omitted. Internal spacing stays intact. An invalid email string is flagged rather than guessed; the email check tests syntax only.
Demonstration work for Clean Sheet Sprint; no client result is claimed. Source copies, issue logs and count checks are part of the workflow.
0
31
A repeated SKU is not automatically a duplicate.
This synthetic inventory export contains the same SKU in different locations. All 6 records are retained; repeated keys and a missing quantity are logged for review. Leading-zero IDs remain text in the CSV output, and only outer whitespace is trimmed. Import ID columns as text when using spreadsheet software.
Demonstration work for Clean Sheet Sprint; no client result is claimed. The service scope is on my profile.
0
33
Clean Sheet Sprint: a synthetic order-export cleanup.
9 input records reconcile to 7 retained records, 1 exact duplicate removed by an explicit rule, and 1 blank record omitted. Conflicting IDs, invalid email strings and missing required fields stay flagged for review. The original file is preserved with a SHA-256 fingerprint.
This is a demonstration, not a paid client result. My scoped CSV cleanup service starts at $149: https://contra.com/s/gErrPoR3-clean-one-csv-export-with-an-audit-trail
0
54