Realistic test data without real personal data

Prompt that creates realistic test data with edge cases without using real names, addresses or account numbers. Paste it into an AI tool of your choice, which then creates the test data.

Topic: Tests & quality
Type: Prompt
Level: Intermediate
Time: about 8 min

Results depend on the tool, the model and what you enter.

Result preview

Example: written by our editors, not real AI output.

case,name,email,postcode,town normal,Lena Example,lena.example@example.com,10115,Berlin umlauts,Jürgen Müßig-Özdemir,j.muessig@example.com,80331,München very long,Maximiliane Alexandra von Testhausen-Probstberg,max.long@example.org,20095,Hamburg empty,Kim Test,kim@example.net,, leading zero,Ben Sample,ben@example.com,01067,Dresden apostrophe,Jo O'Example,jo.o@example.com,50667,Köln Deliberately not included: names in non-Latin scripts, addresses abroad, phone numbers.

Fill in

What you type stays in this browser window. We store and send nothing.

StructureWhich fields does the record need?

CountHow many records?

FormatIn which format?

Your prompt

Create test data for the following structure.
Fields: [Structure]
Number of records: [Count]
Format: [Format]
Rules: 1. Use only made-up values: email addresses at example.com, example.org or example.net, clearly invented names, no real phone or account numbers. 2. Cover edge cases such as accents and umlauts, apostrophes, very long and empty values, leading zeros, month boundaries and time zones. 3. Keep relationships between fields consistent, such as postcode and town or order and delivery date. 4. State in a column "case" which edge case each record tests. 5. Then briefly list which cases are deliberately missing. Output the data in the requested format without an introduction.

Take particular care to use only made-up values and label every edge case visibly.

Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.

This is an instruction for an AI, not the result itself.

Where this prompt works

These AI tools are a good fit for this prompt:

How to use it

Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
Copy the finished prompt into an AI tool of your choice.
Before using it, check that no real data is included, and store the file with the tests, not in a production database.

Why does this work?

Made-up data with targeted edge cases finds bugs that real data rarely shows, and spares you copies of personal data from the live system.

Tips

The domains example.com, example.org and example.net are reserved for examples; mail sent there reaches nobody.

You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use

Realistic test data without real personal data

Result preview

Fill in

Your prompt

Where this prompt works

How to use it

Why does this work?

Tips

Part of these agents

Also a good fit

Code review with priorities New

Find edge cases before you build New

Quick threat model for a new feature New