05 / Test Data / csv-test-data
CSV Test Data Generator
Define columns and generate CSV test data.
How to use
- 01Edit the starter columns (name, email, age, country): rename each column and choose its type from the dropdown.
- 02Press + Add column for more columns, or the ✕ button to remove one.
- 03Set the number of Rows (1 to 10,000).
- 04Choose a Delimiter (Comma, Semicolon, Tab or Pipe) and tick or untick Header row.
- 05Press Generate CSV.
- 06Copy the output or use Download .csv to save test-data.csv; Clear empties the output.
What is this tool?
The CSV Test Data Generator builds flat, spreadsheet-ready test files from columns you define. Each column gets a name and one of 15 types, including Name, Email, Integer, Decimal, UUID, Date, Boolean, URL and Job Title, and you choose the delimiter and whether to include a header row. All values are fictional and generated locally in your browser.
Column types and the values they produce
The 15 column types are Name, First Name, Last Name, Email, Integer, Decimal, Country, City, Company, Phone, UUID, Date, Boolean, URL and Job Title. Integers range from 1 to 10,000, except a column named age with the Integer type, which produces realistic ages from 18 to 80. Decimals have two decimal places, dates are written as YYYY-MM-DD, booleans as true or false, phones in the fictional +1-555 range and emails on example.com.
With the default columns and a header row, the first lines look like: name,email,age,country Maya Rossi,omar57@example.com,34,Japan
Columns are generated independently, so the email does not match the name in the same row.
Delimiters and quoting
Comma is the standard, but Semicolon suits spreadsheet apps in locales that use a comma as the decimal separator, Tab produces TSV-style data that pastes cleanly into a spreadsheet, and Pipe is common for database bulk loaders. Any value that contains the chosen delimiter, a double quote or a newline is wrapped in double quotes, and inner quotes are doubled, following the usual RFC 4180 convention. Column names in the header row are escaped the same way.
Rows are separated by a single newline (LF), and the download is always named test-data.csv regardless of the delimiter you pick.
Importing generated CSV into a database
Match your column names to the target table, generate with a header row, and load the file with your database's bulk import. In PostgreSQL, for example: COPY customers(name, email, age, country) FROM '/path/test-data.csv' WITH (FORMAT csv, HEADER true). If you chose Semicolon or Pipe, add DELIMITER ';' or DELIMITER '|'. MySQL's LOAD DATA INFILE works the same way with FIELDS TERMINATED BY and IGNORE 1 LINES to skip the header.
If a column has a unique constraint, prefer the UUID type for it, since names, emails and cities come from small lists and repeat across thousands of rows.
Common use cases
- Seeding a test database table through COPY or LOAD DATA
- Testing a CSV upload or bulk import feature with custom column names
- Checking how an importer handles semicolon, tab or pipe delimiters and missing header rows
- Producing spreadsheet data for QA sign-off or reporting demos
- Generating up to 10,000 rows to test import performance and pagination
FAQ
How many rows can I generate?
Up to 10,000 rows per run.
Can I use a semicolon or tab instead of a comma?
Yes. The Delimiter option supports Comma, Semicolon, Tab and Pipe.
Can I generate CSV without a header row?
Yes. Untick Header row and the output starts directly with data.
Are values with commas or quotes escaped?
Yes. Values containing the delimiter, a double quote or a newline are wrapped in double quotes, with inner quotes doubled.
Can the CSV contain nested data?
No. Each column holds a single flat value. For nested structures flattened into dot-notation columns, use the JSON Generator's CSV export.
Is my CSV uploaded anywhere?
No. The file is generated and downloaded entirely in your browser.