How to Extract Invoice Data Into Excel and Google Sheets (2026)

October 12, 2026

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.

How to Extract Invoice Data Into Excel and Google Sheets

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.

Step 1: Log Into Lido

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.

Lido Files page with the New file button

Step 2: Click Extract Data

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

Extract Data button in a new Lido sheet

Step 3: Upload Your Invoices

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.

Extract Data upload window in Lido

Step 4: Specify the Columns for Your Spreadsheet

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.

Invoice columns and extra instructions for Excel and Google Sheets in Lido

Step 5: Review the Extracted Invoice Data

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.

Invoice data extracted into spreadsheet rows in Lido

Step 6: Export to Excel

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.

Export to Excel button in Lido

Step 7: Import the File Into Google Sheets

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.

Step 8: Send New Invoices to Your Spreadsheet Automatically (Optional)

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.

{"headline": "Get invoice data into your spreadsheet in minutes.", "subtext": "50 free pages. No credit card required. Works with Excel and Google Sheets."}

Which Invoice Fields to Extract Into Your Spreadsheet

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.

Other Ways to Get Invoice Data Into Excel and Google Sheets

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.

Frequently asked questions

How do I extract data from an invoice into Excel?

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.

How do I get invoice data into Google Sheets?

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.

Can Lido extract line items from invoices into a spreadsheet?

Yes. Keep Extract Multiple Rows per Document checked, and Lido puts each line item in its own spreadsheet row.

Can Lido extract data from scanned invoices?

Yes. Lido reads scanned, photographed, and handwritten invoices as well as digital PDFs.

Can I extract many invoices into one spreadsheet at once?

Yes. Lido processes up to 100 invoices per upload and adds every invoice to the same spreadsheet columns, even when the layouts differ.

Ready to grow your business with document automation, not headcount?

Join hundreds of teams growing faster by automating the busywork with Lido.