Cosmovex/tools

Convert an invoice PDF to CSV for import or a quick spreadsheet

Invoice PDF to CSV with Invoice to Spreadsheet

This page opens with a fictional invoice and CSV as the export, for importing into another system or pasting into a sheet. Each line item is a row, and the invoice number, date and supplier are repeated on every row.

  1. Tap Choose a PDF and pick a text invoice.
  2. Check the header fields and the line items shown for the invoice.
  3. Fix any value in place, or untick a line you do not want.
  4. Read the totals check, then press Download CSV.
  5. Open the CSV in Excel or Sheets, or import it where you need it.
invoice pdf to csv extract invoice data to csvinvoice line items csvconvert invoice to csvpdf invoice to csv converter
Open Invoice to Spreadsheet Free to start · no account

What to know

The CSV has a header row followed by one row per line item: invoice number, invoice date, supplier, line number, item code, description, quantity, unit price, tax, amount and currency. Dates are written as yyyy-mm-dd and numbers use a dot as the decimal separator with no thousands separators, so another system or a script can read them without guessing the locale.

A CSV cannot carry cell formats, so a few protections are built in. A text value that starts with =, +, - or @ is prefixed with an apostrophe so a spreadsheet does not run it as a formula, and the file starts with a byte-order mark so Excel opens accented characters correctly. It adds up the lines and compares them with the subtotal, then compares subtotal plus tax with the total; a mismatch is shown to you and nothing is changed.

Free reads one invoice at a time, the first 3 pages, up to 15 line items per export and 3 exports a day, which is enough to try the tool on a real invoice. Pro merges many invoices into one sheet, reads up to 30 pages per invoice and removes the line and export limits.

Updated · Cosmovex

Questions

What delimiter and encoding does the CSV use?

Commas, with quotes around any value that contains a comma, a quote or a line break, and UTF-8 with a byte-order mark so Excel shows accents and symbols correctly.

Can I choose one row per invoice instead?

Yes. In the export bar choose One row per Invoice (summary): the CSV then has the invoice number, dates, supplier, subtotal, tax, total, the sum of the lines and a check result.

Will it import straight into my accounting software?

It makes a plain CSV. It does not know any particular program's import template, so you may need to rename or reorder columns.

Is anything stored on a server?

No. The PDF is read in your browser and the CSV is made there. Only anonymous usage counts are sent.

The free plan covers everything on this page. Invoice to Spreadsheet Pro ($9/mo, billed monthly) is described on the Invoice to Spreadsheet page.