- 01
Put the whole folder in
Select the PDFs together rather than one at a time. They do not have to share a layout, a supplier or a template — each file is read as its own record.
- 02
Name the columns once
Type the headings you want in the spreadsheet, and describe a field or set its data type where the meaning could be read two ways. This is the only configuration step, and you do it for the batch, not per file.
- 03
Extract every document against the same columns
Each PDF is read against the column set you named. Because the question asked of every file is identical, the answers stack into one table instead of arriving in as many shapes as you have documents.
- 04
Review, then download one workbook
One row per document, with its source file beside it, in a single Excel file. A value that could not be located confidently is left blank rather than guessed at, so the gaps are visible before you rely on the sheet.
A worked example
One folder of delivery notes, one table.
Three delivery notes from three logistics systems, in three formats, with the same seven columns asked of all of them. These seven are not a template the product ships — they are what somebody reconciling deliveries against orders happened to type. The last document records no weight, so that cell is blank rather than filled with a guess.
Example extraction result| Source PDF | Delivery Note | Supplier | Delivery Date | Order Ref | Carrier | Pallets | Gross Weight (kg) |
|---|
| dn-88412.pdf | DN-88412 | Northgate Supplies Ltd | 2026-08-04 | PO-10233 | Palletways | 3 | 412.5 |
| acme-lieferschein-0925.pdf | LS-2026/0925 | Acme Components GmbH | 2026-08-11 | PO-10241 | DHL Freight | 1 | 96.0 |
| scan-0043.pdf | SJ-08812 | Seri Jaya Trading Sdn Bhd | 2026-08-19 | PO-10250 | Own fleet | 5 | |
What makes a batch different from a conversion
Converting one PDF is a small job however you do it. The work that actually takes the afternoon is doing the same small job forty times and then stitching the results together — and that is the part a generic PDF-to-table converter leaves you with, because it hands back each document's tables separately and calls it done.
- One column set, not one per file — The alternative is opening each PDF, finding the same seven values, and typing them into the same seven columns. The work does not get more interesting the fortieth time.
- Layouts do not have to match — A batch is usually documents from different senders, produced by different systems. Naming the fields by what they mean rather than by where they sit on the page is what lets those go in together.
- One row per document — Generic table conversion gives you each PDF's tables as their own sheet, which leaves you with the merging job you started with. A record per file is a spreadsheet you can sort, filter and total.
- One workbook out — Not a folder of workbooks to consolidate afterwards, and not a download per file.
Why the columns are yours to type
A fixed set of fields only helps if your spreadsheet happens to be shaped the same way, and across a batch the mismatch multiplies: every row lands in the wrong shape and every row has to be rearranged. Naming the headings yourself means the workbook arrives in the form you already work in. It also means a field nobody anticipated is not a dead end — if the document prints it, you can ask for it.
Invoices are the most common batch of all, and they have their own page with the nine fields most accounts-payable sheets are built from: invoice to Excel. The workflow described here is the same one; only the columns change.
What re-typing a batch costs by hand
Copying 200 documents into a spreadsheet by hand, at 2 minutes each, is 6 hours 40 minutes of typing. That is arithmetic on those two assumptions rather than a measurement — both are printed here so you can substitute your own batch size and your own pace, and decide whether the manual route is worth it for the folder actually in front of you.
Every row keeps its source file
On a batch this is what makes checking possible at all: the preview shows which PDF each row was read from, so a figure that looks wrong is one click from the document it came from rather than a search through the folder. How it works walks through the same flow with a smaller example.
Free tools for getting the folder ready
Some of the handling around a batch needs no account. Merge PDF combines loose single-page documents into one file, Split PDF separates a combined statement back into one document per record — which is what turns a single 60-page PDF into a batch in the first place — the page counter tells you how large the folder really is, and Extract Text shows whether a document has a text layer or is a scan. All of them run in your browser, and the rest are on the free tools page.
Reading further
Two guides go into the parts this page summarises. Converting multiple PDFs into one Excel spreadsheet covers choosing the column set before you start and what a batch of mixed layouts actually looks like in a sheet, and consolidating multiple invoices into Excel covers the month-end version — gathering the period, the checks that make the sheet trustworthy and reconciling it against supplier statements.
What it costs and what is kept
There is no subscription — you buy credits and spend them when you convert something. The pricing page has the current packs and what a credit covers, and the FAQ states the batch limit alongside retention, refunds and what happens to a file that fails.
Ready to turn a folder of PDFs into one spreadsheet?
Name the columns you need, upload the batch, and check the preview before you download the workbook. No template to configure and no subscription to start.
Convert a batch of PDFsBatch extraction questions
01Do the PDFs have to be the same kind of document?
They have to share the fields you are asking for. A folder of delivery notes, a quarter of invoices or a year of statements all work, because every file can answer the same column set. Mixing documents that have nothing in common is the case where one table stops making sense — not because the extraction refuses, but because half the row would be empty.
02What if one document is missing a field?
That cell stays empty. A blank you can see and fill in yourself is worth more than a plausible value that is wrong, and on a batch it is the only way to spot which documents need a second look.
03Do I have to name the columns again for the next batch?
You name them once for the batch you are running. The columns are yours to type, so the next batch can use the same headings or different ones — nothing is locked to a template you have to maintain.
04How many PDFs can go in one batch?
There is a limit per batch. It is not quoted here because it is a setting rather than a fixed property of the product, and a number frozen into this page would go stale the moment it changed — the converter states the current one above the drop zone, and so does the FAQ. If your folder is larger than the limit, split it and run it in parts: the columns are the same each time, so the workbooks line up.
05What if some of the PDFs are scans?
A scan with no text layer is a different job from a digital PDF, and the honest answer depends on the scan. Run one through first and look at the preview before committing the rest of the folder. The free Extract Text tool tells you in seconds whether a document has a text layer at all, and it runs in your browser without an account.
06Can I check the result before I download it?
Yes, and on a batch that matters more than on a single file. The preview shows every row with the PDF it was read from, so a figure that looks wrong can be traced back to its source document in one step.
07What happens to the files afterwards?
They are held only as long as the conversion needs them and then deleted, and you can delete a conversion yourself at any time. The privacy page states the retention period and what is kept.