Prompt: Analyze This Spreadsheet Data

You have a spreadsheet with 500 rows and you need to find the story in the data. Staring at cells and sorting columns manually takes forever and you still miss patterns.

This prompt turns raw data into clear findings. Use it to prompt analyze spreadsheet data ai can parse so you get answers instead of more questions.

The Prompt

I am pasting data from a spreadsheet. Analyze it and provide:

CONTEXT: [What this data represents, e.g., "Monthly sales by region for 2025" or "Customer support tickets from Q3"]
GOAL: [What I want to learn, e.g., "Which regions are underperforming?" or "What are the most common complaint categories?"]

Here is the data:
[PASTE YOUR DATA HERE - include column headers]

Provide your analysis in this format:
1. DATA SUMMARY: What you are looking at (row count, date range, key columns)
2. TOP 3 FINDINGS: The most significant patterns or insights, each with supporting numbers
3. ANOMALIES: Anything that looks unusual or unexpected
4. RECOMMENDATIONS: 2-3 specific actions based on the findings
5. QUESTIONS: What additional data would make this analysis stronger

Rules:
- Lead every finding with the specific number or percentage
- Compare against averages and benchmarks where possible
- Flag any data quality issues (missing values, outliers, inconsistencies)
- Be direct about what the data says, even if the news is bad

Tips for Better Results

Copy your data with headers included. Column names give the AI critical context about what each number represents.

If your spreadsheet is massive, paste a representative sample first. Get the analysis framework right, then run it on the full dataset.

The GOAL field shapes everything. "Analyze this data" gives you a generic overview. "Tell me which sales reps are below target and why" gives you something you can act on in your next team meeting.

Going Deeper

After the initial analysis, follow up with specific questions:

• "Break down the top finding by month to show the trend"
• "Compare Q3 to Q2 for the underperforming segments"
• "What would this metric need to be to hit our annual target"

Each follow-up digs one layer deeper. Three or four rounds usually gets you to the insight that actually matters.

When to Use This vs. a Dashboard

Use this prompt for one-off analysis, ad hoc questions, and exploring data you have not looked at before. Use dashboards for metrics you track weekly.

The prompt is your analyst. The dashboard is your scoreboard. Both have a job. Neither replaces the other.

Build These Systems

Ready to implement? These step-by-step tutorials show you exactly how:

• How to Build AI-Powered Audience Targeting Suggestions - Use AI to analyze your data and suggest new audience segments to test.
• How to Build AI-Powered Bid Strategy Recommendations - Use AI to analyze data and recommend optimal bid strategies for each campaign.
• How to Build an AI Report Narrative Generator - Turn raw data into narrative insights using AI data storytelling.