How to Convert a PDF Invoice to Excel (Without Retyping)

Most vendors send invoices as PDFs, and most small businesses still track bills in a spreadsheet. The gap between those two formats is where hours disappear: someone opens the PDF, squints at the line items and types them into Excel one cell at a time. There are better options, but they are not all equal. Some work beautifully on a clean, computer-generated PDF and fall apart the moment you hand them a phone photo of a crumpled invoice.

This guide walks through the four realistic methods, shows exactly where each one breaks, and ends with a simple decision table so you can match the method to the invoices you actually receive.

First, figure out what kind of PDF you have

Before choosing a method, open the invoice and try to highlight a word with your cursor. That one test tells you most of what you need to know.

• Text-based ("native") PDF: you can select and copy text. These are usually generated by accounting or billing software such as QuickBooks, Xero or an ERP. The text and numbers are stored as real characters.
• Scanned or image PDF: nothing highlights, or the whole page selects as a single picture. These come from office scanners, fax-to-email services and phone scanning apps. To a computer, this is just a photo.
• Hybrid PDF: a scan that already has an invisible OCR text layer. Text highlights, but it may be slightly wrong (an "8" read as a "B", for example).

Also note whether the invoice runs to more than one page, and whether you need the line items (each product or service, with quantity, unit price and amount) or only the header (vendor, invoice number, dates, total). Those two questions decide which method will save you time.

Method 1: Excel's Get Data from PDF (Power Query)

Recent Microsoft 365 versions of Excel include a PDF connector in Power Query. You find it under Data > Get Data > From File > From PDF. Excel scans the file, lists every table and page it detects, and lets you preview each one before loading it into a worksheet. Availability depends on your Excel version and platform, so if you do not see the option, check for updates or use Excel for Windows.

Step by step

1. Go to Data > Get Data > From File > From PDF and select the invoice.
2. In the Navigator window, click each detected item. Entries labeled "Table" are tables Excel recognized; entries labeled "Page" are whole pages.
3. Pick the table that contains the line items and click Transform Data rather than Load, so you can clean it first.
4. In the Power Query Editor, promote the first row to headers, remove blank rows and set data types (Decimal Number for prices, Date for dates).
5. Click Close & Load. If you later replace the PDF with a new one at the same path, Refresh will re-run the same steps.

Where it breaks

• Scanned PDFs: Power Query reads the text layer. If there is no text layer, there is usually nothing useful to import.
• Header fields: vendor name, invoice number and due date usually sit outside any table, so they come through as scattered page text, not tidy columns.
• Multi-page tables: a line-item table that continues on page 2 often shows up as two separate tables, sometimes with the header row repeated. You have to append them yourself.
• Every vendor is different: a query you carefully built for one supplier's layout rarely works for the next supplier's PDF.

Power Query is excellent when you get the same clean, digital PDF format from the same vendor every month. It is a poor fit for a mixed stack of invoices from dozens of suppliers.

Method 2: Copy and paste

For a single text-based invoice with a short table, plain copy and paste is sometimes fastest. Select the line items in your PDF viewer, copy, and paste into Excel. What usually happens next is the problem: the whole row lands in column A, or each word lands in its own cell.

Two Excel tools rescue a bad paste. Data > Text to Columns splits a column on a delimiter such as spaces or tabs. In Microsoft 365, the TEXTSPLIT function does the same with a formula. If a pasted line in A2 looks like "WIDGET-10 Steel bracket 12 4.50 54.00", you can pull the last three numbers apart like this:

Qty        =VALUE(INDEX(TEXTSPLIT(A2," "), COUNTA(TEXTSPLIT(A2," "))-2))
Unit price =VALUE(INDEX(TEXTSPLIT(A2," "), COUNTA(TEXTSPLIT(A2," "))-1))
Amount     =VALUE(INDEX(TEXTSPLIT(A2," "), COUNTA(TEXTSPLIT(A2," "))))

This works because the numbers sit at the end of the line, while descriptions vary in length. It falls apart when a description wraps onto a second line, when a currency symbol is attached to the number, or when the PDF stores columns in an unexpected reading order. Copy and paste is fine for an occasional invoice. As a monthly process for fifty invoices, it is just retyping with extra steps.

Method 3: Generic OCR tools

Optical character recognition (OCR) turns an image into text. Many PDF editors, scanner apps and free online converters offer a "PDF to Excel" button built on OCR. For scanned invoices, this is the first method that produces anything at all.

The catch is that classic OCR recognizes characters and positions, not meaning. It might give you a spreadsheet that visually resembles the invoice, with the vendor's logo text in A1, the address spread across rows 2 through 5, and the total somewhere in column H. You still have to find the invoice number, figure out which cell is the due date and rebuild the table. Common OCR errors also slip in quietly: a decimal point read as a comma, "1" read as "l", or a faint row skipped entirely.

Method 4: AI extraction into structured fields

AI document extraction goes a step beyond OCR. Instead of copying the page layout, it reads the invoice the way a bookkeeper would and returns named fields: vendor, invoice number, invoice date, due date, PO number, subtotal, tax, total, plus one row per line item with description, quantity, unit price and amount. Because it understands what the fields mean, the same process works across different vendor layouts, scanned pages and phone photos.

This is what PapersToSheet's PDF invoice to Excel converter does. You upload the PDF (or a photo), review the extracted data in an editable preview, fix anything that looks off, and download an Excel or CSV file. You can choose a layout with one row per invoice for a bills log or one row per line item for spend and inventory analysis. Multi-page invoices are read as a single document, so a line-item table that continues on page 2 comes out as one continuous list.

AI extraction is not magic, and you should still review the output, especially handwritten notes, faded thermal paper and unusual units. But the review step becomes checking numbers rather than typing them.

Which method should you use?

Set up a destination sheet before you convert

Whatever method you choose, decide on your columns first. A consistent structure is what makes the data useful later for payables tracking, reconciliation and reporting. A simple one-row-per-invoice layout looks like this:

Vendor | Invoice # | Invoice Date | Due Date | PO # | Subtotal | Tax | Shipping | Total | File Name

Format your data as an Excel Table (Ctrl+T) so formulas and pivot tables expand automatically as you add invoices. Store dates as real dates, not text, and keep amounts as numbers without currency symbols. If you plan to track what you owe and when, our guide to building an accounts payable spreadsheet picks up right where this layout leaves off.

Handling the tricky invoices

Multi-page invoices

Watch for repeated header rows and "continued" subtotals on each page. If you are using Power Query, append the tables and filter out any row where the Description column equals the literal header text. Make sure you only keep the final total, not the per-page subtotals.

Invoices with credits or discounts

Discounts may appear as a negative line item, as a separate field above the total, or baked into the unit price. Keep them as negative numbers in the same Amount column so your totals still tie out.

Line items you need for inventory

If the invoice is really a stock purchase, you probably want SKUs and quantities, not just dollars. The invoice to inventory spreadsheet layout outputs SKU, description, quantity received and unit cost, ready to paste into a stock sheet. For a deeper look at modeling line items, see how to extract line items from invoices.

Bottom line

If every invoice you receive is a clean digital PDF from the same handful of vendors, learn Power Query. If you get a mix of scans, photos and formats, which is the reality for most small businesses, an AI extractor that outputs named columns will save the most time. Either way, add a quick math check before the data goes anywhere important. When you are ready to process more than one page a day, the pricing page lists the weekly, monthly and yearly plans.