Skip to content
BookkeepKit

Convert PDF Tables to Excel

Get tables out of invoices, aging reports, price lists and other PDFs into a spreadsheet. Columns are rebuilt from the position of the text, and amounts become real numbers you can add up.

Drop a PDF here

Invoices, reports, price lists: any PDF with tables.

Processed in your browser. Your files never leave your computer.

How it works

  1. 1

    Drop the PDF

    A digital PDF: one created by software, not a scan.

  2. 2

    Check the preview

    See how the first page's rows and columns were read.

  3. 3

    Download Excel

    All pages in one sheet, or one sheet per page.

What converts well

  • Reports exported from accounting software as PDF: aging reports, trial balances, sales by customer.
  • Invoices and bills with a table of line items.
  • Price lists and catalogs with regular columns.

After the conversion

Header and footer lines (company name, page numbers) come through as rows of their own: sort or filter them out in Excel. If a long description spills into a neighboring column, the preview shows it before you download.

Fixing common results

  • Two columns merged into one: happens when columns sit very close on the page. Use Excel's Data > Text to Columns on that column, split by spaces.
  • A description split over two rows: the second row has text but no amount. Sort by the amount column to find them, then join the text into the row above.
  • Totals and subtotals included: they're rows like any other. Delete them before summing, or your totals count twice.

PDF to Excel or a bank statement converter?

This tool rebuilds the table exactly as it appears. For bank and credit card statements, use the bank statement to Excel converter instead: it reads deposits and withdrawals into one signed amount column, adds the year to dates, joins multi-line descriptions and checks the result against the statement's opening and closing balances.

Frequently asked questions

How are columns detected?

Text that lines up vertically on the page is treated as one column. Titles that span several columns don't break the layout. This works best on PDFs with clear table layouts.

Are amounts kept as numbers?

Yes. Values like 1,234.56, $89.00 or (35.00) become numbers (the last one negative), so totals and formulas work. Codes with leading zeros, like account or ZIP codes, stay as text.

Does it work with bank statements?

It extracts the table, but statements need more: transactions split over two lines, signs taken from sections, years added to dates, and a balance check. The bank statement converter does all that.

What about scanned PDFs?

A scan is a picture without text. Make it searchable with PDF Text Scanner first (Pro), then convert it.

Is my PDF uploaded?

No. The PDF is read in your browser.

Does it convert every page?

Yes. By default all pages follow each other in one sheet, so a multi-page report becomes one continuous table. Tick One sheet per page to keep each page on its own sheet.

Can I get a CSV instead?

Download the Excel file, then use Excel to CSV to choose the separator and encoding the receiving system expects.