ChatGPT Prompts for Excel

Excel remains the most widely used data tool in business, and ChatGPT has become the fastest way to solve spreadsheet problems that would otherwise require hours of Googling or trial-and-error. The key to getting accurate Excel formulas from AI is providing precise context about your data structure. Instead of asking "how do I look up a value," describe your exact setup: "Column A has product IDs, Column B has product names, Column C has prices. I need a formula in D2 that finds the price for a product ID entered in cell F1. The list has 500 rows and may have duplicates — return the first match." This level of detail prevents the model from suggesting VLOOKUP when you need INDEX-MATCH, or returning a formula that breaks on edge cases.

VBA macro prompts should specify the exact action you want automated, the sheet and range names involved, whether the macro should handle errors, and any user interaction needed (input boxes, confirmations). For complex macros, describe the workflow step by step: "Loop through each row in Sheet1 column A. If the value matches any value in Sheet2 column B, copy the entire row to Sheet3. Skip blank rows. Show a message box with the count when done." Always ask the model to include error handling and comments. For pivot table construction, describe your raw data structure, the fields you want in rows, columns, values, and filters, and the aggregation type (sum, count, average). The model can provide step-by-step instructions or Power Query M code for more complex transformations.

Data cleaning is where AI-assisted Excel work delivers the highest ROI. Describe the messy data pattern ("dates in mixed formats: MM/DD/YYYY, DD-Mon-YY, and plain text like January 5 2024") and the desired clean format. The model will generate the appropriate combination of TEXT, DATEVALUE, SUBSTITUTE, and nested IF formulas, or suggest a Power Query solution for large-scale cleaning. For data analysis prompts, describe your dataset, the question you are trying to answer, and your analysis experience level. Ask for both the formula approach and an explanation of the logic — this builds your Excel skills while solving the immediate problem. Save your best Excel prompts as templates with placeholder descriptions for data structure, so you can reuse them across different spreadsheets.