Fake Data Generator

Generate realistic test data in JSON, CSV, or SQL INSERT format. 100% client-side.

Configuration
Fields
Output
Configure fields and click Generate to create test data.

How to Use the Fake Data Generator

  1. Choose output format — select JSON (default), CSV, or SQL INSERT using the chips at the top.
  2. Set the record count — enter how many rows of data you need (1-1000).
  3. Configure fields — each row has a field name and a data type. Add or remove fields with the buttons. For SQL format, set the table name.
  4. Click Generate — the tool produces realistic fake data instantly in the selected format.
  5. Copy or download — use the buttons above the output panel to get your data.

Why Use Fake Test Data?

Building software that handles real user data — names, emails, phone numbers, addresses — carries compliance risk. Using real customer data in development or testing environments may violate GDPR, HIPAA, CCPA, and other data protection regulations. Fake data that looks realistic allows you to develop, test, and demo applications without any privacy exposure.

Use Cases

  • Database seeding — populate tables with hundreds of records for development and QA environments
  • API development — create realistic response payloads to test against
  • Frontend prototyping — fill UI components with data that looks real
  • Performance testing — generate 1000 records to stress-test queries and pagination
  • Demo environments — show clients realistic-looking applications without exposing internal data
  • Automated testing — seed test databases before running Playwright or Cypress test suites

Available Field Types

  • Name — realistic first + last name combinations (e.g., "Sarah Mitchell")
  • Email — email addresses based on name patterns (e.g., "[email protected]")
  • Phone — formatted phone numbers (e.g., "+1-555-234-5678")
  • Address — street address with number (e.g., "1421 Oak Street")
  • City — real US city names drawn from a broad list
  • Country — country names for international datasets
  • Date — ISO 8601 dates within the last 5 years
  • Number — random integer between 1 and 10000
  • UUID — RFC 4122 v4 UUID strings
  • Boolean — true or false values
  • Company — company names (e.g., "Apex Solutions Inc")
  • URL — realistic website URLs
  • IP Address — random IPv4 addresses
  • Color — hex color codes (e.g., "#3a8fbf")

Output Formats Explained

JSON: Produces a JSON array of objects. Each object has keys matching your field names and values of the selected type. This format works directly with JavaScript fetch, Postman, and most API testing tools. Paste it into your frontend's mock data file or use it as a fixture in Jest or Vitest tests.

CSV: Produces comma-separated values with a header row. This format is importable into spreadsheets (Excel, Google Sheets), database tools (TablePlus, DBeaver), and data science tools (pandas, R). CSV is the fastest way to bulk-import data into databases using COPY commands or import wizards.

SQL INSERT: Produces ready-to-run INSERT statements for a table of your choosing. Compatible with PostgreSQL, MySQL, SQLite, and SQL Server. Values are properly quoted and escaped. This is the fastest path from this tool to a populated development database.

Privacy and Data Safety

All data generation happens entirely in your browser. No configuration, no generated data, and no field definitions are sent to any server. The generator uses seeded random functions with browser entropy — data is not reproducible between sessions, so each generation produces a unique dataset. This tool is safe to use on corporate networks and in compliance-sensitive environments.

Frequently Asked Questions

Fake data (also called test data or mock data) is realistic-looking but entirely made-up data used for software testing, database seeding, API development, and UI prototyping. It lets developers build and test systems without using real personal data, which avoids privacy and compliance risks.
No. All data generation happens entirely in your browser using JavaScript. No data is sent to any server. The tool works offline once the page is loaded.
Yes. Choose the SQL INSERT output format and specify a table name. The tool generates valid SQL INSERT statements you can run directly in PostgreSQL, MySQL, SQLite, or any SQL database. For larger seeding tasks, generate 1000 records and import with your database client.
Click the + Add Field button to add a new column. Each field has a name and a type (Name, Email, Phone, etc.). Click the trash icon next to any field to remove it. Changes take effect when you click Generate.
This tool supports 1 to 1000 records per generation. Since all processing happens in your browser, generating 1000 records is nearly instant. For datasets larger than 1000 records, generate multiple batches and combine them.