Can I convert a PDF spreadsheet back to Excel with the formulas intact?

No — and this is the crucial thing to understand. When a spreadsheet is exported to PDF, only the computed results are saved; the formulas that produced them are not stored in the PDF at all. A PDF cell that shows "1,250" contains the text "1,250", not "=SUM(B2:B9)". So there is no way to "preserve" formulas that are not in the file — they were discarded at PDF export. What you can do is extract the values into Excel and then rebuild the formulas yourself. Any tool claiming to recover the original formulas from a PDF is mistaken about what a PDF contains. The honest workflow is: recover the data, re-create the formulas.

So what is the realistic workflow?

Extract the table data from the PDF into Excel (or CSV first, then Excel), which gives you the values laid out in rows and columns, then re-create the formulas in the cells that should be calculated. For a budget where column totals were formulas, you extract the numbers and re-add the SUM formulas; the data comes from the PDF, the formulas come from you. This is usually quick because you know what the formulas should be, and it gives you a genuinely live spreadsheet again. It is the same situation as recovering data from a chart — the PDF has the output, and you reconstruct the logic that generated it.

How do I extract the data cleanly?

Use a PDF-to-Excel or PDF-to-CSV extraction that respects the table structure, so the rows and columns land in the right cells rather than as a jumble. Simple, well-ruled tables extract cleanly; complex or merged-cell tables need cleanup. Verify the extracted values against the PDF, especially numbers, since extraction (and OCR, if the PDF is scanned) can misread digits and a wrong number poisons every formula you build on it. Get the data correct and correctly placed first; only then add formulas. Clean extraction is the foundation — formulas built on misaligned or misread data are worse than useless.

What if the PDF is a scan of a spreadsheet?

Then OCR it first to turn the image into text/numbers, and verify carefully — OCR misreads digits, and in a spreadsheet a single wrong digit silently corrupts results. After OCR, extract the table to Excel and proceed as normal (recover values, rebuild formulas). Scanned financial tables especially deserve a careful reconciliation pass: check totals and known values against the original. The order is OCR → extract → verify → rebuild formulas. Skipping verification on a scanned spreadsheet is how a transposed or misread figure becomes a wrong total you trust.

How do I rebuild the formulas accurately?

Work out which cells were calculated and what they computed — usually obvious from the structure (a "Total" row sums the column above, a "Difference" column subtracts two others) — and enter the corresponding formulas, then check the results match the values shown in the PDF. That last check is your verification: if your rebuilt SUM produces the same total the PDF showed, your formula and data are right; if not, something is off (a missed row, a misread value). Rebuilding from the visible structure plus matching the PDF's shown results gives you a live spreadsheet you can trust and continue working in.

Is there ever a way to keep the real formulas?

Only by going back to the source. If you (or whoever made the PDF) still have the original spreadsheet file, use that — it has the live formulas, and converting it to PDF was a one-way trip for the formula logic. So before doing extraction-and-rebuild, check whether the original .xlsx exists; recovering it is far better than reconstructing from a PDF. The PDF-to-Excel route is for when the original is genuinely lost or unavailable. The lesson for the future: keep the source spreadsheet if you will need the formulas, since a PDF is a snapshot of results, not of the working model.

Is it safe to extract a confidential spreadsheet online?

Financial spreadsheets are often sensitive, so prefer a tool that processes files locally. ScoutMyTool extracts tables to Excel/CSV and OCRs scans entirely in your browser tab, so the file never leaves your machine; you then rebuild formulas in Excel yourself. For anything confidential, confirm the tool does not upload before using it.

6 min read

PDF spreadsheet to Excel: can you preserve the formulas?

By ScoutMyTool Editorial Team · Last updated: 2026-05-22

“Convert this PDF back to Excel with the formulas” is a reasonable-sounding request with an inconvenient answer: the formulas are not in the PDF. When a spreadsheet is saved to PDF, only the results are kept — a cell that showed a SUM becomes the plain number it produced, and the formula is gone. So you cannot preserve what was never stored. What you can do, and what this guide covers honestly, is recover the data into Excel and rebuild the formulas — which is usually quick because you know what they should be. Plus the better option when it exists (find the original file) and how to verify your reconstruction is correct.

What a PDF spreadsheet actually contains

In the PDF	Reality
Cell values (numbers, text)	Stored — these you can extract
The formulas behind them	NOT stored — only the result is in the PDF
Table structure (rows/cols)	Inferred from layout on extraction
Formatting (some)	Partially recoverable

Step by step — recover data, rebuild formulas

Look for the original spreadsheet first. If the source .xlsx exists, use it — it has the live formulas. Extraction is for when the original is lost.
OCR if it is a scan. Recover text/numbers with PDF OCR and verify digits — a misread number corrupts everything downstream.
Extract the table to Excel. Use PDF to Excel (or PDF to CSV then import) — see PDF to spreadsheet and extracting complex tables.
Verify the values and placement. Check the numbers against the PDF and that rows/columns landed correctly before building anything on them.
Identify the calculated cells. Work out which cells were formulas (totals, differences, percentages) from the structure.
Rebuild the formulas. Enter the SUM/subtraction/etc. in those cells — the values came from the PDF, the formulas from you.
Check results match the PDF. Your rebuilt formula should reproduce the value the PDF showed; if not, find the missed row or misread figure.

PDF to spreadsheet: extracting the data.
Extracting complex tables: messy or merged-cell tables.
Extract data from charts: the same output-not-logic problem.
OCR + reformat: for scanned spreadsheets.
PDF for accountants: working with financial tables.
PDF to Excel tool: extract the data in your browser.
All ScoutMyTool PDF tools: the full toolkit.

FAQ

Can I convert a PDF spreadsheet back to Excel with the formulas intact?: No — and this is the crucial thing to understand. When a spreadsheet is exported to PDF, only the computed results are saved; the formulas that produced them are not stored in the PDF at all. A PDF cell that shows "1,250" contains the text "1,250", not "=SUM(B2:B9)". So there is no way to "preserve" formulas that are not in the file — they were discarded at PDF export. What you can do is extract the values into Excel and then rebuild the formulas yourself. Any tool claiming to recover the original formulas from a PDF is mistaken about what a PDF contains. The honest workflow is: recover the data, re-create the formulas.
So what is the realistic workflow?: Extract the table data from the PDF into Excel (or CSV first, then Excel), which gives you the values laid out in rows and columns, then re-create the formulas in the cells that should be calculated. For a budget where column totals were formulas, you extract the numbers and re-add the SUM formulas; the data comes from the PDF, the formulas come from you. This is usually quick because you know what the formulas should be, and it gives you a genuinely live spreadsheet again. It is the same situation as recovering data from a chart — the PDF has the output, and you reconstruct the logic that generated it.
How do I extract the data cleanly?: Use a PDF-to-Excel or PDF-to-CSV extraction that respects the table structure, so the rows and columns land in the right cells rather than as a jumble. Simple, well-ruled tables extract cleanly; complex or merged-cell tables need cleanup. Verify the extracted values against the PDF, especially numbers, since extraction (and OCR, if the PDF is scanned) can misread digits and a wrong number poisons every formula you build on it. Get the data correct and correctly placed first; only then add formulas. Clean extraction is the foundation — formulas built on misaligned or misread data are worse than useless.
What if the PDF is a scan of a spreadsheet?: Then OCR it first to turn the image into text/numbers, and verify carefully — OCR misreads digits, and in a spreadsheet a single wrong digit silently corrupts results. After OCR, extract the table to Excel and proceed as normal (recover values, rebuild formulas). Scanned financial tables especially deserve a careful reconciliation pass: check totals and known values against the original. The order is OCR → extract → verify → rebuild formulas. Skipping verification on a scanned spreadsheet is how a transposed or misread figure becomes a wrong total you trust.
How do I rebuild the formulas accurately?: Work out which cells were calculated and what they computed — usually obvious from the structure (a "Total" row sums the column above, a "Difference" column subtracts two others) — and enter the corresponding formulas, then check the results match the values shown in the PDF. That last check is your verification: if your rebuilt SUM produces the same total the PDF showed, your formula and data are right; if not, something is off (a missed row, a misread value). Rebuilding from the visible structure plus matching the PDF's shown results gives you a live spreadsheet you can trust and continue working in.
Is there ever a way to keep the real formulas?: Only by going back to the source. If you (or whoever made the PDF) still have the original spreadsheet file, use that — it has the live formulas, and converting it to PDF was a one-way trip for the formula logic. So before doing extraction-and-rebuild, check whether the original .xlsx exists; recovering it is far better than reconstructing from a PDF. The PDF-to-Excel route is for when the original is genuinely lost or unavailable. The lesson for the future: keep the source spreadsheet if you will need the formulas, since a PDF is a snapshot of results, not of the working model.
Is it safe to extract a confidential spreadsheet online?: Financial spreadsheets are often sensitive, so prefer a tool that processes files locally. ScoutMyTool extracts tables to Excel/CSV and OCRs scans entirely in your browser tab, so the file never leaves your machine; you then rebuild formulas in Excel yourself. For anything confidential, confirm the tool does not upload before using it.

Citations

Wikipedia — “Spreadsheet,” on formulas vs. computed values. en.wikipedia.org/wiki/Spreadsheet
Wikipedia — “Microsoft Excel,” the target application and its formula model. en.wikipedia.org/wiki/Microsoft_Excel
Wikipedia — “PDF” (ISO 32000), which stores rendered results, not formulas. en.wikipedia.org/wiki/PDF

Recover the data, rebuild the model

Extract a PDF table into Excel with ScoutMyTool’s in-browser tools, then re-create the formulas — your spreadsheet never leaves your machine.

Open PDF to Excel →