One financial report can hold five or six tables: a summary up top, a few detail schedules, a footnote grid at the bottom. Pull it into Excel with a quick copy-paste or a built-in tool and you usually get the first table, a mess, or one giant column with all of them mashed together. Getting every table out, with each one kept separate and its columns intact, is a different job than converting a single clean grid.
Here is why multi-table PDFs trip up most tools, and how to extract all of the tables in a file at once without rebuilding them by hand. The extractor at the top of this page handles several tables per page, so try your file first, then use the notes below for the tricky cases.
How do I extract multiple tables from a PDF?
Upload the PDF to a table extractor that detects every grid on the page, not just the first one, then review and download each table. A dedicated tool scans the whole document, finds where each table starts and ends, and rebuilds each as its own block of rows and columns. That is the key difference from a copy-paste, which has no idea where one table stops and the next begins, so it runs them together. Drop the file into the PDF table extractor above and it pulls each table out for you in a few seconds.
Why does only the first table come through when I convert a PDF?
Because many built-in tools are written to grab the first table they recognize and stop. Excel's own Data, From PDF feature lists the tables it finds, but on a busy page it often merges several into one or misses the ones with thin borders and odd spacing. A copy-paste is worse: it selects a visual region, not a logical table, so everything inside the box lands together regardless of how many separate grids were there. The fix is a tool that treats each table as its own object and returns all of them.
Can I extract all the tables in a PDF at once?
Yes. A proper extractor walks every page, identifies each table, and gives you all of them in one pass rather than making you crop and export one at a time. This matters most on reports where the same figures appear in a summary and again in a detail schedule, because you want both, kept apart, so you can tie one to the other. Upload the file once and you get every grid it contains, instead of repeating the export for each table on each page.
How do I keep each table separate when extracting from a PDF?
Use a tool that outputs each table as its own block and check the preview before you download, so two adjacent grids do not get stitched into one. When tables sit close together, a weak tool will run the last row of one into the header of the next. A good extractor reads the gap and the heading change as a boundary and breaks them correctly. In the preview, confirm that each table has its own header row and that a summary table did not absorb the schedule beneath it. If you need the data in one continuous sheet instead, that is a different goal, covered in converting a PDF to Excel with all pages in one sheet.
How do I extract tables from a scanned PDF that has several tables?
Run OCR first, then extract, because a scan is an image with no readable text or table structure at all. The extractor reads the scan into real characters, works out the grid lines and spacing for each table, and rebuilds every one. Scanned multi-table pages need an extra look: OCR can misread a digit, and faint rule lines between two tables can blur the boundary. Check each grid in the preview and foot the totals before you rely on them. The detail is in OCR PDF to Excel, which covers reading scanned and photographed tables.
Can Excel extract more than one table from a PDF at once?
Partly. In Microsoft 365 and Excel 2021, Data, Get Data, From File, From PDF lists the tables it detected and lets you load several, but the result is hit or miss on dense pages: it often splits one table across entries or merges two into one, and it cannot read scans because it has no OCR. It works well enough for a clean, single-page report with one or two simple tables. For a long statement, a report with many grids, or anything scanned, a dedicated extractor that returns every table cleanly saves the cleanup. Older Excel versions and Excel for Mac do not have the feature at all, as covered in whether Excel can open a PDF.
What is the best way to extract several tables from a PDF?
The best way is a tool that finds every table, keeps each one separate, reads scans with OCR, and shows you the result before you trust it. For a few files, a browser extractor does this with no install and lets you check each grid. For hundreds of files on a schedule, an automated pipeline makes more sense. Whichever you pick, the test is the same: run your real document through it and look at whether every table came out, with its own columns, and nothing got merged. Start with the table extractor above, and for figures that must calculate cleanly afterward, the accurate PDF to Excel converter keeps numbers numeric.
Multi-table extraction comes up most in finance, where one PDF carries a stack of schedules. If the documents you keep pulling tables from are invoices, an invoice OCR tool that exports to Excel pulls the line items and totals automatically, and if you are doing this across thousands of mixed documents, an AI document data extraction platform handles the volume on autopilot. For a single report on your desk, though, the extractor at the top of this page gets every table out and into a sheet you can use.