Fake Data Generator

What data types can you generate?

This fake data generator covers 27 field types across six categories:

• Person — full name, first name, last name, email address, phone number, username, password, birth date, gender, job title
• Location — street address, city, state, postal code, country, latitude, longitude
• Business — company name, website URL
• Internet — IPv4 address, MAC address
• IDs & numbers — UUID, random number, boolean
• Text — lorem ipsum word, sentence, paragraph

Combine any mix of these into a single dataset. A typical test dataset might include first name, last name, email, phone, street address, city, postal code, and company — all generated together in one click.

Example dataset

Here is a sample of the data this generator produces — names, emails, phone numbers, and cities (all fictional):

Build a complete schema — not just one field at a time

Most simple fake data generators let you pick one field and copy a list. That works for a quick email address, but it's useless when you need a full user table for a database seed script or a realistic CSV for an import test.

This tool works like a lightweight schema builder. Add as many columns as you need, give each one a name and a data type, and generate all the rows in one pass. Four presets cover the most common cases:

• Person — first name, last name, email, phone, birth date
• Address — street, city, state, postal code, country
• Company — company name, job title, email, website
• Full Profile — ID, name, email, phone, address, country, company, and job title in one table

Column names are editable, so you can match your exact database schema or field naming convention before exporting.

Export fake data as CSV, JSON, or SQL

Once you've generated your rows, pick the export format that fits your workflow:

• CSV — a header row followed by comma-separated values, ready to open in Excel, Google Sheets, or Numbers. Also works for database import wizards, pandas read_csv, and any tool that accepts flat files.
• JSON — an array of objects with your column names as keys. Drop it straight into a REST API mock, a Node.js fixture file, a json-server database, or a front-end component that consumes JSON.
• SQL — a ready-to-run INSERT INTO statement compatible with MySQL, MariaDB, PostgreSQL, and SQLite. Set the table name before exporting to match your schema. String values are properly single-quote escaped; booleans and numbers are unquoted.

Hit Download to save the file directly, or Copy to paste it wherever you need it. Up to 1,000 rows per generation.

Completely free — no account, no limits

There is no account to create, no API key to manage, and no daily row limit. Generate as much data as you need. All data is generated locally in your browser using Faker.js — nothing is transmitted to any server, and nothing is stored. The tool works offline once the page has loaded.

Want this built into your browser instead of a web tool? Read our guide to the best fake data generator browser extension for developers.

Frequently asked questions

How many rows can I generate at once?

Up to 1,000 rows per generation. You can build a schema with as many columns as you need and regenerate as many times as you like — there is no daily or account-based limit.

What export formats are supported?

CSV (for spreadsheets and database import wizards), JSON (for API mocks and fixture files), and ready-to-run SQL INSERT statements compatible with MySQL, PostgreSQL, MariaDB, and SQLite.

Can I customize the columns in the generated dataset?

Yes. Add or remove columns, rename each one, and pick from 27 field types across person, location, business, internet, ID, and text categories, or start from one of the four built-in presets.

Is this safe to use with real production database schemas?

Yes — that is the intended use case. Because column names are editable and export formats match common database tooling, you can shape the output to match your exact schema before seeding a development or staging database.