Analytics Difficulty: Intermediate

Realistic Mock Dataset Generator with CSV or Excel Output

This prompt directs the AI to act as a data generator and produce a realistic, analysis-ready mock dataset using the specified columns. It requires diverse, real-world-like entries suitable for statistics, machine learning, and visualization, delivered in a common data format (CSV or Excel) alongside brief documentation describing column meanings, structure, and assumptions used during generation.

The prompt

151 words2 blanks to fill in

Act as a data generator tasked with creating a comprehensive mock dataset for [INTENDED USE], placeholder. Generate a realistic dataset with the specified [COLUMNS], placeholder.
Requirements:
– Create diverse, real-world-like records with plausible values, ranges, and relationships between columns.
– Include enough rows to support statistical analysis and basic machine learning (suggest 500–10,000 rows unless otherwise specified).
– Ensure clean structure: consistent data types, standardized formats (dates, currency, categories), and no ambiguous values.
– Include realistic edge cases (missing values, outliers, rare categories) at a controlled rate.
– Provide the dataset in CSV or Excel format (as requested).
– Include brief documentation covering:
– Dataset overview and intended use
– Column-by-column definitions, data types, and example values
– Assumptions, generation rules, and any constraints applied
– Notes on missing data and outliers
Output format:
1) Documentation (brief, scannable)
2) Dataset file content (CSV table) OR a clear Excel-ready representation if Excel is requested.

Highlighted text is a blank. Swap it for your own detail before you send the prompt.

What it produces

A CSV dataset with 1,000 rows and 12 columns, including realistic dates, categories, and numeric ranges plus a short data dictionary.

A customer-orders style dataset with controlled missing values and outliers, ready for pivot tables and ML feature engineering.

A documented dataset export that includes column definitions, data types, and assumptions for reproducibility.

How to use this prompt

Four steps, about a minute. Nothing to install and no account needed.

  1. Copy the prompt

    Use the Copy button above. The whole prompt goes to your clipboard exactly as written. Nothing is trimmed.

  2. Fill in the blanks

    Replace [INTENDED USE] [COLUMNS] with your own details. Everything in square brackets is a blank for you to fill in.

  3. Paste it into your assistant

    Checked against DeepSeek, ChatGPT, Claude. It is written as plain instructions, so paste it into whichever of them you already use.

  4. Read the result, then push back

    Compare what you get to the example below. If it is close but not right, say what to change: shorter, warmer, more specific, then ask again in the same conversation.

More prompts like this one

Close neighbours in Analytics, by shared subject and tagging.

Share Realistic Mock Dataset Generator with CSV or Excel Output:

Reviews and questions

What other people got out of this prompt, and what they asked about it.

Discussion is closed for this prompt.

No reviews yet

Be the first to share how this prompt worked for you.