Compare Two Excel Files With AI and Find What Changed

The problem

You have two versions of the same spreadsheet, such as Customers-August.xlsx and Customers-September.xlsx, or Budget-v1.xlsx and Budget-v2.xlsx. You want to know what was added, what disappeared, which values changed and whether any formulas changed. Checking hundreds of rows by hand is slow and easy to get wrong. AI can compare the two files and give you a readable change report.

What you need

• The OLD Excel file
• The NEW Excel file
• ChatGPT or Claude
• A clear idea of which file is OLD and which is NEW
• Ideally, a column that identifies each record, such as Customer ID, Invoice Number, Product Code, Email Address or Order Number. AI uses this to recognise the same record in both files.

Safety first

Spreadsheets can contain sensitive information. Before uploading, check for customer names, email addresses, phone numbers, financial information, employee information, passwords and confidential business data. Only upload files you are authorised to use with your chosen AI service. If necessary, work from copies with sensitive columns removed. AI should only read the files: it must not modify either spreadsheet, and it must not guess that two rows are the same record without a reliable match.

Steps

1. Make sure you know which spreadsheet is the OLD version and which is the NEW version. Rename copies clearly if necessary, such as Customer-List-OLD.xlsx and Customer-List-NEW.xlsx.
2. Upload both files to ChatGPT or Claude.
3. Paste the supplied comparison prompt and replace [OLD FILE NAME] and [NEW FILE NAME] with the real file names. AI should first list the worksheet names in both files. If a sheet exists in one version but not the other, it should say so clearly rather than silently comparing only the first sheet.
4. Read the CHANGE SUMMARY first, then inspect the detailed changes that matter. For example, if the OLD file has customers 1021 Maria Jones, 1022 John Smith (Active, $250) and 1023 Sam Lee, and the NEW file has 1021 Maria Jones, 1022 John Smith (Inactive, $0) and 1024 Anna Brown, AI should report: ADDED 1024 Anna Brown; REMOVED 1023 Sam Lee; CHANGED 1022 John Smith, Status Active → Inactive and Balance $250 → $0. Do not automatically accept every match AI makes if the spreadsheet has no reliable ID column.
5. If the workbook contains formulas, check the FORMULA CHANGES section separately from ordinary value changes. A change such as =SUM(B2:B10) → =SUM(B2:B12) can matter even if the displayed result currently looks similar. If the AI tool cannot reliably inspect formulas in the uploaded workbook, it must say so instead of claiming it checked them.

What success looks like

Before: you have two spreadsheets and no practical way to see what changed. After: you have a clear report split into ADDED, REMOVED, CHANGED, FORMULA CHANGES and NEEDS REVIEW, and every changed record shows OLD VALUE → NEW VALUE. You can now verify the important differences directly in Excel. AI comparison is useful, but important changes should still be checked against the original spreadsheets, especially money, quantities, dates, formulas, customer records and accounting data. AI can help find differences. The original files remain the source of truth.

If it goes wrong

If AI gives a vague summary instead of exact changes, send this follow-up: Please redo the comparison as a structured change report. Do not summarise generally. For every difference, show: IDENTIFIER COLUMN OLD VALUE NEW VALUE Separate the results into: ADDED REMOVED CHANGED FORMULA CHANGES NEEDS REVIEW Do not guess matches. If there is no reliable identifier, tell me that before continuing. If your spreadsheet has no unique ID column, send this instead: I do not have a clear unique ID column. Before comparing the files, suggest the safest way to match records using the columns that actually exist. Do not make changes yet. Tell me: 1. which column or combination of columns might identify a record; 2. where duplicate matches could occur; 3. which records would be uncertain. Label uncertain matches: NEEDS REVIEW.