Skip to content
Blogguide

GUIDE

How to convert PDF invoices to CSV without mixing rows

Get invoice data into portable tables for spreadsheets and downstream imports. Review the extracted values first, then download the CSV archive.

By Kaliits · Reviewed · Editorial standards

Download the example ↓

Three CSV files, one clear relationship

The CSV download is a ZIP archive, not a single flat file. Extract it before importing. Invoices.csv holds invoice-level records, Line_items.csv holds the item rows, and Manifest.csv records document inclusion and confirmation.

Use document_id to connect line items to their invoice. Do not sum the invoice total after joining it to every line: doing so counts the same total repeatedly. Sum line amounts for a line-level report, or use one invoice record for invoice-level totals.

How to import the exported CSV

Use your spreadsheet’s import dialog rather than relying on a double-click. Pick the delimiter and decimal convention used by your export preset. Open a preview before accepting the import.

  1. Upload a permitted invoice and preview its extracted fields before signup.
  2. Review the fields and every extracted row.
  3. Choose CSV and unzip the downloaded archive.
  4. Import Invoices.csv and Line_items.csv into separate sheets.
  5. Preserve invoice numbers and identifiers as text, then check a few numeric cells.

Commas in descriptions should stay in the description

Descriptions can contain commas, line breaks or quotes. The exporter quotes CSV values and uses UTF-8 with a byte-order mark to help preserve French accents. A spreadsheet import that ignores quoting may still split a description incorrectly.

CSV stores text, not spreadsheet cell types. If an ID loses leading zeros, reimport with that column set to text. If a price imports as text, check the decimal separator rather than manually replacing every comma in the file. Formula-like strings are escaped for spreadsheet safety; account for that if your downstream system expects literal strings.

A short review that protects the spreadsheet

Check the supplier and customer separately, then the invoice reference, date and currency. Compare each line with the original. A correct total does not prove that the descriptions or quantities are right.

Keep invoice IDs as text, including leading zeros. Check decimal separators and date conventions before combining files from different countries. Missing values need attention; a blank field is more useful than an invented value.

  • Compare row count and continuation pages.
  • Check quantities, unit prices and line amounts.
  • Check subtotal, discounts, charges, tax and total.
  • Export a copy and retain your source in your own archive.

Current invoice pilot availability

Preview your first invoice result without an account. Verify your email to export. The free pilot includes 30 pages per month and a seven-day account history. Uploads accept PDF, JPG and PNG, up to 10 MB per file. PDFs can contain up to 30 pages, with a maximum of 10 pages per invoice.

English and French typed invoices are the supported focus. Handwriting and Arabic are not reliable supported cases. Review is part of the workflow. Read the privacy and availability page before uploading: the current free AI-assisted pilot accepts only invented or appropriately redacted, non-sensitive documents and is unavailable in the EEA, UK and Switzerland. The browser text extractors included in these guides do not send your files for AI processing.