Sample data tools

Sample CSV Generator

Generate CSV-safe synthetic records for import testing.

Sample CSV Generator: Make a compact CSV fixture for testing column mapping and row import. Sample CSV Generator outputs a header and synthetic id, label, value and active fields. It helps establish a basic import case before you add malformed rows or special characters that exercise your parser’s failure paths. Runs 100% locally in your browser with zero server file uploads.

Category: Developer tools
Runs: In your browser
Cost: Free · no sign-up
Availability: Ready to use

Sample CSV workbenchLocal processing

Runs entirely in your browser

Fictional result

Waiting

Your test-only result will appear here.

Fictional test fixtures only. Do not use these generated identities, addresses, or IDs as real records.

Header plus records: an exact example

For n requested records, emitted record count including the header is n + 1. Field order is id, label, value, active; each value follows the same position rule as the JSON fixture. With Rows = 1 and the first label drawn, the exact output is id,label,value,active\nCSV-TEST-0001,fixture-alpha,1,true. That is 1 + 1 = 2 lines and four fields per record. LF separates them and there is no final LF. Choosing a different label changes the second cell while leaving the row identifier and value tied to its position.

CSV conventions and extending a fixture

RFC 4180 (https://www.rfc-editor.org/rfc/rfc4180) describes comma delimiters, doubled quotes and CRLF records. This generator uses LF, so check whether your importer accepts it or requires conversion. Quoting handles CSV syntax but does not prevent spreadsheet formula execution in arbitrary text you add later. If extending the columns with contacts or network values, use example.com under RFC 2606 (https://www.rfc-editor.org/rfc/rfc2606) and documentation IPv4 ranges under RFC 5737 (https://www.rfc-editor.org/rfc/rfc5737), rather than real destinations. These extra fields are absent from the generated file; keep any consuming test isolated from live services. Preview a saved or edited fixture in the CSV viewer to check its columns.

How to use it

Choose a whole row count from 1 to 100.
Generate a synthetic batch in your browser.
Copy or download the fixture and save it for repeatable tests.

Privacy & limitations

Generation stays on this device. The records are fictional test fixtures; review and isolate the application that consumes them.

Related tools

Frequently asked questions

Why does five requested rows give six lines?

Rows counts data records. One header line is added, so the built-in simple fixture has n + 1 physical lines for n requested records. It has no trailing newline. The row count accepts whole numbers from 1 to 100; generate an empty-import case yourself.

Does CSV preserve the number and boolean types?

CSV supplies text fields without a type schema. The value cell is printed as 1 and active as true, but your importer must decide how to convert them. Assert those conversions explicitly rather than relying on a spreadsheet’s inferred types. IDs should remain strings so their TEST prefixes survive.

Will the generated rows exercise quotes and embedded commas?

The current labels are plain ASCII strings without commas, quotes or embedded newlines. The serializer can quote those characters, but this fixed dataset will not create them for you. Add a label containing a comma, a doubled quote case and a multiline field to test your reader properly.

Free tool · runs in your browser · no account required