prompts
beginner
ChatGPT
Claude
Gemini
AI Prompts for Data Analysis: Turn Spreadsheets into Insights
Copy-paste prompts that turn messy spreadsheets into clear summaries, trends, and charts using any major AI chatbot.
8 min read10 April 2026
data analysis
spreadsheets
prompts
productivity
business intelligence
CSV
15 ready-to-use prompts for cleaning, summarising, and visualising spreadsheet data with ChatGPT, Claude, or Gemini
Works with sales reports, budgets, survey results, and any CSV or Excel file you can upload or paste
No coding or technical background required: just paste your data, pick a prompt, and get answers in seconds
Why This Matters
Every business in Asia runs on spreadsheets. From quarterly sales reports in Singapore to inventory trackers in Jakarta, the humble spreadsheet remains the backbone of decision-making across the region. Yet most professionals spend hours manually sorting columns, writing formulas, and building pivot tables when an AI chatbot could do the same work in under a minute.
A 2026 Workera survey found that 76% of professionals plan to learn new AI skills this year, and data analysis tops the list. The good news: you do not need to learn Python or SQL to start. Modern AI chatbots like ChatGPT, Claude, and Gemini can all accept pasted data or uploaded files and return clean summaries, trend analysis, and even chart suggestions on the spot.
This prompt collection gives you 15 tested prompts you can copy, paste, and adapt for your own data. Whether you are a marketing manager reviewing campaign metrics, a finance lead closing the books, or a founder tracking monthly growth, these prompts will cut your analysis time dramatically and help you spot patterns you might otherwise miss.
A 2026 Workera survey found that 76% of professionals plan to learn new AI skills this year, and data analysis tops the list. The good news: you do not need to learn Python or SQL to start. Modern AI chatbots like ChatGPT, Claude, and Gemini can all accept pasted data or uploaded files and return clean summaries, trend analysis, and even chart suggestions on the spot.
This prompt collection gives you 15 tested prompts you can copy, paste, and adapt for your own data. Whether you are a marketing manager reviewing campaign metrics, a finance lead closing the books, or a founder tracking monthly growth, these prompts will cut your analysis time dramatically and help you spot patterns you might otherwise miss.
How to Do It
1
Prepare your data
Open your spreadsheet in Excel or Google Sheets. Select the data range you want to analyse, including column headers. Copy it to your clipboard (Ctrl+C or Cmd+C). If your file is a CSV or XLSX under 10 MB, you can upload it directly to ChatGPT, Claude, or Gemini instead of pasting. Tip: for large files, paste just the first 50 rows along with column headers so the AI understands the structure, then ask it to describe what analysis it would run on the full dataset.
2
Pick the right prompt for your goal
Scan the prompt collection below and choose one that matches what you need. The prompts are grouped into four categories: data cleaning, summary and trends, comparisons and benchmarks, and visualisation and reporting. Each prompt has a clear purpose label so you can find the right one fast.
3
Paste the prompt and your data into the chatbot
Open ChatGPT, Claude, or Gemini. Paste the prompt first, then paste your data directly below it (or upload your file). Replace anything inside [square brackets] with your actual details. Hit send and wait for the response.
4
Review and refine
Check the AI's output against your source data. If something looks off, ask a follow-up like "Can you double-check the total for column B?" or "Break this down by region instead." AI chatbots handle iterative follow-ups well, so treat the first response as a starting point, not a final answer.
5
Export your results
Once you are happy with the analysis, ask the chatbot to format the output as a table you can paste back into your spreadsheet. In ChatGPT and Claude, you can also ask for the results as a downloadable CSV. For charts, ask Gemini or ChatGPT to generate a visual, or request the data in a format ready for your preferred charting tool.
What This Actually Looks Like
The Prompt
You are an expert data analyst. Here is my quarterly sales data for a retail business in Southeast Asia: [Paste: columns for Month, Store_Location, Product_Category, Units_Sold, Revenue_USD, Returns] Please: 1. Summarise total revenue and units sold per store location 2. Identify the top 3 and bottom 3 product categories by revenue 3. Calculate the return rate per category and flag any above 8% 4. Highlight month-over-month revenue trends 5. Recommend 3 specific actions to improve performance next quarter Present everything in clear tables with a brief executive summary at the top.
Example output — your results will vary based on your inputs
The AI returns a concise executive summary noting that total Q1 revenue across 4 stores was $482,000, with the Bangkok store leading at $156,000 (32% of total). It produces a table ranking all store locations by revenue, a second table of top and bottom product categories, flags "Home Accessories" with a 12.4% return rate (well above the 8% threshold), shows a line of month-over-month growth figures, and closes with three recommendations: investigate the high return rate in Home Accessories with the supplier, double down on Electronics inventory at the Bangkok store where demand outpaced stock, and run a targeted promotion at the Kuala Lumpur store where revenue dipped 7% in March.
How to Edit This
Always verify the totals the AI provides by spot-checking a few rows against your original spreadsheet. In this example, the AI correctly identified the return rate outlier, but the month-over-month percentages were off by about 0.3% due to rounding. A quick manual check confirmed the overall trends were accurate.
Common Mistakes
Trusting AI numbers without checking the source
Pasting data without column headers
Using vague prompts
Uploading sensitive data without checking privacy policies
Stopping at the first response
Tools That Work for This
ChatGPT
Upload CSV or Excel files directly, get tables and charts in response. The Advanced Data Analysis feature runs Python behind the scenes for precise calculations. Free tier supports limited uploads; Plus unlocks full access.
Claude
Handles very long data pastes thanks to a large context window (up to 200,000 tokens). Excels at step-by-step reasoning through complex datasets. Supports CSV uploads on all paid plans.
Google Gemini
Integrates natively with Google Sheets, making it ideal if your data already lives in the Google ecosystem. Upload files or paste data for instant analysis with visual chart suggestions.
Google NotebookLM
Upload multiple spreadsheets and documents as sources, then ask questions across all of them. Great for comparing data from different reports or time periods in one place.
Julius AI
A dedicated AI data analysis tool that generates Python code, charts, and statistical tests from plain English prompts. Particularly strong for visualisation and regression analysis.
Frequently Asked Questions
Not at all. Every prompt in this collection is designed for plain English use with ChatGPT, Claude, or Gemini. You paste your data and a prompt, and the AI handles all the technical work. If you want to learn Python for data analysis later, the AI can even write and explain the code for you.
It varies by platform. Claude supports up to 200,000 tokens (roughly 500 pages of text), making it the best choice for large datasets. ChatGPT handles files up to 512 MB when uploaded. Gemini works well with Google Sheets integration. For very large files, paste the first 50 rows with headers and ask the AI to describe the analysis it would run on the full dataset.
Check your organisation's data policy first. For sensitive data, use Claude's zero-retention API, disable ChatGPT's training toggle in settings, or anonymise the data before pasting (replace names with codes, round exact figures). Many Asian enterprises use private deployments or API access for compliance.
Each has strengths. ChatGPT's Advanced Data Analysis runs actual Python code for precise maths. Claude handles the longest documents and excels at reasoning through complex data. Gemini integrates with Google Sheets natively. For most users, start with whichever chatbot you already use and switch only if you hit a limitation.
AI is excellent at handling the repetitive parts of analysis: cleaning, summarising, spotting obvious patterns. But it cannot replace a skilled analyst's ability to ask the right business questions, understand context that is not in the data, or make judgment calls about strategy. Think of it as a powerful assistant, not a replacement.
Next Steps
Try the Quick Data Summary prompt with your most recent monthly report and see what patterns the AI spots. Once you are comfortable, move on to the Sales Trend Analyser or Budget Variance Checker for deeper insights. For more advanced techniques, check out our guide on AI Spreadsheet Automation: Beyond Basic Formulas and Leveraging Data Analysis AI for Workplace Decision-Making.