Excel Dummy Data Generator
Generate Excel (XLSX) dummy data for spreadsheet testing. Custom mode builds flat sheets; E-commerce and other multi-table presets use one sheet per table.
This page focuses on XLSX output. Use templates and fields below, then Generate and Download.
Field customizations apply for this session only and are not saved after reload.
| Field name | Type | Options |
|---|
| Field name | Type | Options |
|---|
The Columns control matches the field list: increasing it appends columns; decreasing it removes trailing columns (you’ll be asked to confirm if you edited fields).
Quick use cases
Common generator issues
Generator feature notes
- Custom XLSX: the primary button downloads immediately (Generate acts as Download).
- Preset XLSX: Generate builds the relational dataset, then Download saves a multi-sheet workbook.
- Sheet names match table names for presets (customers, products, orders, order_items).
Feature boundaries
Related tools
Sample output structure
Sheet: Data
id | name | email
1 | John | john@example.comDataset generator FAQ
Can I generate multiple XLSX sheets in Custom mode?
Yes. Set Sheets to generate up to 10 sheets of the same Custom schema in each workbook.
How do E-commerce Excel downloads work?
After Generate, Download produces one XLSX file with a sheet per table. Totals and foreign keys match the in-memory dataset.
Can I generate multiple XLSX files?
In Custom mode, Files > 1 downloads a ZIP of workbooks. Presets always download a single multi-sheet workbook.