Excel

MockData

Demoing the dashboard with real customer names again? MockData fills your sheet with realistic fake people, dates and numbers — generated on your machine, reproducible on demand.

€24 one-time · free tier, free forever · 30-day money-back

The problem

Test data is always someone's real data

You need fifty rows to test the pivot table, demo the template, or train the new colleague. So you copy a slice of the real customer list — and now actual names and emails live in a file called test_v2.xlsx that gets mailed around forever. The alternative is typing "John Doe" fifty times.

MockData generates believable data that's nobody's data. Names, emails, dates, amounts, cities, companies, phone numbers, booleans — pick your columns, set the row count, fill the selection. The generator is seeded, so the same seed reproduces the same dataset for repeatable tests. Pro adds locale packs, custom patterns, weighted lists and checksummed test IDs in clearly-fake ranges.

A column-type picker generating a table of fake data in Excel Pick your columns Full name Email City € 50–900 Date range Phone Rows: 100 Seed: 42 Generate same seed → same data, every time Nobody's data Name City Amount Lotte JanssenUtrecht412.50 Tom BeckerHamburg87.20 Claire DuboisLyon655.00 Sam CarterLeeds230.75 Eva de VriesBreda518.90 … 95 more rows
Pick columns, set rows and a seed, generate — realistic data with no privacy risk attached.

Free vs Pro

Free covers a quick hundred rows. Pro scales up and gets specific — locales, patterns, weights, test IDs.

FeatureFreePro €24
8 column types: names, email, dates, numbers, city, company, phone, boolean
Fill the selection or a new table, up to 100 rows
Seeded, reproducible results
1,000+ rows
Locale packs (EN / NL / DE / FR names & cities)
Custom patterns ({AAA}-{999}) & weighted choice lists
Checksummed test IDs (IBAN/BSN-style, clearly fake ranges)
Save generator presets

How it works

Install the free add-in

Two minutes, no account, no card. Upload the manifest via Insert › Add-ins — see the install guide.

Generate your dataset

Pick column types, set a row count and seed, click Generate. Free forever — not a trial.

Unlock Pro when you need it

Buy once on Gumroad, paste your license key into the pane. Big datasets, locales and presets unlock instantly.

Installing MockData

In Excel (Windows, Mac, or web): Insert › Add-ins › My Add-ins › Upload My Add-in, then select the MockData manifest.xml. A MockData button appears on your ribbon.

Coming to AppSource: MockData is being submitted to Microsoft's add-in marketplace, after which it installs in one click from inside Excel. Sideloading works today.

Full install guide

FAQ

Is the data downloaded from somewhere?

No. The wordlists ship inside the add-in and the generator runs entirely in your Excel session — no fetches, no API, works offline. Nothing about your workbook leaves Excel either. See the privacy policy.

What does "seeded" mean?

The random generator starts from a seed number you can see and set. Same seed, same columns, same row count — identical data. That makes test cases repeatable and demos predictable.

Could the fake IDs collide with real ones?

Pro's IBAN/BSN-style test IDs are checksummed so they pass format validation, but they're generated in clearly-fake ranges precisely so they can't be mistaken for real accounts or citizens. That's a deliberate design choice, not an accident.

Refunds?

30-day money-back guarantee, no questions asked — reply to your Gumroad receipt or email [email protected].