Dummy Data Generator
Make realistic fake UK test data for forms, spreadsheets and databases. Pick your fields and format. Runs in your browser.
Private by design: every row is made up on your device. Nothing is sent anywhere. Emails use example domains and phone numbers come from Ofcom's ranges reserved for fiction, so none of them reach real people.
Need test data fast? Dummy Data Generator makes realistic fake UK records, such as names, emails, phone numbers, addresses, postcodes and UUIDs, in a single click. Download up to 500 rows as JSON, CSV, SQL or plain text and drop them straight into your app, spreadsheet or database.
How to generate test data
- Set Number of rows between 1 and 500 (the default is 10).
- Tick the Fields you need: full name, email, phone, company, job title, address, postcode, date and UUID. Full name, email and phone are ticked to start with.
- Choose an Output format: JSON, CSV, SQL INSERT or Plain text (one readable record per block, no code).
- Press Generate. Your rows appear in the Result box, ready to Copy or Download as a file.
If you enjoy what we do, consider supporting us. Every little bit means the world! Support Catpool on Ko-fi
What dummy data is for
When you build a form, a spreadsheet or a database, you need something to put in it before real customers arrive. Typing out twenty made-up people by hand is slow, and copying real records into a test system is a privacy risk. Dummy Data Generator fills the gap with realistic UK-style rows in a second: British names, UK towns with matching postcode areas, company names, job titles and ISO dates.
Typical jobs include seeding a development database, testing how a table or CRM import copes with a few hundred rows, filling a design mock-up so it looks real, or giving a spreadsheet formula something to chew on. If you need unique keys on their own, the UUID Generator makes them in bulk, and Lorem Ipsum covers placeholder paragraphs.
JSON, CSV and SQL
JSON gives you an array of objects, one per row, which suits APIs, JavaScript apps and test fixtures. CSV has a header row and opens straight in Excel, Google Sheets or Numbers; values that contain commas or quotes are wrapped correctly. SQL INSERT writes a single INSERT INTO dummy_data statement you can paste into MySQL, PostgreSQL or SQLite after renaming the table. Column names use simple snake_case such as job_title. Plain text has no code at all: each record is a short block of labelled lines, such as Email: ava.jones@example.com, with a blank line between records, so you can paste it into an email, a document or a chat.
Want to check the JSON before you use it? Paste it into the JSON Formatter. Comparing two exports? The Diff Checker shows what changed.
Safe by design
Every row is invented, so nobody real gets an email or a phone call if your test system sends one. Email addresses use example.com, example.co.uk and other domains set aside for testing. Phone numbers come from the ranges Ofcom reserves for TV and film (07700 900xxx and 020 7946 0xxx), so they never connect to a real line. Postcodes use the right area for each town but are made up, so they may not match a real street.
Privacy
Everything happens in your browser. There is no sign-up, nothing is uploaded and nothing is stored on Catpool’s servers. Close or refresh the tab and the data is gone.
FAQ
Is any of this data real?
No. Names and towns are picked at random from common UK lists and joined together, so any match with a real person is pure chance. Emails and phone numbers use reserved test ranges that cannot reach anyone.
Can I generate random numbers or IDs as well?
Each row can include a UUID, a random ID that is unique every time, which is handy as a primary key. For plain random numbers in a range, such as 1 to 100, use the Random Number Generator instead.
How many rows can I make?
Up to 500 per click. Press Generate again for a fresh set, or download several files if you need more.
Will the CSV open in Excel?
Yes. Download it as dummy-data.csv and open it in Excel, Google Sheets or Numbers. The first row holds the column names.
Can I use it for GDPR-friendly testing?
That is the idea. Using made-up records instead of copies of real customer data keeps personal information out of test and demo systems.
Why are the postcodes not real addresses?
They are built to look right (a real area code such as LS1 or BS1 followed by a random ending) but are not looked up, so they will not pass strict address checks.
Related: UUID Generator, JSON Formatter, Lorem Ipsum, Diff Checker, Random Number Generator, Developer, Catpool home.
