One PDF to Excel is easy. The real job is when you have a folder of them, a year of bank statements, a quarter of vendor invoices, twelve monthly reports, and you want all of that data sitting in a single Excel sheet you can sort, pivot, and total. Converting them one at a time leaves you with a pile of separate workbooks, which is not the same thing. Getting everything into one continuous sheet takes a second step, and the method you pick decides whether it takes two minutes or an afternoon.
The short version: convert every PDF to Excel in one batch, then append the resulting files into a single sheet. Below is how to do both cleanly, plus the small things that quietly break a combine and how to avoid them.
How do I combine multiple PDFs into one Excel spreadsheet?
Convert each PDF to its own Excel file first, then append those files into one sheet. There is no shortcut that reads a folder of PDFs straight into a single tab, because each PDF is a separate document with its own table. So the workflow is two steps: a batch conversion that turns every PDF into a spreadsheet, then a combine in Excel that stacks those spreadsheets into one continuous range. Power Query handles the second step for any number of files; VSTACK works for a handful.
Step 1: Batch convert every PDF to Excel
Start by turning the whole folder of PDFs into spreadsheets in one run rather than converting them individually. A batch PDF to Excel converter queues every file at once, reads the real table in each, runs OCR on any scanned pages, and gives you one Excel file per PDF. Drop them all in a single, dedicated folder on your machine, with nothing else in it, because the combine step in Excel pulls in everything it finds in that folder.
The one thing worth checking before you combine: the converted files should share the same columns in roughly the same shape. If every statement comes out as Date, Description, Amount, the append will be clean. If one file has an extra column or a different header, you will be doing cleanup later, so it pays to convert from one consistent source format where you can. For figures specifically, make sure they came through as real numbers, not text, or your totals will read zero. The accurate PDF to Excel converter covers why that happens and how to keep numbers numeric.
Step 2: Combine the Excel files into one sheet
With your folder of converted spreadsheets ready, the most reliable way to stack them is Power Query's From Folder feature, which is built into Excel for Windows. Open a blank workbook, go to the Data tab, choose Get Data, then From File, then From Folder, and point it at the folder. Excel lists every file it finds. Click Combine, then Combine and Load, and Power Query uses the first file as a template, reads the matching sheet or table out of each one, and stacks them all into a single query you load to one sheet.
The payoff is that it keeps working. Drop a new converted file into the same folder, hit Refresh, and the new rows appear without redoing anything. That makes it the right choice for recurring work like a monthly close, where next month you just convert and drop in the new file.
If you are on Microsoft 365 and only have a few files, you can skip Power Query and use VSTACK instead. Open each file, then in a fresh sheet write a formula like =VSTACK(File1!A2:C200, File2!A2:C200, File3!A2:C200) to pile the ranges on top of each other. It is quick for three or four files but gets unwieldy fast, and it needs the source files open or referenced, so for anything beyond a handful, Power Query is the cleaner path. For very small jobs, plain copy and paste of each table under the last still works, just watch that you do not paste the header rows in the middle.
Can I convert multiple PDFs into one Excel sheet directly?
Not in a single click, and any tool that claims to is usually just batching and then merging behind the scenes. Each PDF is its own file, so a converter produces one spreadsheet per PDF by design. Combining them into one sheet is a deliberate, separate step you control, which is actually what you want: you get to confirm each file converted correctly before you stack them, instead of pouring a bad conversion into the middle of your master sheet. Convert the batch, glance at the outputs, then append.
How do I combine Excel files with Power Query?
Put all the files in one folder, then in a blank workbook go to Data, Get Data, From File, From Folder, and select that folder. In the preview, choose Combine and Load, and pick the sheet or table that exists in all the files when Excel asks for a sample. Power Query reads that same sheet from every file and loads the combined rows into one query table. Two rules keep it clean: the folder should hold only the files you want, and every file should use the same column headers, since Power Query matches columns by name, not by position, so the order can vary but the names cannot.
Why don't my combined sheets line up?
Almost always it is a column mismatch. Power Query and a manual stack both line up data by the header name, so if one file says Amount and another says Total, or a file carries an extra column the others do not, the rows shift or land under the wrong heading. Fix it at the source by converting from one consistent format, and clean any stray headers before you combine. The other common culprit is an extra file in the folder, a stray template or a desktop.ini, which Power Query will try to read like the rest, so keep the folder dedicated to just the converted spreadsheets.
How do I keep track of which file each row came from?
Add a source column so every row carries the name of the PDF it came from. Power Query does this for you: when you combine from a folder it includes a Source.Name column with the original file name, so you can always trace a transaction back to the statement or invoice it sat in. If you combine by hand instead, add your own column and fill it with the file or month before you stack, for example a Period column with 2024-01. It takes seconds and saves you from an untraceable master sheet where a wrong number has no home.
How many PDFs can I combine at once?
The conversion side handles large volumes in one go, up to 500 files per batch on the paid plans, and Power Query will happily combine a folder of hundreds of resulting spreadsheets. The real ceiling is Excel itself: a single worksheet holds 1,048,576 rows, so if you are stacking very large statements the combined total has to stay under that. For most finance work, a year of statements or a quarter of invoices, you are nowhere near the limit. If you ever do approach it, load the combined query to the Data Model or a pivot rather than to a sheet, which sidesteps the row cap entirely.
That is the whole workflow: batch convert the PDFs, then append the files into one sheet with Power Query. If your stack is all transactions headed for a single ledger view, see getting every page of one PDF into a single sheet for the related case, or using Power Query to convert PDF to Excel for more on the tool. You can also export each file to CSV first if a database or import wizard is the final destination. For AP teams pulling a month of vendor bills into one sheet, an accounts payable automation platform can capture that invoice data continuously instead of file by file, and lenders combining a borrower's statements for review often feed the same data into loan document analysis software once it is in spreadsheet form.