Practical Tools
Converters

Mock Data Generator

Fields to include
Format
id,firstName,lastName,email,company
1,Noah,Cohen,noah.cohen@sample.io,Northwind
2,Mia,Silva,mia.silva@example.com,Brightline
3,Ava,Dubois,ava.dubois@demo.co,Acme Co
4,Morgan,Smith,morgan.smith@test.dev,Oakhill
5,Jordan,Wang,jordan.wang@example.com,Brightline
6,Riley,Muller,riley.muller@sample.io,Harbor & Co
7,Jordan,Rossi,jordan.rossi@example.com,Sunset Creative
8,Emma,Okafor,emma.okafor@test.dev,Northwind
9,Jordan,Muller,jordan.muller@test.dev,Lumen Group
10,Jamie,Ivanov,jamie.ivanov@sample.io,Vertex Labs

When you are building a spreadsheet, testing an app, designing a table, or demoing a product, you need realistic-looking data that is not real. This generator creates fake but plausible records - names, emails, companies, job titles, cities, dates, and IDs - in whatever combination you choose, then exports them as CSV or JSON. Pick the fields and the number of rows, hit generate, and copy or download. Everything runs in your browser, so nothing is uploaded and you can generate as much as you need.

No signupRuns in your browserWorks offlineFormula explained belowGeneral information only

How to use this tool

  1. 1Select the fields you want by tapping them; selected fields are highlighted.
  2. 2Set the number of rows, from 1 up to 1,000.
  3. 3Choose CSV for spreadsheets or JSON for code and APIs.
  4. 4Use Regenerate to get a fresh random set with the same settings.
  5. 5Copy the output, or download it as a .csv or .json file.

Example

Test data for a spreadsheet

Select ID, First name, Last name, Email, and Company, set 50 rows, and choose CSV. Download the file and open it in any spreadsheet to test formulas, filters, or a mail-merge without using real customer data.

Sample JSON for an API

Select ID, Full fields plus UUID and Date, set 20 rows, and choose JSON. Copy the array straight into your code as a stub response while you build the front end before the real API is ready.

Common use cases

  • Filling a spreadsheet or table with realistic placeholder rows
  • Seeding a test database or app with sample records
  • Stubbing an API response as JSON during development
  • Creating demo data for a product screenshot or walkthrough
  • Testing imports, filters, and mail-merges without real data

Common mistakes

  • Using mock data in production - this is fake data for testing only; never mix it with real records.
  • Forgetting to pick a unique field - add ID or UUID if you need each row to be distinct.
  • Choosing the wrong format - CSV is for spreadsheets, JSON is for code; pick the one your tool expects.
  • Generating far more rows than needed - large sets are slower to copy; download instead for big files.

Frequently asked questions

Is the data real?

No. Every value is randomly generated from sample pools, so names, emails, and companies are plausible but fictional. It is safe to share and use for testing, and it never contains real personal data.

What is the difference between CSV and JSON?

CSV is a plain table that opens in spreadsheets like Excel or Google Sheets. JSON is a structured format used by code and APIs. Choose CSV for spreadsheet work and JSON for development.

How many rows can I generate?

Up to 1,000 rows at a time. For very large datasets, generate in batches and download each one. The preview shows a trimmed view for big sets, but the download contains every row.

Can I get the same data again?

The data is random each time you change settings or press Regenerate. If you need a fixed set, generate once and download it rather than regenerating.

Is anything uploaded?

No. The data is generated entirely in your browser. Nothing is sent to a server, stored, or shared - the file only exists once you download it.

Are the emails and phone numbers valid?

They are formatted to look valid but are not real or deliverable. Emails use sample domains and phone numbers use placeholder ranges, so they are safe to use in tests without contacting anyone.

Related tools

Last updated