Netmend

Netmend · Guides · Convert PDF invoices to Google Sheets

Convert PDF invoices to Google Sheets

Google Sheets will open a CSV, but it will not read a PDF invoice for you. Extract the line items on your computer, import the CSV into a Sheet, then fix the date and decimal traps that Sheets applies automatically — especially if you work in Europe or paste a US invoice into a European spreadsheet.

Free tool in your browserNo accountFrom $20 if you want it done

Convert a PDF now

This converter is built for tables. Use it on a digital invoice or receipt with a real text layer. Switch to “Every text row” if the first preview looks short.

No file at hand? (fictional data)

How it stays private: the page uses the open-source pdf.js library (Mozilla) to read the file locally. There is no server and no upload. You can disconnect from the internet after the page loads and it still works.

Extract first, then import

The converter below runs in your browser and never uploads the invoice. It is useful when the PDF is a digital file with a line-item table. It is not useful on a scan or a photograph — see scanned invoices. Use “Every text row” if the first preview drops a wrapped description. Download the CSV to your computer, then in Google Sheets: File → Import → Upload, and import as a new sheet or a new tab.

On the import dialog, be deliberate:

A working sheet that you can tick

Once the raw extract is in, build a clean tab rather than editing the import in place:

  1. One row per line item, with the invoice number repeated, plus a header row you type yourself (invoice number, date, supplier, description, quantity, unit price, net, tax, gross).
  2. A second tab that lists one row per invoice: invoice number, the printed total from the PDF, and a SUMIF (or SOMA.SE in Portuguese Excel) of the line grosses. Every row on that tab should match. If it does not, stop and fix the extract before you share the file.
  3. Keep a column with the original PDF file name, so a mismatch can be opened and checked.

If the destination is QuickBooks or Xero, this Sheet is a working file, not the import file. Copy the checked rows into that product’s official template — see the QuickBooks and Xero guides. Sheets is a fine place to clean the data; it is not a substitute for their column names.

Sources (checked 13/11/2026). Official product help is linked in the text. Menus and templates change: treat the current screen in QuickBooks, Xero or your bank as the authority.

Need it done for you? From $20

The free tool is for a clean, text-based PDF. For scans, password files, a packed year of documents or a layout that has to match QuickBooks or Xero, we convert them and check the totals against each document.

Done-for-you conversion
$20 / 20 pages

75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.

Need it done for you? From $20
Privacy

Your file is processed only for the order and deleted after delivery. This page itself never uploads the file.

Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. No address, phone or national ID is asked for or published.

FAQ

Can I open a PDF directly in Google Sheets?

No usefully. Sheets opens CSVs and Excel files. Convert the PDF on your computer first, then import the CSV. A Drive OCR step on a scan is a separate, error-prone process — tick every total if you use it.

Why did 03/04 become the wrong day?

The spreadsheet locale decided whether that is 3 April or 4 March. Import dates as text first, or set the locale to match the invoice, then confirm the first few rows against the PDF.

Should I pick comma or semicolon in the tool?

Comma for typical Google Sheets and UK/US Excel (dot decimals). Semicolon for most mainland-European Excel. You can change this on the converter before you download, and again on the Sheets import dialog.

Related guides

Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services