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.