Free Mock Data Generator
Generate realistic fake test data — names, emails, addresses, dates, numbers — and export as JSON, CSV, SQL, NDJSON, XML, or XLSX. Names, phones, and addresses in 11 languages. Up to 10,000 rows, no account, runs in your browser.
Mockaroo's free plan stops at 1,000 rows per download — here you can generate up to 10,000. · checked Sep 2026
Fields
5 columnsInfer columns from a sample
Paste a CSV with a header row, a JSON object or array, or NDJSON. Column types (email, date, number range, short list of values…) are guessed from the names and values, then you can adjust them.
Up to 10,000 rows
Same seed = same data every time.
Format
JSON shape
💡 All data is randomly generated in your browser — up to 10,000 rows, no account, nothing uploaded. Names, companies, and addresses are fictional and any resemblance to real data is coincidental.
Common uses
- Generate Seed Data for a DatabaseCreate realistic rows and export SQL INSERT statements to seed your dev database.
- Generate JSON Test Data for an APIBuild realistic JSON payloads for testing endpoints and mock servers.
- Generate CSV Test DataCreate a CSV of sample rows to import into Excel, Google Sheets, or a data tool.
- Generate Placeholder Data for a UIFill tables, lists, and cards with realistic content while building a UI.
- Generate Bulk Data for Load TestingProduce large datasets to stress-test imports, queries, and pipelines.
How It Works
Need realistic-looking test data to seed a database or build a UI? Many generators (like Mockaroo) cap the free tier at around 1,000 rows. This one runs in your browser and makes up to 10,000 rows at a time.
- 1You define your schemaAdd fields and pick a type for each — names, emails, addresses, dates, numbers, booleans, UUIDs, custom lists, and more.
- 2Rows are generated locallyEach row is built from curated, fictional data pools using your browser's random number generator. Nothing is sent to a server.
- 3You export in your formatOutput as JSON, CSV, SQL INSERT statements (with your table name), or NDJSON.
- 4Copy or downloadCopy the result to your clipboard or download it as a file, ready to seed a database or feed a test suite.
All data is fabricated and generated entirely on your device — up to 10,000 rows per run, no sign-up, and nothing is uploaded. Perfect for seeding dev databases, prototyping UIs, and load-testing.
Related Tools
Lorem Ipsum Generator
Generate Lorem Ipsum placeholder text. Choose words, sentences, or paragraphs. Copy in one click.
CSV Diff
Compare two CSV files by a key column and see exactly which rows were added, removed, or changed — with the specific fields that differ shown old to new. Handles quoted fields; runs entirely in your browser.
Excel / XLSX Viewer
Open and view .xlsx, .xls, .csv, and .ods spreadsheets without Excel or Google Sheets. Switch sheets and export to CSV or JSON. Runs entirely in your browser.