Sample Data Generator
Choose your columns from twenty-seven field types — names, emails, addresses, prices, dates, statuses and more — set the row count, and get the data in CSV, TSV, JSON, XML, YAML, SQL INSERT statements or an HTML table. Values that belong together stay consistent within a row: the email address is built from that row own name, so the result reads like a real table rather than unrelated columns side by side. Everything is generated in your browser; nothing is uploaded and no result is recorded anywhere.
How it works
Choose the columns you need and how many rows, and the data appears below in whichever format you are pasting it into. Values that belong together stay consistent within a row — the email address is built from that row’s own name, so the result reads like a real table rather than unrelated columns side by side.
Everything generated here is fictional and deliberately unreachable: email addresses use the domains reserved for documentation, phone numbers come from the range set aside for drama and never allocated to anyone, and IP addresses come from the documentation block. Nothing here maps to a real person, and it should not be used as though it did.
Generation runs entirely in your browser.
Values are quoted only where they have to be — one containing a comma, a quotation mark or a line break. Quoting everything is also valid CSV but makes the file larger and harder to read.
Frequently asked questions
Is any of this data real?
None of it. Email addresses use the domains reserved for documentation, phone numbers come from the range set aside for use in fiction and never allocated to anyone, and IP addresses come from the documentation block. Nothing generated here maps to a real person and it must not be used as though it did.
Why does the email match the name in the same row?
Because a table where the email has nothing to do with the name column is obviously synthetic the moment anyone reads it. Keeping derived values consistent within a row is what makes generated data usable for a demo or a screenshot.
Which format should I pick?
CSV for spreadsheets and most importers, JSON for APIs and fixtures, SQL INSERT statements for seeding a database directly, and an HTML table for dropping into a page. All produce the same underlying rows.
How does the CSV handle commas and quotes inside values?
A value is quoted only when it contains the delimiter, a quotation mark or a line break, and embedded quotes are doubled. Quoting everything is also valid CSV but makes the file larger and harder to read.
How many rows can I generate?
Up to 10,000 rows and 30 columns. Beyond that a browser page stops being the right tool, and a script running against your own schema will serve you better.
Related tools
Random CSV Generator
Generate a CSV file of realistic test rows with the columns you choose, correctly quoted and escaped.
Random Data from a Regex
Run a regular expression backwards: generate strings that match the pattern instead of testing them.
CSV to JSON Converter
This CSV to JSON converter turns CSV rows into a JSON array, keyed automatically by the header row.