Maher PDF

How to Convert PDF Tables to Excel Without Retyping

By Maher. Published October 6, 2026.

Retyping a table from a PDF is slow and error-prone. Converting it to Excel gets the data into cells in seconds, but the result still needs checking, especially for numbers. Here is how to get usable spreadsheet data and confirm it is right.

What converts well

Tables with visible grid lines are the easiest case. Bank statements, invoices, bills of quantities, price lists, and lab or test reports exported from software usually have clear lines and consistent columns. PDF to Excel detects those grids and places each value in the matching cell, merges cells that span columns or rows, and adds borders.

Harder cases are tables without lines (columns separated only by spacing), tables split across pages with repeated headers, and scanned tables. These convert, but expect to move some cells.

Step by step

  1. Isolate the table pages. If the table is on pages 4 to 9 of a 40-page report, extract those pages first with Extract pages. The workbook will be much cleaner.
  2. Convert. Open PDF to Excel, choose the file, and run it. Each PDF page becomes a worksheet named Page 1, Page 2, and so on.
  3. Combine the sheets. If the table spans several pages, copy the rows from each Page sheet into one master sheet, skipping repeated header rows.
  4. Convert text to numbers. Values are placed as text, which protects things like leading zeros in item codes, but means Excel won't calculate with them yet. See the next section.
  5. Verify. Recalculate totals and compare them with the totals printed in the PDF.

Turning text into numbers

Numbers stored as text are left-aligned and often show a small green triangle. To convert a column:

  • Select the column and use Data > Text to Columns > Finish. Excel re-reads the values as numbers.
  • Or, in a helper column, use =VALUE(A2), or =A2*1, and fill down.
  • Remove thousands separators or currency symbols first if they block the conversion. Find and Replace (Ctrl+H) replacing "," with nothing works for most statements; be careful with files that use commas as decimal separators.

Checking that the data is right

A conversion that looks right can still hide a shifted column or a missed row. Two quick checks catch most problems:

  • Totals. Sum each numeric column with =SUM() and compare with the PDF's totals. A mismatch tells you to look closer.
  • Row counts. Count transactions or items in the PDF and compare with the number of rows in Excel.

For scanned tables, OCR misreads are the main risk: 8 and 3, 1 and 7, 0 and O. Totals checks are essential there.

Scanned statements and OCR

When a page has no text layer, the converter reads it with English OCR, which downloads its engine the first time you use it. Accuracy depends on scan quality. A straight, sharp scan at around 300 DPI gives far better results than a phone photo taken at an angle.

Going the other direction

When you need to share spreadsheet data with someone who doesn't use Excel, Excel to PDF turns every sheet into landscape PDF pages.

A note on sensitive data

Statements and payroll tables are confidential. On Maher PDF the conversion runs inside your browser, so the file isn't uploaded to a server. Still, save the resulting workbook somewhere appropriate and delete working copies you don't need.

Tools mentioned in this guide