WrenPDF

How to Get Tables Out of a PDF and Into Excel

Copying a table from a PDF usually gives you one long jumbled column. How table extraction works, and what to do when it does not.

· 5 min read

Bank statements, price lists and invoices arrive as PDFs, but the numbers are only useful in a spreadsheet. Copy and paste usually lands everything in one column, or merges cells in strange ways.

Why copy and paste fails

As with Word conversion, a PDF does not know what a table is. It only knows that certain words are drawn at certain positions, and that some lines are drawn between them. When you copy, you get the words in drawing order, which is rarely row by row.

How extraction tools rebuild the table

A table extractor looks at the position of every word on the page. Words that line up vertically are treated as a column; words on the same baseline become a row. The result is a grid that matches what you see.

PDF to Excel does this in your browser and writes a real .xlsx file. Numbers are stored as numbers, so you can sum and sort them straight away. That matters for statements, where a total that does not add up is the first thing you want to check.

What works best

  • PDFs exported from accounting or banking software
  • Tables with clear columns, even without borders
  • One table per page, or several clearly separated tables

What makes it harder

  • Scanned PDFs: there is no text to read, only a picture of text. You would need OCR first.
  • Merged cells and multi-line rows: a description that wraps onto two lines may become two rows.
  • Rotated pages: rotate them first with Rotate PDF.

Tidy up in a few minutes

  1. Delete header and footer rows that repeat on every page.
  2. Check that negative numbers and decimals came through correctly; some statements use a comma as the decimal separator.
  3. Use Excel's "Text to Columns" on any column that still holds two values.

Your statement never leaves your device during extraction, which is exactly what you want for financial documents.

Open: PDF → Excel, free, and your file never leaves your device.