PDF to Excel

A PDF does not store tables. It stores positioned text: this character at these coordinates, and nothing more. What your eye reads as a grid of rows and columns is, to the file, a set of strings that happen to line up. Nothing records which column a value belonged to, or that a column existed at all.

Converting to Excel therefore means rebuilding intent from geometry: grouping characters into cells, inferring column boundaries from vertical white space, spotting header rows, and deciding where one table ends and the next paragraph begins. It is inference, not reading.

That makes results predictable rather than random. A well-aligned statement rebuilds almost perfectly; a table with merged cells, two-level headers and footnotes tucked between rows will need some cleanup, because the information needed to decide was never written into the file.

Every page is analysed twice. The first pass follows ruling lines: when a table is drawn with borders, the strokes mark out the cells and nothing is more reliable. The second pass ignores lines entirely and works from how the text lines up, looking for the vertical lanes of white space that columns always leave behind.

Both are needed because real tables come in two families. Accounts, invoices and official forms are usually bordered. Bank statements, price lists and exports from internal systems almost never are; they hold together only by alignment, and line-based detection would see nothing at all. The better result wins, page by page, so a report that mixes both styles needs only one pass.

This is the detail that decides whether a conversion saves time or costs it. An amount extracted as text looks like a number and lines up like one, but Excel treats it as a string, the SUM comes back as zero, and you spend a quarter of an hour converting columns before any real work starts.

Numeric values are written into real numeric cells, so you can sort, filter and total as soon as the file opens. One caution: decimal and thousands separators vary between documents, and a table written in another country's convention can be misread, so check a totals column before trusting the rest of a file whose origin you do not know.

Use PDF to Excel when the value is in the grid: price lists, financial tables, inventories, timetables and data exports you want to sort or total. Each source page becomes its own worksheet, named Page 1, Page 2 and so on, and several tables on one page are stacked with a blank row between them.

Use PDF to Word when the value is in the prose: letters, contracts and reports where layout and paragraphs matter more than cells. For bank and credit card statements, the Bank Statement to Excel converter goes further, joining descriptions that wrap over several lines and checking the running balance.