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.
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.
Copy the prompt
Use the Copy button above. The whole prompt goes to your clipboard exactly as written. Nothing is trimmed.
Fill in the blanks
Replace [INTENDED USE] [COLUMNS] with your own details. Everything in square brackets is a blank for you to fill in.
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.
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.
- Advanced Excel Task Execution With Accuracy and Clarification
- Excel Formula and Command Generator with Explanation
- Excel Function Step-by-Step Tutorial Builder
- E-commerce Customer Behavior Analysis for Growth Insights
- E-Commerce Sales Data Analysis for Actionable Growth Insights
- Strategic Data Visualization for Decision-Making and Outcomes
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.
Discussion is closed for this prompt.
No questions yet
Have a question about using or customizing this prompt? Be the first to ask.