CSV Test Data Generator — Dummy Rows for Spreadsheets and Fixtures

Generate dummy CSV rows for spreadsheets, importers, and fixtures. Preset a table, rename columns, copy CSV. FR/DE Excel: semicolon and UTF-8 BOM on download. Reserved example emails and phones — not a converter, not a live mock API, and not an identity pack.

Loading…
CSV test data — developer notes
Dummy CSV rows for spreadsheets, importers, and fixtures. Editable columns, Excel-aware delimiter and UTF-8 BOM on download — not a JSON-to-CSV converter and not an identity pack.

How generation works

Pick a preset, country, quantity (1–100), delimiter, and whether the downloaded file should include a UTF-8 BOM. Edit column names and types in the schema table, or paste a header row. Changing any option except the BOM checkbox refreshes the CSV immediately. Copy all copies the preview (no BOM). Download adds a BOM and CRLF when UTF-8 BOM is on.

Options

Preset
Seeds the column list: user (id, names, email, phone, username), company (id, company_name, email), or blank (single uuid id). Changing preset replaces custom columns.
Country
Drives name locale, company suffix style, reserved phone ranges, and postal masks in the same row. Does not change the CSV delimiter.
Quantity (1–100)
How many data rows under the header. Capped at 100 for fixture jobs.
Delimiter
Join character between fields: comma, semicolon, tab, or pipe. Page locale fr/de defaults to semicolon for Excel; otherwise comma. Tab downloads as .tsv. Country does not rewrite this.
UTF-8 BOM (file download)
When on, the downloaded file starts with a UTF-8 BOM and uses CRLF — what Excel on Windows expects for accented FR/DE names. Copy all and the preview never include a BOM.
Schema columns
Editable grid: column name (CSV header) and type. Up to 12 columns. Paste a header such as id,email,phone to replace the list. Same-row name, email, and username correlation when name columns exist.

Examples

User preset for Excel FR

Settings

preset=user, delimiter=semicolon, count=2

Sample output

id;first_name;last_name;email;phone;username

Tab delimiter (TSV)

Settings

delimiter=tab → download test-csv-data.tsv

Sample output

id\tfirst_name\tlast_name\t…

Related tools

Need a JSON array instead? Use the JSON test data generator. Single-field columns: phone, email, name, username, company, postal code, date, numeric. Already have a file to convert? JSON to CSV, CSV to JSON, or CSV to TSV.

CSV test data FAQ

Spreadsheets, Excel, and what this tool is not

Is this a JSON to CSV converter?

No. This page seeds dummy rows as CSV. To convert a file you already have, use JSON to CSV, CSV to JSON, or CSV to TSV.

Why does French or German Excel collapse my columns?

Excel on FR/DE Windows expects a semicolon list separator and a UTF-8 BOM on the file. This tool defaults both from the page locale. Copy all never includes a BOM; turn UTF-8 BOM on for download.

Can I download .xlsx or 1000 rows?

Not in v1. Output is CSV or TSV (tab delimiter), quantity 1–100, 100% in the browser.

Do emails use gmail.com or real inboxes?

No. Emails use IANA-reserved domains such as example.com — never consumer mailbox providers. Phones stay in reserved test ranges.

Can I get typed, dialect-quoted SQL INSERT?

Not from this page’s SQL download (every cell is a quoted string, no dialect). Use the SQL test data generator for dummy INSERT rows with Postgres, MySQL, or SQLite quoting.

Test Data

Synthetic field values for fixtures and DB seed — reserved-range phone numbers first.

Explore other tool categories