Excel Data Validation — Synthetic Data Demo

Self-initiated demonstration • Synthetic data • AI-assisted

Prepared two Excel workbooks containing 300 synthetic records across eight fields: record ID, item, category, status, due date, quantity, unit cost and notes. The featured image shows a real preview of the input workbook.

The dataset includes blank values, zero quantities, long notes, accented characters and punctuation to make edge cases explicit. Dates and field order follow a documented mapping, and source workbook/row references are preserved for traceability.

Validation independently checked all 2,400 source values and the full 300-record ordering. A separate HTML report preview of 12 records was parsed and compared against the source values.

This example demonstrates structured spreadsheet preparation and repeatable data checks. It is a new portfolio demonstration, not past client work. The broader Excel-to-Word converter is a prototype: document values passed read-back checks, while Word page-layout review remains pending.