I Gave ChatGPT a Messy Excel File. Here's What Happened, by Leila Gharani on YouTube. 10 min 31 s.
- Video length
- 10 min 31 s
- Time to do it
- 30 minutes
- Difficulty
- Medium
- Steps
- 10
What you need
Steps
Make a copy of your workbook and remove or replace names, emails, account numbers and anything confidential. Follow your company's AI rules before uploading anything.
Open a new ChatGPT chat and paste guardrail rules first. Tell it to use only the data in the file, say when something is unclear, and never guess values.
Attach the workbook and ask ChatGPT to inspect it before analyzing. Have it list each sheet, its columns, the row count and how the sheets link through codes.
Read the inspection answer and correct anything wrong. If it misreads a column or a code, explain the fix in a follow-up message before going further.
Ask ChatGPT to check a few basic numbers you can confirm yourself in Excel, such as total sales or row counts. Compare its figures with your own formulas.
Request the first real analysis, for example sales by region and channel. Ask it to show the steps and the fields it used so you can follow the logic.
Rebuild the same result in Excel with a pivot table or Power Pivot model. If the numbers differ, find out why before you accept either answer.
Run a harder test, like products with a negative profit margin, and ask ChatGPT to flag any rows it is unsure about.
Ask a question the file cannot answer to see if ChatGPT invents a result. A good answer should say the data is missing.
Save the prompts that worked as a template so you can reuse the same guardrails and checks on the next file.
Tips and common mistakes
Never upload real customer or company data. Anonymize it first and check your employer's AI policy.
Always verify key totals in Excel yourself. A confident answer from ChatGPT can still be wrong.
Paid ChatGPT with Thinking mode handles multi-sheet logic better, but the checking steps still matter.
Ask ChatGPT to explain which columns and codes it used so errors are easy to spot.
Questions
Can ChatGPT open an Excel file with several sheets?
Yes, you can attach a workbook and ask it to list the sheets and columns first. Related sheets linked by codes are harder, so have it explain the links before analyzing.
Is the free version of ChatGPT enough?
It can inspect and summarize a small file, but limits on file size and reasoning make paid Thinking mode more reliable for multi-sheet analysis. Either way, check the answers in Excel.
What if ChatGPT gives a different total than Excel?
Rebuild the figure with a pivot table or Power Pivot and compare row by row. The mismatch usually comes from a misread column, a filter or a code that did not match.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
