Is the generated data real or safe to use?

All values are randomly generated sample data for software testing purposes only. Names, emails, phone numbers, addresses, and credit card numbers are entirely fictional. Generated credit card numbers pass the Luhn check (used for format validation in test suites) but are not real financial instruments.

How many rows can I generate?

You can generate up to 10,000 rows. Large datasets (5,000+) use chunked background generation to keep the interface responsive. A progress indicator shows generation status.

Does any data leave my browser?

No. All data generation uses JavaScript running entirely in your browser. No data is sent to any server. Your schema and generated data never leave your device.

Can I save my schema for later?

Yes. Click 'Save Schema' to store your current field configuration in your browser's localStorage. You can save up to 10 schemas by name and reload them at any time. You can also export/import schemas as JSON files to share with colleagues.

What SQL database dialect does SQL export use?

The SQL export generates standard ANSI SQL INSERT statements compatible with MySQL, PostgreSQL, SQLite, and most other relational databases. String values are single-quote escaped; NULL values are emitted as SQL NULL.

Test Data Generator — Free Fake JSON, CSV & SQL Data

⚠️ All values are randomly generated sample data for software testing purposes only. Names, emails, addresses, and card numbers are entirely fictional. Credit card numbers pass the Luhn format check but are not real financial instruments and must not be used for transactions.

Quick Presets

Schema Builder

For the best experience building schemas, open this tool on a tablet or desktop. On mobile, use the Quick Presets above for instant data generation.

	Field Name	Data Type	Options	Null %

Saved schemas:

Generate & Export

Rows

Locale

Generating…

Why Generate Test Data?

Real production data is rarely available for development, testing, or demonstrations. Using real user data in dev environments raises serious privacy concerns and violates regulations like GDPR and HIPAA. Synthetic test data lets you seed databases, write integration tests, populate UI mockups, and demo software — without exposing real people.

Data Types Reference

UUID v4 — Randomly generated 128-bit identifier in standard 8-4-4-4-12 hex format. Suitable as a primary key in any database. Email — Fictional addresses using randomly combined first/last name fragments with configurable domain suffixes (gmail.com, example.com, etc.). Phone — Locale-aware format: US uses (NXX) NXX-XXXX, UK uses 07XXX XXXXXX, international formats follow local conventions. Credit Card — Luhn-algorithm-valid numbers with correct BIN prefixes for Visa (4), Mastercard (5), and Amex (3). Not real cards — safe for testing payment form validation.

Export Formats

JSON — Array of objects, one per row. Pretty-print or minified. Directly parseable by JavaScript, Python, and most languages. CSV — Comma or tab delimited. Compatible with Excel, Google Sheets, pandas, and database import tools. String fields are quoted if they contain delimiters. SQL INSERT — Standard ANSI INSERT statements compatible with MySQL, PostgreSQL, and SQLite. NULL values are emitted as SQL NULL. String values are single-quote escaped.

Frequently Asked Questions

All values are randomly generated sample data for software testing purposes only. Names, emails, phone numbers, addresses, and credit card numbers are entirely fictional. Generated credit card numbers pass the Luhn check but are not real financial instruments.
You can generate up to 10,000 rows. Large datasets (5,000+) use chunked background generation to keep the interface responsive. A progress indicator shows generation status.
No. All data generation uses JavaScript running entirely in your browser. No data is sent to any server. Your schema and generated data never leave your device.
Yes. Click 'Save Schema' to store your current field configuration in your browser's localStorage. You can save up to 10 schemas by name and reload them at any time. You can also export/import schemas as JSON files to share with colleagues.
The SQL export generates standard ANSI SQL INSERT statements compatible with MySQL, PostgreSQL, SQLite, and most other relational databases. String values are single-quote escaped; NULL values are emitted as SQL NULL.