Skip to main content

Dummy CSV Generator

Print a comma-separated table with a header row. Use this when a spreadsheet or importer wants CSV, not a JSON array.

Rated 4.7 out of 5 based on 334 reviews

How to generate sample CSV

  1. Set how many data rows you want, from 1 to 200. The header is extra and always prints first.
  2. List column names with commas or new lines. Known names get typed fake values. Other names get short filler text.
  3. Generate. Save or copy the text as a .csv file. The first line is the header.
  4. Open it in a spreadsheet. Do not mail the addresses. They are not real inboxes.

Dummy CSV table

Header plus RFC-style quoted records

HeaderFirst line is the field list in order
QuotingFields with comma, quote, or newline are wrapped and quotes doubled
DelimiterComma. Not tab or semicolon
Known columnsid, name, email, city, age, status, score, first, last
Rows1 to 200 data lines under the header
PeopleInvented names, example.test emails

Header row, then data

CSV on this page always starts with a header. The header is your field list in the same order you typed. Data rows follow, one record per line. Rows means how many people (or objects) you want, not including the header. Five rows plus four fields prints five data lines under id,name,email,city.

Quotes when a field needs them

If a value contains a comma, a double quote, or a newline, the cell is wrapped in double quotes and inner quotes are doubled. That matches common RFC 4180-style CSV. Simple id and city values usually stay unquoted. Do not split the file on commas by hand if a name field ever includes a comma. Use a CSV parser or a spreadsheet.

CSV is not pretty JSON

This page does not print square brackets or braces. Numbers still appear as digits in the cell, but the file is text. There is no two-space indent because CSV has no indent. If your mock client expects an array of objects, use dummy JSON instead. Keep both field lists in sync if you generate the two formats for the same demo.

Same invented columns as the JSON page

Known field names match the JSON generator: id, name, email, city, age, status, score, first, last. Emails still use example.test. Names are still invented. Unknown column titles still get short filler, which is why quotes can appear. For a single column of people without a table, use dummy names. For paragraphs rather than cells, use lorem ipsum.

What this file is not

The delimiter is a comma, not a tab and not a semicolon. UTF-8 is whatever your browser copies. There is no BOM unless you add one later. The generator does not encode Excel formulas. Treat the download as a mock, not a customer export.

Dummy CSV questions

Does the file include a header?
Yes. The first line is the field list. Rows counts only the data lines after that.
When does a cell get quotes?
When the value contains a comma, a double quote, or a newline. Inner quotes are doubled.
Can I use a semicolon delimiter?
No. This page always uses commas. Convert later if a locale importer wants semicolons.
Is this the same data as dummy JSON?
Same field rules and invented values, different serialization. JSON is an array of objects. CSV is a header plus rows.
Are the people real?
No. Names are invented. Emails use example.test. Do not contact them.
How many data rows can I create?
From 1 to 200, plus the header line.