What is the CSV format?
CSV (comma-separated values) is a plain-text table: one record per line, fields separated by commas, and a field quoted with double quotes when it contains a comma, a quote or a line break. RFC 4180 records the common rules, but there is no strict standard, which is why delimiter, encoding and header conventions differ between tools.
How to use JMeter CSV Generator
- Define the columns one per line using name:type[:options].
- Pick the delimiter, quoting mode, line ending and whether to include a header row.
- Click "Generate", check the preview and warnings (for example how many cells needed quoting).
- Download the CSV and enter the printed settings in your CSV Data Set Config.
JMeter CSV Generator features
- RFC 4180 quoting that JMeter reads with "Allow quoted data?" enabled
- Comma, semicolon, tab or pipe delimiters with LF or CRLF line endings
- Header row on/off, optional UTF-8 BOM for Excel
- Quote-all and never-quote modes for picky consumers
- Up to 50,000 rows with a seed for reproducibility
- Matching CSV Data Set Config settings printed alongside the file
JMeter CSV Generator example
Values containing commas and quotes
Input:
id:sequence:1
note:constant:Hello, "quoted" value
Delimiter: , · Quoting: minimalOutput:
id,note
1,"Hello, ""quoted"" value"
2,"Hello, ""quoted"" value"
Allow quoted data?: true · Delimiter: , · Ignore first line: trueFrequently asked questions about JMeter CSV Generator
How does JMeter handle quotes in CSV?
With "Allow quoted data?" enabled, JMeter reads RFC 4180 quoting: fields containing the delimiter, quotes or line breaks are wrapped in double quotes and inner quotes are doubled.
Which delimiter should I use?
Comma is the default. Use tab or pipe when your values contain commas (addresses, JSON) and set the same delimiter in CSV Data Set Config.
Should I include a header row?
It keeps the file readable; set Ignore first line = true and list the variable names explicitly. Without a header, leave Variable names filled in and Ignore first line = false.
Why is the BOM option off by default?
Excel likes a UTF-8 BOM, but JMeter reads it as part of the first column unless the file encoding is set to UTF-8-BOM (JMeter 5.5+).
Is this data real?
No — it is synthetic test data generated locally in your browser.
Technical notes
Minimal quoting wraps a field only when it contains the delimiter, a double quote, a line break or leading/trailing whitespace, and doubles inner quotes. "Never quote" sanitises such characters instead, which is useful for consumers that do not understand quoting at all.
References
- RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) FilesThe commonly implemented CSV rules: comma separators, CRLF line ends, quoting of fields that contain commas, quotes or line breaks.
- Apache JMeter User's ManualHow to build, parameterise and run load tests with JMeter, and how to read its listeners and reports.