Excel Formula Extractor
Drop an Excel (.xlsx) file to extract every formula across all sheets. See the sheet name, cell reference, formula, and current displayed value. Download the full list as CSV. Nothing is uploaded — runs entirely in your browser.
Drop your .xlsx file here
or click to browse · max 50 MB
How to use the Excel Formula Extractor
- Drop an .xlsx workbook onto the drop area, or click it to browse. Files up to 50 MB are accepted.
- The tool reads every sheet and lists each cell that contains a formula: the sheet name, the cell reference, the formula text and the value Excel last saved for it.
- Check the summary cards for the total number of formulas, how many sheets were scanned, how many of them contain formulas, and how many distinct formulas there are.
- If more than one sheet has formulas, the "Formulas by Sheet" panel shows a count per sheet.
- Click Download CSV to save the full list as <workbook>-formulas.csv, with the columns Sheet, Cell, Formula and Displayed Value.
Worked example
A small workbook, budget.xlsx, has two sheets. The Sales sheet multiplies quantity by price and totals the result. The Summary sheet pulls that total across.
Input (budget.xlsx)
Sales sheet
A B C D
1 Item Qty Price Total
2 Widget 4 2.5 =B2*C2
3 Gadget 2 7 =B3*C3
4 =SUM(D2:D3)
Summary sheet
A B
1 Sales total =Sales!D4Output (formula list)
Sheet Cell Formula Value
Sales D2 =B2*C2 10
Sales D3 =B3*C3 14
Sales D4 =SUM(D2:D3) 24
Summary B1 =Sales!D4 24
Total formulas: 4 Sheets scanned: 2
Sheets with formulas: 2 Unique formulas: 4Plain values such as "Widget" or 4 are skipped. Only cells with a formula are listed. The Value column is the result stored in the file the last time it was saved in Excel. The tool does not recalculate anything.
Frequently Asked Questions
How do I see all formulas in an Excel workbook at once?
In Excel you can press Ctrl+` (or use Formulas > Show Formulas), but that works one sheet at a time and only changes the view. This tool lists every formula from every sheet in one table that you can sort through or download as CSV.
Does the tool recalculate my formulas?
No. It shows the value that was saved in the file with each formula. If a workbook was created by software that does not store calculated results, the Value column is empty for those cells.
Are hidden sheets included?
Yes. Every sheet in the workbook is scanned, including hidden ones. That makes it useful for checking a file you received from someone else before you rely on its numbers.
How can I find broken references?
A formula that points at deleted cells contains #REF! in its text. Download the CSV and search the Formula column for #REF! to find every broken reference and the cell it lives in.
Is my workbook uploaded anywhere?
No. The file is read by JavaScript in this browser tab. Nothing is sent to a server, and the list disappears when you close the tab.
Related tools
Excel Sheet Extractor
Export any single sheet of a workbook to CSV, Parquet, JSON or Excel.
Excel to CSV
Convert the first sheet of an .xlsx file to CSV.
Excel Viewer
Open an .xlsx file and browse its rows without Excel.
Data Profiler
Row count, column types, null rates and numeric stats for a file.
SQL Query Tool
Query Excel, CSV and Parquet files with SQL in your browser.
Type Inference Report
Detect the data type of every column and get SQL type suggestions.
All Excel Tools
Every Excel converter and cleanup tool on the site.