Convert invoice PDFs to Google Sheets
Supplier invoices arrive as PDFs, and the line items inside them are what you need for approvals, cost tracking and stock. PDF to Sheets lifts the line-item table into your spreadsheet so nobody has to key it in.
4.5 out of 5 on the Google Workspace Marketplace
| Item | Description | Qty | Unit price | Amount |
|---|---|---|---|---|
| HW-104 | Hinge, brass 3 in | 40 | 2.15 | 86.00 |
| HW-220 | Drawer slide 18 in | 24 | 6.80 | 163.20 |
| PT-015 | Primer, 1 gal | 6 | 21.50 | 129.00 |
| PT-031 | Roller cover 9 in | 12 | 3.25 | 39.00 |
| FR-001 | Freight | 1 | 48.00 | 48.00 |
The short answer
To convert an invoice PDF to Google Sheets, open PDF to Sheets from the Extensions menu, upload the invoice and convert it to the current sheet. The line-item table arrives with description, quantity, unit price and amount in their own columns. Multiply quantity by unit price in a spare column and compare the sum with the invoice total to confirm nothing was misread.
What you can pull from an invoice
| Part of the invoice | What you get | Good to know |
|---|---|---|
| Line items | One row per line with description, quantity, unit price and amount | This is the table the converter is built for. |
| Totals block | Subtotal, tax, freight and total due | Often printed as a small second table under the line items. |
| Header details | Invoice number, date, supplier and PO number | Printed as loose text on many invoices, so expect to tidy it. |
| Multi-page invoices | One continuous list of line items | Watch for the column header repeating at each page break. |
Where invoice data goes wrong
Descriptions wrap onto two lines
A long product description takes two lines in the PDF but belongs in one cell. Scan the description column for orphaned fragments after converting.
Every supplier has a different layout
You cannot build one template for fifty suppliers. Table detection works on the page in front of it, so a new supplier's layout does not need any setup.
Totals hide typing mistakes
When line items are keyed by hand, a slipped digit goes unnoticed until the totals disagree. Converting removes the keying step.
Paper invoices are still common
Invoices that were printed, signed and scanned are images. OCR reads them so they can be converted like any other PDF.
How to convert an invoice to Google Sheets
Add PDF to Sheets to Google Sheets
Install it from the Google Workspace Marketplace. It takes one click and adds nothing to your computer.
Open it from the Extensions menu
In any spreadsheet, go to Extensions, choose PDF to Sheets and open the converter in the sidebar.
Upload your PDF and pick an output
Choose the file, then choose where the data should go: the current Google Sheet, an Excel file, CSV or XLS.
Convert and check the totals
The tables land as rows and columns. Compare one total against the PDF before you build on the data.
Building an invoice log
A single converted invoice is handy. A running log of every invoice is where the time comes back, because it answers questions like what you paid a supplier last quarter or whether a unit price crept up.
Set up the log once
Create a tab with these columns: supplier, invoice number, invoice date, item, description, quantity, unit price, amount. After each conversion, paste the line items under the last row and fill in the first three columns.
Check each invoice before it joins the log
- In a spare column, calculate
=C2*D2for quantity times unit price and compare it with the amount column. A mismatch points at a misread digit or a discount line. - Sum the amount column and compare it with the subtotal printed on the invoice.
- If quantities arrive as text, set the column to Format > Number > Number.
Put the log to work
A pivot table by supplier and month shows spend at a glance. A =UNIQUE() list of items with =MAXIFS() and =MINIFS() on unit price shows which prices have moved.
- Marketplace rating
- 4.5
- Installs
- 60K+
- Free to try
- 5 pages
Reviews
4.5 out of 5
Invoices: common questions
How do I extract line items from a PDF invoice into Google Sheets?
Open PDF to Sheets from the Extensions menu in Google Sheets, upload the invoice and convert. The line-item table lands as rows with a column for each field on the invoice.
Can I convert several invoices into one spreadsheet?
Yes. Convert each invoice, then paste the line items into a single log tab with extra columns for supplier and invoice number. A multi-page PDF that contains several invoices can be converted in one go.
Does it work with scanned or photographed invoices?
Yes, scanned pages are read with OCR. Flat, well-lit scans work best. Crumpled receipts and angled phone photos are less reliable.
Can I export invoice data to Excel or CSV for my accounting system?
Yes. Choose Excel (.xlsx), CSV or XLS when you convert. CSV is the usual choice for importing bills or line items into accounting and inventory software.
Will it read the invoice number and date as well?
It reads text and tables on the page. Header details that are printed as loose text rather than in a table may land in separate cells, so copy them into your own columns.
Related converters
- Accountants and bookkeepersConvert client bank statements, invoices and financial reports from PDF to Google Sheets, Excel or CSV. Less retyping at month end and tax time.
- ProcurementConvert supplier quotes, price lists and purchase orders from PDF to Google Sheets, Excel or CSV and compare vendors side by side without retyping.
- Real estateConvert rent rolls, T12 operating statements and closing statements from PDF to Google Sheets, Excel or CSV so you can underwrite instead of retyping.
Stop retyping PDFs into spreadsheets
Add PDF to Sheets to Google Sheets and convert your first 5 pages free.