You write the headings. The PDFs are read against them.

Why a fixed template runs out

Tools that convert documents into spreadsheets usually ship a list of document types and a fixed field set for each. That works for as long as your paperwork looks like somebody else’s. The moment the job is specification sheets, inspection certificates, lab results, lease schedules or anything a supplier invented, there is no template to choose and no way to ask for the handful of things you actually need.

Naming the columns yourself removes that ceiling. The column set is the input to the job: whatever the documents look like, the spreadsheet comes back with your headings across the top and one row per file underneath.

How to name a column that extracts consistently

A column heading is closer to an instruction than to a label, and small differences in wording change what lands in the cell. These five habits do most of the work.

• Name the fact, not the area of the page — “Header details” is not a column. “Order Date” is. A heading that describes a region of the document has no single value to put in the cell.
• One fact per column — “Supplier and address” produces a cell you have to split again in Excel. Two columns cost nothing and arrive already separated.
• Prefer the word the documents use — If the paperwork says “Consignment No.”, that heading matches more reliably than a tidier synonym you would rather see at the top of the sheet.
• Describe a heading that is ambiguous on the page — A datasheet can print two dates and an invoice two totals. The description is where you say which one belongs in the column.
• Give a number or a date its type — A typed column comes back in a consistent shape, so the spreadsheet sorts and totals without being cleaned first.

Extracting specific fields from PDFs works through the same problem at more length, including what to do when two documents use different words for the same fact.

Types, descriptions and the ceiling

Every column carries a type — text, number, currency or date — and a type is what makes the finished workbook behave like a spreadsheet rather than a wall of text. A date column sorts; a currency column totals; a reference that merely looks numeric belongs in a text column so it keeps its leading zeros.

A description is optional and is worth writing whenever a heading is ambiguous on the page in front of you. One extraction can carry up to 30 columns, which is a ceiling rather than a suggestion: a set small enough to check on one screen is a set you can trust, and nothing stops you adding a column on a later run once you have seen how the first one came back.

Ready-made sets you can edit

Some documents are standard enough to be worth a starting point, so a few pages open the converter with columns already filled in: receipt to Excel and purchase order to Excel both do. They are starting points, not fixed templates — rename a heading, change a type, delete what your documents do not carry, and add what they do. If the job is invoices, invoice to Excel shows a worked accounts-payable example, and PDF to Excel covers what this workflow does and does not try to do with a page.

Reusing a column set you have already proved

Once a set has produced a spreadsheet you were happy with, it is worth keeping. With a free account you can save the setup after a conversion and pick it again under Choose extraction setup, so the next batch starts at the upload step. Saving is the only thing that stores a setup — opening one of the pages above never adds anything to your account.

When the whole point is running one set across a folder, multiple PDFs to one Excel covers the batch side, and how it works walks through the review step before the workbook is downloaded.

Free tools for getting the source PDFs ready

Some of the work around a column set needs no account. Split PDF separates a combined file into the documents that should each become a row, Merge PDF joins pages that belong to one record, and Extract Text shows you the words a document actually contains, which is a quick way to see whether the heading you had in mind appears in it at all. The free tools page lists the rest.

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 covers batch limits, retention, refunds and failed files.