Convert PDF Back to Excel: Recovering a Lost Spreadsheet

You can convert a PDF back to Excel when it was made from a spreadsheet, and the values and layout mostly return, but formulas, links and named ranges do not, because the PDF stores only the displayed results. Expect a table of values you must rebuild, and ask the sender for the original workbook first.

Can a PDF made from Excel be turned back into the workbook?

A PDF made from Excel can be turned back into a table of values, but not into the original workbook. The text, numbers and rough grid return, so you get a usable copy of what the sheet displayed. The workbook itself, with its formulas and structure, is gone, and no converter can read it back.

The reason is how the PDF is made. When Excel exports to PDF, it draws each cell's displayed text at a position on the page. It does not carry the formula behind the cell, the sheet's other tabs that were not printed, or the settings that made it work. What you hold is a picture of the results, in the form of text.

What usually comes back

• The displayed numbers and labels, as they were printed, including rounding. A cell that held 1234.5678 and displayed 1,234.57 comes back as 1,234.57.
• Row and column order, if the converter reads the grid well. A clean, gridded sheet converts better than a decorated one.
• Headings and totals, as plain values.

What does not come back

• Formulas, which become the numbers they produced.
• Hidden rows, columns and sheets, which were never printed.
• Number formats, data validation, conditional formatting and charts as live objects.
• Anything outside the print area.

A result that is rounded for display carries the rounding forever. If the sheet showed whole dollars, your recovered cells hold whole dollars, and a total rebuilt from them may differ by a few units from the printed total.

Most of the cleanup after recovery is the ordinary kind. Numbers often land as text, which making a converted sheet editable fixes, and columns may arrive stuck together, which transforming the data with Power Query handles. For the general question of which PDFs convert at all, see whether you can turn a PDF into an Excel file.

Formulas and links lost on the way to PDF

Formulas are lost on the way to PDF because the export keeps only each cell's result. A cell that held =SUM(B2:B9) becomes the number 4,250.00, with no trace of the sum. Cross-sheet references, external links, named ranges and lookups vanish the same way, leaving static values.

This matters because a spreadsheet's value is its logic. A budget with live formulas updates when you change an input. The recovered version looks identical and does nothing when you edit a number. Totals stay at the old figure, percentages stay fixed, and a change in one cell moves nothing else.

How to tell what a cell used to be

You can often infer the formula from the layout and the numbers:

1. Totals sit at the bottom or right of a block, often in bold, under a line. They are almost always sums.
2. Percentages next to a count or amount are usually a share of a total.
3. Repeated patterns down a column, such as price times quantity, suggest a row formula.
4. A figure that appears twice with the same value on two sheets suggests a cross-sheet link.

Test your guess against the printed numbers. If =SUM of a column equals the printed total, the guess is right.

The rounding trap

Printed values are rounded for display, so recomputed totals can differ from printed ones by small amounts. A column of three values shown as 10.4, 10.4 and 10.4 sums to 31.2 on screen, but the underlying values may have been 10.44, 10.38 and 10.41, which printed total 31.23 as 31.2. Treat a gap under the rounding step as expected, and a larger gap as a mistake in conversion.

Rebuilding totals in the recovered workbook

Rebuild totals by replacing each static total with a formula and then comparing the new result to the printed figure. Start with the totals, then the percentages, then references between sheets, and finish with named ranges. A match to the printed number confirms the formula and the conversion together.

A checklist for rebuilding

Work through the recovered file in this order. The first step is a precondition: nothing below works until the numbers are real numbers.

1. Confirm numbers are numbers. Use =ISNUMBER(B2) on a few cells. Convert any text amounts first.
2. Rebuild totals. Replace each static total with =SUM(range). Compare the result to the printed value and note any gap.
3. Rebuild percentages. Replace each static percentage with a division, such as =B2/B$10, and format the cell as a percentage.
4. Rebuild cross-sheet references. Where a figure on one tab came from another, replace it with a reference such as =Summary!C5. Check it against the printed figure.
5. Restore named ranges. Define names for ranges that the original used, such as Rate or TaxYear, and use them in the formulas that follow.
6. Check subtotals against grand totals. The sum of the subtotals must equal the grand total.
7. Lock down the result. Save a copy of the raw conversion, and keep the rebuilt workbook as a second file.

Keep a record of the gaps

If a rebuilt total differs from the printed one, write down the difference before you move on. A gap of a few cents points to rounding. A larger gap points to a missing row, a number that converted wrongly, or a formula that was not a plain sum. Resolve each before you trust the sheet.

Why ask the sender for the original workbook?

Ask the sender for the original workbook because it has everything the PDF dropped: formulas, hidden sheets, full precision and formats. It is usually faster than rebuilding, and it is exact. Converting is the right route only when the sender cannot or will not provide the file, or when the file no longer exists.

When asking wins

• The workbook has formulas you need. Rebuilding a complex model from a PDF can take longer than one email.
• Precision matters. The original holds full-precision values. The PDF holds rounded ones.
• There is more than the printed area. Hidden sheets and columns exist only in the workbook.
• You will change it. A model you plan to update should be the live original.

When converting is the only route

Sometimes there is no workbook to ask for. The author left, the file was lost, or the PDF is a bank or government document that was never a spreadsheet you can obtain. In that case, convert, then rebuild with the checklist above and compare every rebuilt total with the printed one.

A bank statement is a common example: it was never a workbook you can ask for, so converting is the normal route unless your bank offers its own CSV download. FastBankConvert is getting ready to open and is built to read a digital statement into dates, descriptions, amounts and balances; you can ask to be told when trial conversions start at Get started.

A short message to send

A request that gets a quick answer names the file, the date and the need: "I have the PDF of the budget you sent on the 3rd. Could you send the Excel file it came from? I need the formulas to update the figures." That costs the sender one attachment.