Test Data Generator

About the Test Data Generator

Builds realistic fake records for testing: you define columns (row number, UUID, full/first/last name, email, phone number, city, country, random numbers, random words), pick how many rows you want, and export as JSON, CSV, XML, HTML, SQL inserts, Python or JavaScript.

How to use it

1. Add the columns you need and pick a data type for each one, such as full name, email, phone number, city or UUID.
2. Enter how many rows to generate.
3. Choose the output format: JSON, CSV, XML, HTML, SQL, Python or JavaScript.
4. Click Generate Data, then copy the result or download it as a file.

Good for

• Seeding a local or staging database with believable users
• Load and performance tests that need thousands of unique rows
• Demo screens and screenshots without exposing real customer data
• Unit-test fixtures in the exact language format you need

Tip: Use synthetic data instead of copying production records. It keeps personal data out of test environments, which most privacy rules (including India's DPDP Act and the GDPR) expect.

Frequently asked questions

Is the generated data real?

No. Every value is randomly generated fake data, so you can use it in test and demo environments without exposing real people’s details.

Can I create SQL INSERT statements?

Yes. Choose SQL as the output format to get INSERT statements you can run against a local or staging database.

Is my data sent to a server?

No. The data is generated in your browser and is not uploaded or stored.

More free tools

• Random Password and Key GeneratorGenerate strong random passwords and keys with your choice of length and character sets, using your browser’s cryptographically secure random number generator.
• CSV, TSV, JSON and XML ConverterConvert data between CSV, TSV, JSON, XML and a single column of values in any direction, with automatic format detection and file upload.
• JavaScript Minifier and ValidatorCompress JavaScript with Terser for a smaller file, or validate code and see syntax errors with their line numbers.
• JSON Formatter and ValidatorBeautify and validate JSON, find the exact line of an error, and convert JavaScript object literals into strict JSON.
• SQL Formatter and BeautifierMake SQL queries readable or minify them to one line, for Standard SQL, MySQL, PostgreSQL and Transact-SQL.
• Diff Checker: Compare Two TextsCompare two blocks of text or two files and see what changed, line by line.
• Case ConverterChange text to UPPERCASE, lowercase or Title Case in one click.
• camelCase, PascalCase, snake_case and kebab-case ConverterTurn any phrase into programming naming styles as you type: camelCase, PascalCase, snake_case, kebab-case and Capitalized Case.
• YAML ValidatorCheck YAML files for syntax errors before they break a deployment, from Kubernetes manifests to GitHub Actions workflows.