Netmend · Guides · 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.
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)
Check the totals against the original PDF before you use the file. If a column is in the wrong place, try “Every text row”, or send it to us.
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.
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:
DATE, VALUE or SUBSTITUTE to build real dates and numbers you can check. Our formula translator has the equivalent function names if your Sheets locale is not English (Google Sheets often still accepts English names, but it uses your locale’s separators).Once the raw extract is in, build a clean tab rather than editing the import in place:
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.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.
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.
75 pages $40 · 200 pages $80. Totals reconciled. 48h. Pay on Fiverr.
Need it done for you? From $20Your 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.
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.
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.
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.
Excel formula translator · Testimonial wall · Pinterest pin maker · All Netmend services