PDF Invoice to Google Sheets
How to get invoice line items and totals into a spreadsheet without typing them in
Answer in brief
Supplier invoices arrive as PDFs, but tracking, checking and paying them is far easier in a spreadsheet. Converting a PDF invoice to Google Sheets turns its line items, with descriptions, quantities, unit prices and amounts, into rows you can total and filter.
The Convert PDF to Google Sheets™ add-on by Easy Image to Text does this inside Google Sheets: upload the invoice, click Extract Data, and the tables are written straight into your sheet.
What's on an invoice, and what gets extracted
Most invoices have three parts:
- Invoice details: the supplier, invoice number, invoice date, due date and often a purchase order number.
- Line items: a table of products or services with description, quantity, unit price and amount.
- Totals: subtotal, discounts, tax and the amount due.
The add-on extracts every table on the page, so the line items and a totals block laid out as a table each come through as their own table, with a blank row between them. If a page has no table at all, its labelled fields, such as Invoice No. and Date, are extracted instead, with the labels as column headers and the values in the row beneath.
Details printed as loose text rather than in a table or as labelled fields, such as a supplier's address block, may not be included, so add them by hand if you need them.
Weighing other approaches, such as copy and paste or an online converter? See how the PDF to Google Sheets options compare.
How to convert a PDF invoice to Google Sheets
- Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
- Open a Google Sheet and launch the add-on from the Extensions menu.
- Upload the invoice PDF. For a paper invoice, upload a photo or paste a screenshot instead.
- For a multi-page invoice, select the pages with line items, up to 5 at a time.
- Click Extract Data. Each page is written to its own sheet, usually within 10 to 40 seconds.
- Click Download CSV if you need the data for accounting software.
Each successfully extracted page uses 1 credit, and pages that fail don't use any. New users get 3 free credits.
Watch: PDF invoice to Google Sheets
This short video shows the Convert PDF to Google Sheets™ add-on extracting the line items from a PDF invoice into Google Sheets, then downloading them as a CSV file.
Checking the extracted invoice
Invoices are easy to verify, because the numbers have to add up:
- For each line, quantity × unit price should equal the line amount.
- The line amounts should add up to the subtotal.
- Subtotal − discount + tax should equal the total due.
Values are written as plain text, exactly as printed, so product codes and invoice numbers keep their leading zeros. To calculate with them, convert the numbers first, for example =VALUE(B2)*VALUE(C2) to recompute a line amount from quantity and unit price.
Handling many invoices
A PDF with several invoices
If several invoices are combined in one PDF, one per page, select up to 5 pages per run. Each invoice lands in its own sheet. See multi-page PDF to Google Sheets for longer files.
Scanned or photographed invoices
Paper invoices work too. Upload the scan or photo, and keep it straight and well lit. See scanned PDF to Google Sheets for tips.
Building an invoice register
To keep track of many invoices, create a register sheet with one row per invoice: supplier, invoice number, date, due date, total and payment status. After extracting each invoice, copy its key details into a new row. You can then sort by due date, filter unpaid invoices, and total what you owe each supplier with a pivot table.
Who converts invoices to Google Sheets
- Accounts payable teams entering supplier bills and checking them against purchase orders.
- Small business owners keeping track of costs without a bookkeeper.
- Bookkeepers preparing data to import into accounting software.
- Procurement teams comparing prices across suppliers and orders.
Frequently asked questions
Does it work with invoices from any supplier?
Yes. The add-on reads each page's layout instead of using templates, so it works with invoices from any supplier or invoicing software.
Will the invoice number and date be extracted?
Yes, when they appear in a table or as labelled fields. Details printed as loose text, such as an address block, may need to be added by hand.
Can I convert receipts as well?
Yes. Receipts are handled the same way. For paper receipts, upload a clear, straight photo.
Can I convert several invoices at once?
Yes, if they are pages of one PDF. Select up to 5 pages per run, and each page is written to its own sheet.
Can I import the result into my accounting software?
Yes. Use Download CSV after extraction, then import the CSV file using your accounting software's import option and map the columns.
How many credits does an invoice use?
Each successfully extracted page uses 1 credit, so a one-page invoice uses 1 credit.
Done typing invoices by hand? Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.
Last updated: 2026-11-10