Fake Data Generator Online - JSON, CSV, TSV, SQL Test Data

Need mock JSON, CSV rows or SQL INSERT fixtures? Configure column types and zh/en locale, preview in a table, then copy JSON or download CSV, TSV and SQL. Generation and export run locally; fake data is never uploaded.

Settings

Locale Rows

Columns

Preview

0 uses

How to generate JSON/CSV test data fast?

Features

Custom schema
Add/remove columns with 20+ field types
Zh / En locale
Names, addresses and companies match zh-CN or en locale
Multi export
Download JSON, CSV, TSV and SQL INSERT
Table preview
Preview first 100 rows after generate
Local & private
Generation and export run locally; fake data is never uploaded.

Use cases

API mocking and Postman examples
Front-end table and pagination demos
Seed test DB with INSERT scripts
Sample CSV before Excel or BI import
Training demos without real PII

How to use

Pick locale and row count
Set column names and types; add columns
Click Generate and review the preview
Copy JSON or download CSV/TSV/SQL

FAQ

QRow limit?

Up to 1000 rows per run—enough for most fixtures; use scripts for huge datasets.

QSQL export format?

One INSERT INTO fake_data (...) VALUES (...); per row with escaped strings.

QIs this real user data?

All values are random fiction—not real people or companies. Do not use for fraud or spam.

Qvs Faker library?

No code—click in the browser for ad-hoc data; use Faker/Bogus in code for complex rules.

QIs data uploaded?

Generation and export run locally; fake data is never uploaded.

Fake test data generation

API integration, unit tests and demos need batches of names, emails and phones. Hand-typing rows is slow and repetitive. Pick column types and export JSON, CSV or SQL INSERT for fixtures or spreadsheets.

{"id":"uuid","name":"Alice","email":"user@example.com","phone":"13800138000"}