To extract invoice data into Excel and Google Sheets, you can use Lido. Upload your invoices, specify the fields you need, and Lido pulls them into spreadsheet columns that you can export to Excel and import into Google Sheets.
In this tutorial, we will walk you through extracting data from a sample invoice into Excel and Google Sheets, step by step.
Lido is the easiest way to extract invoice data into Excel and Google Sheets because it reads invoices in any layout, including scans, and returns clean rows without templates or manual typing.
Before you start, make sure you have your invoices saved as PDFs, images, or scanned copies.
If you don't have a Lido account yet, you can create one for free here.
Once you're logged in, create a New File.

Select the Extract Data button at the top of the sheet.

Upload your invoices by dragging and dropping them into Lido, or click to browse. You can upload up to 100 invoices at once, and they don't need to share the same layout.

For the purpose of this tutorial, we will be using a sample invoice with five line items. Enter the columns you want in your spreadsheet: Vendor, Invoice Number, Invoice Date, Description, Quantity, Unit Price, Amount, and Balance Due.
You can also add extra instructions if you'd like (this is optional). We used: "Extract each line item as a separate row. Vendor is the company that issued the invoice, not the Bill To company. Description is the item name only. Format dates as MM/DD/YYYY and amounts as plain numbers. Balance Due is the amount still owed after any deposit."
Plain numbers matter here, because Excel and Google Sheets can only add up amounts that are stored as numbers, not text with dollar signs. Leave Extract Multiple Rows per Document checked to get one row per line item, then click Process All Files.

Review the extracted data to make sure everything looks correct. Each line item from the invoice now has its own row, with the vendor, invoice number, and date repeated so the rows stay easy to filter.
The Balance Due column shows 4801, the amount still owed after the deposit, instead of the invoice subtotal. You can edit any cell before you export.

Click Export to Excel to download your invoice data as an Excel file. Open it in Excel and the amounts are ready for formulas like SUM, or for a pivot table by vendor.

To work in Google Sheets instead, open Google Sheets and go to File, then Import. Upload the Excel file you just downloaded, choose whether to create a new spreadsheet or insert the data into your current sheet, and click Import Data.
Your invoice data now sits in Google Sheets with every value in the right row and column.
Connect an email inbox, a Google Drive folder, or a OneDrive folder in the Extract Data window, and Lido extracts each new invoice as it arrives. Turn on Export Results to have Lido save an Excel or CSV file of your data to Google Drive or OneDrive every day, ready to open in Google Sheets or Excel.
Before you extract invoice data, decide what your spreadsheet is for. The right columns depend on whether you track invoices or analyze what you buy.
One row per invoice: Best for an invoice log or payment tracker. Extract the vendor, invoice number, invoice date, due date, PO number, payment terms, total, and balance due, and uncheck Extract Multiple Rows per Document. Our guide on organizing accounts payable invoices shows this setup.
One row per line item: Best for spend analysis, job costing, or matching invoices to purchase orders. Extract the description, quantity, unit price, and amount, plus the invoice number and vendor so each row can be traced back to its invoice.
Totals and taxes: Invoices often list a subtotal, discount, tax, total, and balance due. Name each column clearly and add an instruction that defines it, so every vendor's invoice fills the same column with the same kind of number.
Lido uses the same columns for every vendor, so invoices from different suppliers land in one consistent spreadsheet. Our guide to extracting data across many vendor layouts explains how this works.
You can also move invoice data into Excel and Google Sheets without an extraction tool, but each method has limits:
Manual data entry: Typing invoice details into a spreadsheet works for a few invoices a week. At higher volumes, it takes hours and leads to typos in amounts and invoice numbers.
Copy and paste: Copying from a PDF often pastes a whole table into one column or splits rows apart. Scanned invoices have no text to copy at all.
Excel's Get Data from PDF: In Excel for Microsoft 365 on Windows, Data, then Get Data, then From PDF imports tables from digital PDFs. It doesn't read scanned invoices, and it can't pick out header fields like the invoice number or due date. Scanned invoices need dedicated invoice scanning tools or an AI extractor instead.
Opening the PDF in Google Docs: In Google Drive, opening a PDF with Google Docs converts it to text. The layout usually breaks, so you still have to copy each value into Google Sheets by hand. For more options, see our guide to converting PDF to Google Sheets.
Template-based OCR: Traditional OCR data extraction tools need a template for each invoice layout, and the templates break when a vendor changes its format.
Lido avoids these limits by reading each invoice with AI, whether it's digital, scanned, or handwritten. Disney Trucking uses Lido to process 360,000 pages a year that used to be typed into Excel by hand, and Viking Transportation exports data from more than 3,000 documents a month to Google Sheets.
Now that you know how to extract invoice data into Excel and Google Sheets, you can stop retyping invoices and spend that time on analysis instead.
Upload the invoice to Lido, specify the columns you need, and click Process All Files. Then click Export to Excel to download the data as an Excel file.
Extract the invoice data with Lido, export it to Excel, and use File, then Import in Google Sheets. Lido can also save a daily Excel or CSV file to a Google Drive folder.
Yes. Keep Extract Multiple Rows per Document checked, and Lido puts each line item in its own spreadsheet row.
Yes. Lido reads scanned, photographed, and handwritten invoices as well as digital PDFs.
Yes. Lido processes up to 100 invoices per upload and adds every invoice to the same spreadsheet columns, even when the layouts differ.