← All tools

Dummy Data Generator

Generate fake users as CSV, JSON or SQL INSERTs — up to 100,000 rows via Web Workers.

Business

Marketing

HR

Output headers: ID, Username, Email

Dirty Data (Practice)

Intentionally mess up a share of the generated rows so you can practice cleaning the data in Excel or Sheets.

Dirty Types

Enable this to generate fully-empty rows and id-colliding duplicates so the CSV Cleaner buttons can be tested.

Similar Tools

JSON / CSV Converter

Convert data both ways.

JSON Formatter & Validator

Pretty-print, minify & validate JSON.

Smart Text Analyzer

Count words, chars & case.

Built with privacy in mind. All processing happens entirely in your browser using open-source libraries.

What is the Dummy Data Generator?

A dummy data generator creates realistic-looking fake records for testing, demos and mockups. Pick the fields you need, choose a locale, and generate users as JSON, CSV or SQL INSERT statements without inventing a single record by hand.

Developers and QA teams constantly need sample data, and generating it in the browser keeps test data off any server. For large requests, a Web Worker produces up to 100,000 rows without freezing the page. Turn on Relational data to create linked users and orders tables, and use Dirty Data (Practice) mode to add realistic typos for cleaning exercises.

How to use the Dummy Data Generator?

  1. Choose the number of rows (up to 100,000) and a locale.
  2. Select the fields you want and the output format.
  3. Click Generate, preview the result and download the file.

Frequently Asked Questions (FAQ)

Can I generate related users and orders tables?

Yes. Tick Relational data (orders linked to generated users) and the generator adds an orders table (order_id, user_id, product, amount, order_date, status) whose user_id values reference the generated users, in CSV, JSON or SQL output.

Can it create messy data for data-cleaning practice?

Yes. The Dirty Data (Practice) section lets you set a Dirty Percentage (0/10/25/50%) and choose the Dirty Types — Missing Values, Typos, Number Typos, Case Errors and Extra Spaces — and optionally allow missing values in ID columns.

Is the Dummy Data Generator free?

Yes, free with no signup or limits.

How can it handle 100,000 rows without crashing?

Generation runs in a Web Worker, so the page stays responsive and memory is managed in chunks.

What formats are supported?

JSON, CSV and SQL INSERT statements, with PostgreSQL, MySQL and SQL Server dialects.