data•5 prompts
AI Excel & Spreadsheet Prompts
Excel formulas and spreadsheet logic are where AI shines brightest. Describe what you need in plain English and get working formulas instantly, even for complex nested functions.
1. Complex Formula Builder
Best: ChatGPTWrite an Excel formula that [describe what it should do]. My data: column [A] has [description], column [B] has [description]. I need the result to [expected output]. Handle these edge cases: [empty cells, errors, duplicates]. Explain the formula step by step so I can modify it later.
Describe your data layout clearly. ChatGPT has strong Excel formula knowledge and explains syntax well.
2. VBA Macro Generator
Best: ChatGPTWrite a VBA macro for Excel that [describe automation]. It should: work on the active sheet, handle errors gracefully with a message box, include comments explaining each section, and run in under [time constraint] on [row count] rows. Include a button setup instruction.
Specify the Excel version. ChatGPT generates working VBA with good error handling.
3. Data Cleanup Workflow
Best: ChatGPTI have messy data in Excel: [describe issues - e.g., "mixed date formats, extra spaces, inconsistent categories"]. Give me a step-by-step cleanup workflow using formulas or Power Query. For each step, provide the exact formula and explain what it fixes. Preserve the original data in a backup column.
Paste a few example rows showing the messy data. Be specific about which "clean" format you want.
4. Pivot Table Designer
Best: ClaudeI have data with columns: [list columns]. I want to analyze [what you want to understand]. Design a pivot table setup: which fields go in rows/columns/values/filters, which aggregation to use, recommended calculated fields, and 3 slicers that would be most useful. Also suggest a chart type to visualize the result.
Describe the business question you're trying to answer. Claude designs analytical frameworks well.
5. Google Sheets App Script
Best: ChatGPTWrite a Google Apps Script that [describe automation] in Google Sheets. Requirements: trigger on [event - e.g., edit, form submit, time], process data in sheet [name], handle errors with logging, and send notification via [email/Slack]. Include setup instructions for the trigger.
Specify whether it needs to work with Google Forms, Gmail, or other Google services.
Try These Prompts with Multiple AIs
Get responses from Claude, ChatGPT, Gemini, and more—all at once. Compare which AI handles these prompts best.
Try Council Free