Dummy Data Generator
Create realistic mock datasets in JSON, CSV, or table format.
Define your columns and generate test records for software, database, and dashboard testing without using real customer data.
Use the tool
Result
- No account required
- Runs entirely in your browser
- Nothing you enter is sent to a server
Still stuck? Talk to us.
Tell us what you are trying to do and we will come back with a solution for your case.
- Custom web development and SEO audits
- Data analytics and workflow automations
- Tailored micro-tools for your business
How Dummy Data Generator works
To generate dummy data, list the columns you need, pick a record count and an output format, then click Generate dataset. This tool builds up to 1,000 artificial rows as JSON, CSV, or a tab-separated table, right in your browser. None of the values come from real customers, so the result is safe for testing, demos, and screenshots.
Each column goes on its own line as name:type. A line such as email:email or plan:choice(Basic,Pro,Team) tells the generator what kind of value to produce. The supported types are uuid, integer, decimal, name, first_name, last_name, email, phone, city, country, company, date, boolean, and choice(a,b,c).
Here is a quick example. Set 50 records and use the sample columns: id:uuid, full_name:name, email:email, city:city, signup_date:date, plan:choice(Basic,Pro,Team), and amount:decimal. You get 50 rows, each with a unique ID, a name, an email address, a city, a recent date, one of the three plans, and a decimal amount.
Know the built-in ranges before you rely on them. Integers fall between 1 and 1000, decimals between 0 and 1000 with two decimal places, and dates land within the last three years in YYYY-MM-DD format. UUIDs are unique, but names, cities, and other values are random picks, so repeats can appear in larger datasets.
Pick the format by where the data is going. CSV opens in Excel and Google Sheets and imports into most databases. JSON suits API mocks, front-end prototypes, and test fixtures. The tab-separated table pastes into a spreadsheet when you would rather not save a file first.
Common uses include testing a dashboard before real data exists, practicing formulas or pivot tables, filling a staging database, checking that an import handles every column, and making demo screenshots that expose no one's information. Real customer data brings privacy and compliance risk that mock rows avoid.
Every run produces different values, and there is no seed option to repeat an earlier dataset. Save the output if you need the same rows again. Check a few rows after generating to confirm the columns and formats match what your system expects, then adjust the column types and regenerate if needed.
Generation happens on your device with no server call, so the columns you define and the rows you create are not uploaded or stored. Treat the output as test data only. Do not present it as real statistics or use it for business decisions, and remove it from any live system when testing ends.
Frequently asked questions
Is the generated data real?
No. All values are randomly generated in your browser from built-in lists and rules. Names, emails, and phone numbers are artificial and are not linked to real people.
How many records can I generate?
You can generate up to 1,000 records at a time. If you need more, generate several batches and combine them, since very large outputs can slow the browser.
What column types does the generator support?
It supports uuid, integer, decimal, name, first_name, last_name, email, phone, city, country, company, date, boolean, and choice(a,b,c). Write each column on its own line as name:type.
How do I generate dummy data for Excel?
Choose CSV, generate the dataset, then copy or download it and open it as a .csv file in Excel. You can also paste the tab-separated table straight into a sheet. Check date columns after opening.
Which output format should I choose?
Use CSV for spreadsheets and database imports, JSON for APIs, prototypes, and test fixtures, and the tab-separated table when you want to paste rows into a spreadsheet without saving a file.
Can I set my own number ranges?
Not in this version. Integers use a default range of 1 to 1000, and decimals run from 0 to 1000 with two decimal places. Adjust values in a spreadsheet afterward if you need different limits.
Can I get the same dataset again?
No. Each run creates new random values, and there is no seed option. If you need the same rows later, copy or download the output the first time and keep the file.
Can I use the data in a production system?
It is intended for testing, demos, and prototyping. Do not present it as real data or use it for analysis, and remove it from any live system when testing is finished.
Is anything sent to a server?
No. Generation runs entirely on your device, so the columns you define and the records you create are never uploaded or stored.