Extract tables from PDF to Excel

Pull the tables out of reports, price lists, results, timetables and statements. Each table gets its own sheet, tables that continue over pages are joined, and text around the tables is left out.

Remove repeated rows?

Exact repeats are left out and listed on a "Removed rows" sheet.

Scanned pages (OCR)

Only pages that are pictures are read with OCR (recommended).

No PDF at hand? Try a sample: · ·

🔒 Your file is processed in your browser and never uploaded.

Tables with and without borders

When a table has grid lines, the lines decide the cells. When it has none, the columns are found from the gaps that run down the page between the words, the way you would see them by eye.

Everything that usually goes wrong, handled

  • Headings that span two lines are joined into one heading.
  • A cell whose text wraps onto a second line stays in one cell.
  • A table that continues on the next page is joined, without repeating its heading.
  • Page numbers, headers and footers are left out.
  • Repeated rows can be removed - every removed row is listed on its own sheet.

Questions

What if a PDF has several tables?

Each one is placed on its own sheet, named after the table heading or its page.

Can I choose which pages to convert?

All pages are converted (up to 100). Delete the sheets you do not need in Excel.

Other tools

Advertisement