Guide · 20 prompts
Best ChatGPT prompts for Excel and data
Every prompt below is tagged as working in ChatGPT. Open any prompt for the full text, fill-in blanks and step-by-step instructions.
This guide is presented by your brandSponsored · open- 1 · Data · attach file Clean a messy spreadsheet
Fix duplicates, formats and errors in a CSV or Excel file. - 2 · Data · attach file Make a chart from my data
The right chart for your data, with a clear message. - 3 · Data Write an Excel or Google Sheets formula
The formula you need, explained. - 4 · Data · attach screenshot Turn a screenshot of a table into data
Extract a table from an image into rows you can paste. - 5 · Data · attach file Analyze my sales data
Trends, top products and what's changing. - 6 · Data Build a dashboard plan
Which metrics and charts to put on a dashboard. - 7 · Data Write a Python data analysis script
Reproducible analysis with pandas. - 8 · Data · attach file Budget spreadsheet from my bank export
Categorize spending and see where money goes. - 9 · Data · attach file Forecast a number from past data
A simple, explainable forecast. - 10 · Data · attach screenshot Check a chart for misleading design
Spot truncated axes, cherry-picking and other tricks. - 11 · Data Write SQL to answer a business question
From a question to a query that runs. - 12 · Data · attach screenshot Read a chart or graph for me
Understand what a chart actually says. - 13 · Money · attach file Make a monthly budget from my bank statement
Turn a statement export into categories and a realistic budget. - 14 · Data · attach file Clean and analyze a spreadsheet
Fix messy data and find the story. - 15 · Data Build a budget spreadsheet template
A ready-to-use budget layout with formulas. - 16 · Money Help me with a personal budget
A realistic budget and savings plan. - 17 · Data · attach file Find trends in sales data
What's growing, shrinking and why. - 18 · Data Write Excel formulas for my problem
The formula, explained. - 19 · Money Plan a first-paycheck budget
Split a first job's paycheck into spending, saving and goals without spreadsheets. - 20 · Data Act as a text-based spreadsheet
A 10-row text spreadsheet you fill with formulas and values; the AI replies only with the updated table.