# PDF to Excel: What Survives the Trip and What Breaks

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-16
- Category: PDF to Excel basics
- Canonical: https://fastbankconvert.com/blog/pdf-to-excel-what-survives

> PDF to Excel explained: why a PDF has no real columns, which numbers, dates and layouts come across intact, and which pieces turn into junk rows.
Converting PDF to Excel keeps the text and numbers you can read on the page, but not the structure behind them. A PDF has no real columns, rows or cell types, so a converter guesses them from positions. Plain values usually survive; headers, footers, merged headings and notes often turn into junk rows.

## What does a PDF store that Excel needs?

A PDF stores drawing instructions: put this text here, draw this line there. It does not store a table. Excel needs rows, columns and cell types, and none of those exist inside the file, so every PDF to Excel tool has to rebuild them from where things sit on the page.

### Text placed by position

Inside a PDF, a row of a bank-style table is a series of short text runs, each with an x and y position on the page. The word "Rent" and the number "1,200.00" next to it are two separate pieces with no link between them. The file never says they share a row. A reader sees the alignment and fills in the structure automatically. Software has to measure the gaps.

### Lines are decoration, not cell borders

Many tables are drawn with thin rules between rows and columns. Those rules are just strokes. Some converters use them as hints about where cells begin and end. Microsoft's own PDF connector, for example, has an option that controls whether border lines are always enforced as cell boundaries or treated as one hint among several; it is described in the [Power Query PDF connector documentation](https://learn.microsoft.com/en-us/power-query/connectors/pdf). Tables with no rules at all, which is common for statements and reports, force the tool to rely on spacing alone.

### Why this explains the junk

Once you accept that columns are inferred, most conversion problems make sense. A wide gap inside a description can be read as a column break. A narrow gap between two columns can be read as one. A page number that sits at the same height as a total can end up in the same row. The tool did not fail to copy the text. It guessed the structure wrongly.

## Text, numbers and dates in a PDF to Excel conversion

Most text survives intact, and numbers and dates usually arrive as the characters you saw. The risk is the type of the cell. A good conversion gives you real numbers and real dates; a weaker one gives you text that looks like numbers and dates, which will not sort, sum or filter correctly.

### Numbers

A number in a PDF is just characters: digits, commas, a decimal point, maybe a minus sign or brackets. Excel can only treat them as a number if the converter writes them as a number. Check the result with a quick test: select the column and look at the status bar at the bottom. If Excel shows a Sum, the cells are numbers. If it shows only a Count, they are text. The fix for text numbers has its own guide on [why converted numbers are stored as text](/blog/pdf-to-excel-editable#why-are-converted-numbers-stored-as-text).

Watch for formats that break the pattern:

- **Negative numbers in brackets**, such as (412.80), which some tools keep as text.
- **Trailing minus signs**, such as 412.80-.
- **Currency symbols and thousands separators** that change with locale.
- **Credit and debit markers** such as CR and DR placed after the amount.

### Dates

A date in a PDF is also only characters. If the PDF prints 03/04/2026, Excel and the converter must agree on whether that is March 4 or April 3. That depends on regional settings, and the PDF gives no hint. Dates printed as month and day with no year, common on statements, need a year from somewhere else. Always compare a few converted dates with the page, especially around the end of the year.

### A short example

The values below are examples, not from a real file. They show how one printed line can arrive.

| Printed on the PDF | Good result in Excel | Weak result in Excel |
| --- | --- | --- |
| 1,200.00 | Number 1200 | Text "1,200.00" |
| (412.80) | Number -412.8 | Text "(412.80)" |
| 03/14/2026 | Date 14 Mar 2026 | Text "03/14/2026" |
| REF 00457 | Text "REF 00457" | Number 457 with the zeros lost |

The last row matters: identifiers that look like numbers can lose leading zeros if a tool over-converts them.

## Page headers and footers after PDF to Excel

Page headers and footers are the layout pieces most likely to become junk rows. A header is the text repeated at the top of every page, and a footer is the text repeated at the bottom, such as a page number. Excel has no idea they are not data, so they arrive as rows between your real ones.

### How repeated text spoils a table

Take a table that runs across four pages. Each page may repeat the column headings at the top and add "Page 2 of 4" at the bottom. After conversion you get three extra heading rows in the middle of the data and four page-number rows. Sorting the sheet scatters them. A SUM over the amount column may skip them or choke on them. The usual fix is to filter them out, and the cleanup guide shows [how to remove header and footer rows with Power Query filters](/blog/transform-pdf-to-excel-power-query-cleanup#removing-header-and-footer-rows-with-power-query-filters).

### What each PDF element becomes

The table below lists common PDF elements and what they usually turn into. Treat it as a guide to what to check, since results vary by tool.

| PDF element | What it becomes in Excel |
| --- | --- |
| Text run in a table | A cell value in the matching column, if the gaps are read correctly |
| Ruled line | Usually nothing; it may help the tool place cell boundaries |
| Page header | A repeated row at the start of each page's data |
| Footnote | A row of text at the bottom of the data, often in column A |
| Logo or image | Dropped, or an empty cell where it sat |
| Merged heading | Text in the first cell of its span, with the cells beside it empty |
| Total line | A normal row; the label and amount may land in different columns |
| Page number | A stray row such as "Page 2 of 4" |

### Totals need a second look

A total line is easy to mishandle. It often has its label in the description column and the amount in the same column as the rows above, or shifted by one. Do not assume it landed under the right column. If a formula will sum the data, make sure the printed total is not inside the range, or you will count it twice.

## Is a PDF to Excel result ever exact?

A PDF to Excel result can be exact in the values and still differ in the layout. Clean text PDFs with simple tables often convert with every number correct. What you should not expect is the same look, the same column widths, or the same fonts. The workbook holds data, not a copy of the page.

### What to expect on a good file

On a clear digital table, expect the amounts, dates and descriptions to match the page. Expect new column widths, a default font, and no logos. Sheet structure may differ: one table may arrive as one sheet, or as one sheet per page, depending on the tool. The post on [saving a PDF as Excel straight from a reader](/blog/save-pdf-as-excel) shows how to inspect that saved workbook.

### Proving the result

You do not need to compare every cell. A few checks give most of the confidence:

1. Count the rows and compare with the PDF.
2. Add up the amount column and compare with the printed total.
3. Spot-check the first and last row of each original page.
4. Look for blank rows and text-formatted numbers.

On bank statements, the balance check is stronger. If the opening balance plus every credit, minus every debit, equals the closing balance, the rows account for every change in the balance. FastBankConvert, which is getting ready to open, runs that check and tells you before you download if the balances do not add up.

### Pulling out only one table

If you only need one table from a long PDF, the problem is narrower than converting the whole file. The guide to [extracting a table from a PDF](/blog/extract-table-from-pdf) covers how table detection decides what counts as a table.

## PDF files that should never go to Excel

Some PDFs are the wrong source for a spreadsheet. Excel works with rows and columns of values. If the document is mostly prose, a designed brochure, a form, or a poor photo of a page, converting it creates more work than it saves.

### Poor candidates

Think twice before converting these:

- **Mostly narrative documents**, where the numbers sit inside sentences.
- **Forms** with boxes, checkboxes and labels scattered across the page.
- **Image-only scans**, unless the tool has OCR (optical character recognition, the step that reads text from a picture).
- **Documents with mixed layouts** on a single page, such as a table beside a chart beside a paragraph.
- **Handwritten pages**, which OCR reads poorly.

### What to do instead

For a handful of values, type them. For a form, ask the sender for the data in a table. For a scan, check what the tool does with images before you trust it. For a bank statement, it is better to get the bank's own digital PDF than a scan of a printout, since a digital file holds the exact characters and a scan has to be read from a picture.

If your PDF is a good candidate, the next question is which file type to save as. The post on [choosing XLS or XLSX when you convert a PDF](/blog/convert-pdf-to-xls-or-xlsx) covers that, and [FastBankConvert](/) is the option to watch if your file is a digital bank statement.