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.

Test Phone Number Generator

Test Email Generator

Test Name Generator

Test Username Generator

Test Company Name Generator

Test Postal Code Generator

JSON Test Data Generator

Test Date Generator

Test Numeric Generator

SQL Test Data Generator

Explore other tool categories

Minify

Shrink code and assets for production — minify JavaScript, CSS, HTML, JSON and XML before gzip or CDN deploy.

Beautify

Make code readable with consistent indentation — beautify JavaScript, CSS, TypeScript, SCSS, LESS, Markdown, GraphQL, SQL, YAML and more in your browser.

Unminify

Expand minified or compressed code — unminify JavaScript, CSS, TypeScript, SCSS, LESS, SQL, YAML and other formats when debugging or reviewing.

Conversion

Transform data between JSON, YAML, XML and CSV locally — no server uploads.

CSS preprocessors

Compile SCSS or LESS to standard CSS in the browser — pair with beautify or minify for a full stylesheet workflow.

JSON Tools

Validate, format, diff and explore JSON payloads — complementary to minifiers and converters.

SVG Tools

Preview, optimize with SVGO, export Data URI, resize, beautify, convert to JSX and validate SVG — all in your browser.

DevOps & Infra

Terraform HCL format/validate/minify, Dockerfile format & lint, Docker Compose and .env validation.

CI/CD

GitHub Actions and GitLab CI — format YAML and check workflow/job structure in your browser.

Logs & observability

Line-oriented JSON/NDJSON and Nginx/Apache access logs — format, filter, validate, and CSV/TSV.

Kubernetes

Multi-doc manifests, structural validate, Ingress/Deployment starters, and Helm values formatting.

Networking / IP

CIDR, subnets, and IPv4/IPv6 helpers — in your browser.

Security & tokens

JWKS, X.509 certificates, and secrets scan — browser-local.

API & schemas

OpenAPI tools to format, validate, and lint your specs.

Encoding

Encode or decode Base64, URL components and HTML entities — client-side only.

Developer utilities

Timestamps, UUID, ULID, Nanoid, cron, passwords, regex, slugify, number bases, case, text diff, and chmod — all client-side.

Text & Markdown

Count words, build Markdown TOCs, and clean line lists — all in your browser.

AI & LLM

Token counting, pricing estimates, and context-window fit — 100% browser-local.

Serialization

Serialize and deserialize PHP data structures beside JSON workflows.