Skip to main content

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.

Dataset

Output

This page focuses on XLSX output. Use templates and fields below, then Generate and Download.

Quick Options (Rows):
Preset tables
Edited

    Field customizations apply for this session only and are not saved after reload.

    Configuration changed since the last generate. Regenerate before downloading the updated dataset.
    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).

    Also updates available contact fields
    Field separator
    Output size
    Max 25
    Max 10 · ZIP when > 1
    Max 10

    Quick use cases

    Create spreadsheet fixtures for import and reporting tests. Download E-commerce workbooks with one sheet per related table. Generate multiple Custom workbooks as a ZIP when Files > 1.

    Common generator issues

    Column types change when the workbook is opened or imported. Headers do not match the expected spreadsheet template. A workflow expects one sheet while a preset workbook contains several.

    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

    Custom: up to 5,000 rows per sheet, 25 columns, 10 sheets per workbook, 10 workbooks (ZIP when Files > 1). Presets: one workbook with one sheet per table; row counts follow template scale rules. Larger workbooks need more browser memory and generation time.

    Related tools

    Sample output structure

    Sheet: Data
    id | name | email
    1 | John | john@example.com

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