PDF | 3 min

How to extract tables from a PDF into Excel

PDF to Excel finds the tables in your PDF and writes them to a workbook you can sort, filter and calculate with. It runs in your browser, so statements and reports stay on your device.

Steps

1. 1

   Open PDF to Excel

   Go to the tool and add your PDF.

2. 2

   Decide about continuing tables

   Keep Join tables that continue across pages switched on if a table runs over onto the next page with the same columns. They then become one sheet instead of several.

3. 3

   Choose the pages

   Leave Pages empty for the whole file, or type the pages that hold your tables.

4. 4

   Convert and check the numbers

   Download the workbook and compare totals against the PDF before you rely on it.

Tips

• Always check numbers and column alignment, especially in statements and invoices.
• A scanned PDF has no table to read. Run PDF OCR on it first.
• Limiting the pages gives a cleaner workbook when the PDF has a lot of other content.

Questions

Does every PDF table convert perfectly?

Tables with clear rows and columns work best. Complex layouts may need tidying in Excel, so check the result.

Is my PDF uploaded?

No. The tables are read in your browser.