Compare Excel Formulas - Free Formula vs Value Diff

Stored formulas, not recalculated results

Catch formulas that changed—or were replaced by values

Formula to formula

Review the old and new stored expressions when the same coordinate contains a formula in both workbooks.

Formula to value

Surface a cell whose original formula became a hard-coded value in the revised workbook.

Value to formula

See when a previously entered value was replaced by a stored formula expression.

Filter by worksheet and formula type

After comparing, choose a worksheet and use Formula changes to focus on all three formula transitions. Search for a cell or expression. Reset filters returns to the full table; CSV and the handoff report always retain all supported changes.

WorkbookDiff compares stored formula expressions by cell coordinate. It is not a formula authoring assistant, dependency mapper, or recalculation engine, and it cannot reconcile formulas after rows are reordered.

Exact-output example

See the formula transition, not only the displayed result

ChangeCellOriginalRevised

Formula changedForecast!F8=SUM(F2:F7)=SUM(F2:F7)*1.05

Formula → valueBudget!B12=B8+B926500

Value → formulaInputs!D40.08=Rates!B2

The example shows the type of stored-expression difference WorkbookDiff reports. It does not prove that two different formulas are mathematically equivalent.

Controlled old/new workbook pair

Run the exact formula-change audit proof

Download both synthetic `.xlsx` files, open the main tool, select Original first and Revised second, then compare locally. The displayed totals stay the same while the stored calculation logic changes.

1. Download Original

Contains the starting formula/value types at the same Budget coordinates.

Download Original XLSX

2. Download Revised

Contains one formula edit, one formula replaced by value, and one value replaced by formula.

Download Revised XLSX

30-second controlled proof

See matching totals hide three formula-type changes

The privacy-enhanced YouTube player loads only after you press play. The video uses the same synthetic starter pair and does not claim a formal audit or customer result.

Watch on YouTube.

How to check whether a formula was overwritten

Keep an earlier copy with the formula and a revised copy. A single file cannot show what used to be there.
Check that rows and columns still line up. Inserted or moved rows can create noisy coordinate-based differences; this tool does not align them.
Compare the two XLSX workbooks locally, then select Formula changes or the exact Formula replaced by value type.
Use the worksheet filter and cell search to inspect the original expression and revised value. A replacement is a review finding, not proof of an error: intentional hard-coding is possible.
Export the full free CSV, or annotate the optional handoff report. Keep the original workbook pair for your own records.

Need a private workflow? Read how browser-local comparison works. Need a review trail? See the CSV difference report guide.

Frequently asked questions

How can I detect formula replaced by value changes?

Yes, when the original and revised XLSX workbooks stay coordinate-aligned. WorkbookDiff can surface a stored formula at a cell in one version and a stored value at the same cell in the other.

Does it recalculate formulas?

No. It compares stored expressions and stored values; it does not execute Excel's calculation engine.

Can it match formulas after rows move?

No. Reordered records require key-based reconciliation before field comparison.

Can I export the findings?

Yes. Run the main comparison and export all supported differences as a free CSV. Worksheet, formula and text filters affect the displayed table, not the CSV export.

Is comparison free, and do I need an account?

Comparing two supported XLSX files and exporting the CSV difference report are free, with no signup. The optional paid audit handoff report is a separate product.

Can I compare XLS or CSV files?

No. The comparison tool accepts only unencrypted .xlsx workbooks, up to 20 MB per file. It does not accept .xls, .xlsm, .xlsb, CSV or ODS. CSV is an export format, not a comparison input.

How can I compare formulas in Excel with FORMULATEXT?

For two tabs in one workbook, use =EXACT(IFERROR(FORMULATEXT(Old!B2),"[no formula]"),IFERROR(FORMULATEXT(New!B2),"[no formula]")) in a helper sheet. TRUE means the returned formula text matches case-sensitively. This does not compare constant values or prove that formulas are equivalent.

Are relative and absolute references treated as equivalent?

No. =A2*$F$1 and =$A$2*$F$1 have different stored expressions and are reported as a formula change at the same coordinate. WorkbookDiff does not normalize references or prove mathematical equivalence.

What if only the stored formula result changes?

If the formula expression is unchanged but its stored result differs, WorkbookDiff reports cell-value-changed. If both the expression and result differ, the change is categorized as a formula change and includes the before and after formula/value data.

Free formula review or an optional handoff report

Comparison and the complete CSV export are free, with no signup. The optional $19 one-time audit handoff report adds your review notes with HTML / print export; it is not an independent audit. Workbook bytes are processed locally in your browser, not uploaded for comparison. This does not mean the website makes zero network requests.

Need more than formulas? Compare two Excel files online and export an Excel difference report CSV. For moved records, try the separate reconciliation beta, which compares saved values rather than formula expressions. Compare free features and proposed plans.

Worked example: a changed formula with the same stored result

Synthetic before and after XLSX content, same worksheet and cell coordinates
Cell	Before	After
Budget!B2	=SUM(B3:B4), stored result 300	=B3+B4, stored result 300
Budget!B3	100	100
Budget!B4	200	200

Create two otherwise identical XLSX files with these stored formulas and results. Budget!B2 is reported as cell-formula-changed even though both stored results are 300. WorkbookDiff compares expressions; it does not calculate or judge the formula.

Microsoft Spreadsheet Compare / Inquire vs WorkbookDiff

Desktop comparison suite or focused browser-local version diff
Workflow	Microsoft Spreadsheet Compare / Inquire	WorkbookDiff
Platform	Windows desktop Excel tools; Spreadsheet Compare and Inquire are not available on Mac.	Browser-based local processing, including Safari and Chrome on macOS; no Excel add-in required.
Availability	Available with Office Professional Plus or Microsoft 365 Apps for enterprise; edition and installation matter.	Free XLSX comparison and CSV export without signup. Optional paid handoff report is separate.
Scope	Spreadsheet Compare can compare values, formulas, formatting and VBA; Inquire provides workbook analysis.	Aligned XLSX values, stored formulas, worksheet visibility, hidden rows/columns and used range. No formatting or VBA comparison; no recalculation.

WorkbookDiff is not a feature-for-feature replacement for the Microsoft desktop tools. Check your workbook layout and required comparison scope before choosing.

Microsoft documents the desktop workflow in Basic tasks in Spreadsheet Compare.

Formula vs value changes: what gets reported

Synthetic aligned-cell examples
Cell	Before	After	Reported change
Budget!C2	=B2*2; result 200	=B2*3; result 300	cell-formula-changed
Budget!D2	=SUM(B3:B4); result 300	300 (constant)	cell-formula-replaced-by-value
Budget!E2	300 (constant)	=SUM(B3:B4); result 300	cell-value-replaced-by-formula
Budget!F2	=B2*2; result 200	=B2*2; result 250	cell-value-changed

These are stored expressions and stored values. WorkbookDiff does not recalculate formulas; save recalculated copies in Excel first if fresh results matter.

Relative vs absolute references

=A2*$F$1 lets A2 move when copied; =$A$2*$F$1 fixes both references. At the same cell address, changing one to the other is a stored-expression difference even if the current result is identical. Mixed references such as $A2 and A$2 also have different copy behavior.

WorkbookDiff does not normalize copied formulas into a relative pattern, follow shifted rows, or prove that two expressions are equivalent. Align workbook copies first.

FORMULATEXT in Excel vs WorkbookDiff

For two tabs named Old and New in one workbook, enter this helper formula for B2 and fill across the range you need:

=EXACT(IFERROR(FORMULATEXT(Old!B2),"[no formula]"),IFERROR(FORMULATEXT(New!B2),"[no formula]"))

EXACT makes this text check case-sensitive: TRUE means matching returned text; FALSE identifies a text difference. IFERROR also hides errors other than a non-formula cell, so inspect errors separately. Two constants both return the placeholder, even if their values differ. Formula text can also be unavailable for protected or inaccessible cells; external workbook references require the source workbook to be open.

Use FORMULATEXT for a small targeted check inside Excel. Use WorkbookDiff for two saved XLSX versions when you need formula-change categories, worksheet filters and a full free CSV. Neither text matching nor WorkbookDiff proves calculation correctness.

For values across tabs, see compare two Excel sheets. For the Windows desktop suite, read our Microsoft Spreadsheet Compare guide. For broader file and folder tasks, review the Beyond Compare alternative for Excel.

Compare guides

Choose the guide for your comparison task: Compare Excel files without uploading · Compare Excel formulas and detect formula replaced by value changes · Export an Excel difference report CSV · Compare two Excel files · Excel diff for XLSX workbooks · Compare Excel files on Mac. · Compare two Excel sheets · Beyond Compare alternative for Excel · Microsoft Spreadsheet Compare alternative

Alternatives compared

Choose by workflow, supported inputs, exports and licensing.