How to extract PDF invoice data into Excel

Start with the spreadsheet you actually need

To extract a PDF invoice into Excel, define the columns you need, extract those fields, review the values, then import the CSV into Excel. Parzable downloads CSV files that Excel can open. It does not currently produce a native .xlsx workbook.

This workflow suits supplier invoices whose layouts differ but whose destination columns stay the same. A purchase log might need supplier, invoice number, invoice date, currency, subtotal, tax amount, and total. A spend analysis may need product descriptions as well. Decide that before uploading: the extraction schema determines the output columns.

Keep one invoice per file, with all its pages together. A multi-page invoice and a PDF containing several unrelated invoices are different inputs. Split unrelated invoices into separate files so each result can be traced to one source.

Extract the fields in Parzable

1. Sign in and open Schemas. Create a schema with the field names you want as spreadsheet headers.
2. Describe ambiguous fields. For Total, request the printed invoice total including tax; keep Amount due in another field if the invoice shows both.
3. Open Extract and choose your target schema. Upload the PDF, or select several invoice files for a batch.
4. Review the result against the original. Check identifiers, dates, currency, and amounts. Completion means extraction finished; it does not mean every value is correct.
5. Download the CSV. The batch download contains completed results. Reconcile failed files separately.

Start with a few representative invoices before a large upload. Check your current page allowance on the pricing page; document count and PDF page count are not always equal.

Import into Excel without changing the data

In Excel, use Data → From Text/CSV, select the file, and inspect the delimiter and preview before loading. Import invoice numbers as text so an identifier such as 000482 keeps its leading zeros. Review date and number interpretation rather than relying on a double-click to open the file.

Microsoft’s CSV import guidance explains the available import routes and how Excel interprets text files. Menu labels can vary by Excel version.

After checking the imported data, save as .xlsx if you need formulas, multiple sheets, or formatting. That workbook is created in Excel after import.

Check one row all the way through

Use the fictional invoice header CSV to rehearse the import. It contains two clearly labelled example records, including a leading-zero invoice number. It is a teaching file, not a measured extraction result.

For your own files, compare one imported row with the original PDF after saving and reopening the workbook. Confirm that the invoice number still matches, the date means the same thing, and the numeric amount has not shifted by a decimal place. Then repeat the checks across the batch. If a field is missing or wrong, correct the reviewed spreadsheet and retain the original document under your normal records policy.