Combine many PDFs into one table
Thirty invoices from two suppliers means thirty downloads, thirty copy-pastes and a lot of checking which row came from which file.
Drop the whole batch at once. Files are grouped by layout — for example one group per supplier — each group is cleaned with one recipe, and the results land in one table with a Source file column, or in separate sheets if you prefer. Files that fail are listed, and you can retry just those.
Drop files here
or browse your files
XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account
Or try a sample:
Example: before and after
Thirty invoices from two suppliers were grouped into two layouts; the line items of the first group sit in one table, each row tagged with its source file.
invoice_01.pdf invoice_02.pdf invoice_03.pdf invoice_04.pdf invoice_05.pdf invoice_06.pdf … invoice_30.pdf
| Invoice number | Description | Quantity | Amount | Source file |
|---|---|---|---|---|
| INV-2026-0001 | Website maintenance (hours) | 12.50 | 1,062.50 | invoice_01.pdf |
| INV-2026-0001 | On-site IT support (hours) | 12.00 | 1,140.00 | invoice_01.pdf |
| INV-2026-0001 | Logo design | 1.00 | 650.00 | invoice_01.pdf |
| INV-2026-0001 | Copywriting (hours) | 1.50 | 105.00 | invoice_01.pdf |
How to do it
- 1Drop the files together (up to 3 per batch on the free plan, 100 on Plus).
- 2Check the grouping summary — for example “30 files → 2 layouts”.
- 3Download one combined table or one sheet per layout.
Questions
What if the PDFs have different layouts?
They are grouped automatically. Each group gets its own recipe and preview, so a UK supplier and a US supplier don’t end up in mismatched columns.
Can I mix PDFs with Excel and CSV files?
Yes. Every file is grouped by its layout, whatever its format, and files with the same columns can still go into one table.
What happens to a file that fails?
It is listed with a plain-language reason and the rest of the batch is still processed. You can retry just the failed files.
Related tasks
- Extract invoice data to ExcelFields and line items from US, UK and EU invoices, with the arithmetic checked.
- Convert a PDF table to ExcelTables from PDF reports and statements, joined across pages, with real numbers.
- Clean a bank statement CSVBank exports with headers, local date formats and balances — typed and checked.