Skip to main content

CSV Dummy Data Generator

Generate CSV dummy data with custom fields or Users, Products and E-commerce presets. Choose delimiters, scale and download fixtures for spreadsheet imports and ETL checks.

Dataset

Output

This page focuses on CSV 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 testing. Test ETL pipelines with controlled rows and columns. Export linked E-commerce tables as a ZIP of CSV files.

    Common generator issues

    The selected delimiter does not match the importer settings. Duplicate or empty field names are blocked before generation. Headers or row lengths do not match the expected schema.

    Generator feature notes

    • Custom CSV is one flat table with a header row. Preset CSV with multiple tables downloads as a ZIP (one CSV per table).
    • Generate builds the dataset; Download saves it (or a ZIP). Changing format after a preset Generate re-exports the same records.
    • Optional seed makes Users, Products and E-commerce runs reproducible.
    • Field names must be unique and non-empty in Custom mode.

    Feature boundaries

    Custom mode: up to 5,000 rows per file, 25 columns, 10 files (ZIP when Files > 1). E-commerce: customer scale up to 5,000; products/orders/items are derived from that scale. Large outputs may take longer to generate and display in the preview.

    Related tools

    After generating CSV fixtures, run CSV Validator to catch delimiter and row-shape issues before import.

    Need API-ready fixtures? Convert via CSV to JSON.

    For databases, try CSV to SQL.

    For spreadsheets, convert with CSV to XLSX.

    Also available: CSV to XML and

    CSV to YAML.

    Sample output structure

    id,name,email
1,John,john@example.com

    Dataset generator FAQ

    Can I choose a custom CSV delimiter?

    Yes. Choose a preset such as comma, semicolon, colon, tab, space, or pipe, or enter a custom separator.

    How do multi-file and relational CSV downloads work?

    In Custom mode, Files > 1 downloads a ZIP of independent CSV files. For E-commerce (and any multi-table preset), Download packs one CSV per table into a single ZIP so foreign keys stay intact.

    What are dataset templates?

    Custom lets you define columns. Users and Products are single-table presets. E-commerce generates linked customers, products, orders and order items with matching totals, foreign keys and chronological dates. Payments and arbitrary schemas are not included.

    What does the seed do?

    For preset templates, the same seed and scale reproduce the same rows. Custom mode does not use the seed control.