Remove Formulas, Keep Values
Freeze a workbook by turning each formula into the value it shows. For XLSX files the formatting stays untouched, and the work is done on your own device.
- Free, no sign-up
- Files stay on your device
- XLSX formatting kept
- Whole workbook at once
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
Remove spreadsheet formulas (keep values) in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your workbook
Drop one or more XLSX, XLSM, XLS, XLSB or ODS files on the page.
- STEP 02
Run the conversion
There are no settings to adjust. Every formula on every sheet is replaced by its value.
- STEP 03
Download the file
A note says how many formulas were replaced.
What Remove spreadsheet formulas (keep values) does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Formatting survives in XLSXXLSX and XLSM files are edited directly inside the package, so colors, fonts, charts and pictures stay as they were.
- Every sheet at onceNo need to copy and paste special sheet by sheet.
- Tables handledCalculated columns in Excel tables are cleared as well, so formulas are not put back.
- Other formats tooXLS, XLSB and ODS files are converted too, though through a route that does not keep styling.
- Private by designYour workbook stays in the browser.
Good to know
- Uses saved resultsThe value is the last result stored in the file. A workbook created by a script that never calculated may have no stored value, leaving that cell empty.
- Formatting caveat for other formatsXLS, XLSB and ODS files are rewritten, so their colors and fonts are not kept. Choose XLSX if styling matters.
- No undoThe formulas are gone in the new file. Keep your original workbook.
Your spreadsheets never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use Remove spreadsheet formulas (keep values)
Send numbers, not logic
Share results without revealing how you calculated them.
Stop links breaking
Remove references to other workbooks before sending.
Lock a monthly snapshot
Save figures that will no longer change.
Speed up a heavy file
Fewer formulas means faster opening and recalculation.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How it is different from Paste Special
Paste Special, Values works on a selected range. Here every formula in the workbook is processed at once. Because XLSX files are edited in place, the look of the workbook does not change at all.
Before you convert
Open the file in Excel once and let it calculate, so the stored results are current. To see which formulas exist first, run the Excel formula viewer.
If you only need the data as text, Excel to CSV has the same effect. To check what a file contains, such as charts or macros, use the Spreadsheet metadata viewer.
Remember that some formulas return different results on different days, such as TODAY or NOW. The value saved in the file is the one from the last time it was calculated, and that is the one you will get.
Questions, answered
How do I convert all formulas to values in Excel?
Add the workbook here and download it. All formulas on all sheets are replaced with their results.
Is my workbook uploaded?
No. It is processed in your browser, so confidential models stay on your device.
Will my formatting be kept?
For XLSX and XLSM files, yes. For XLS, XLSB and ODS the styling is not kept.
Can I get the formulas back?
No, so keep the original file.
Can I process several workbooks?
Yes, add them together.
Is it usable on a Mac or phone?
Yes, in any current browser, although large workbooks are happier on a computer.