Test Data Generator

Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.

Quick answer: Create realistic fake data for testing and demos.

Related: Mock Data Generator · Fake Data Generator · Fake Database for Testing · Test Data Guides and Free Generators

How to use the Test Data Generator

Create realistic fake data for testing and demos.

The Data Generator creates realistic fake data: names, emails, phone numbers, addresses, dates, prices and more. Pick a preset or build your own columns, choose up to 500,000 rows, and download CSV, JSON, Parquet or Excel. Developers and testers use it to fill demos, load-test apps and avoid copying real customer data into test systems.

1. Choose a dataset
2. Edit the columns
3. Set rows and generate

Tips

• Up to 500,000 rows – type any number you like.
• “Empty %” leaves some values blank to test missing data.
• Pattern: # = digit, ? = letter, * = either (e.g. ORD-#####).

Example

Input: id, name, email, signup_date

Output: 1,000 rows of realistic test data

Browse by topic

• Parquet Guides and Free Parquet Tools
• CSV Guides and Free CSV Tools
• JSON Guides and Free JSON Tools
• Excel Guides and Free Excel Tools
• Data Privacy Guides and Free Tools
• Test Data Guides and Free Generators
• Data Cleaning Guides and Free Tools
• AI Data Tools and Guides
• Extract Data from Screenshots and APIs
• Data Lineage and Audit Trail Guides
• File Format Guides and Free Tools

Who uses Data Utility

• Free Data Tools for Marketing Lists
• Free Data Tools for Finance and Accounting Exports
• Free Data Tools for Developers
• Free Data Tools for Data Analysts
• Free Data Tools for Small Business

Frequently asked questions · Data format benchmark

Frequently asked questions

How do I generate test data online?

Choose the columns and data types, set the number of rows and download the file as CSV, JSON, Parquet or Excel.

Is the test data real?

No. Every value is generated randomly, so it contains no real people or customers and is safe for development and demos.

Can I generate test data that matches my database tables?

Yes. Use the Schema Data Generator and paste your CREATE TABLE statement.

Is the data real?

No. It is random and fictional, so it is safe to share.

Can I get the same data again?

No – each click makes new data. Download to keep a set.

How many rows can the Data Generator create?

Up to 500,000 rows at a time. Choose column types such as names, emails, addresses and dates, then download as CSV, JSON, Parquet or Excel.

Related pages

• Mock Data Generator: Generate up to 500,000 rows of realistic fake data (names, emails, addresses, dates) and download as CSV, JSON, Parquet or Excel. Free, in your browser.
• Fake Data Generator: Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
• Fake Database for Testing: Create a fake database for testing: paste a CREATE TABLE script and get realistic rows as INSERT statements, CSV or JSON. Free, in your browser.

Topic guides

• Test Data Guides and Free Generators

Guides

• Free Mock Data Generator: Realistic Test Data in 1 Minute