TL;DR:
First find out whether the PDF holds real text (you can select it) or just a picture of text (you cannot).
Paste into one column, split it into columns, then turn the numbers from text into real numbers.
Never trust the paste until your recomputed total matches the total printed on the PDF.
A supplier sends an invoice as a PDF and you need the line items in a spreadsheet to compare against your order. Retyping twelve rows is slow and a single mistyped digit goes unnoticed. Copying the table is faster, but a PDF is a page layout, not a table, so what lands in the spreadsheet is often one messy column or numbers that will not add up.
The job has three parts: get the text out, shape it into columns, and prove it matches the original. This article walks through all three on one small invoice.
Find out what kind of PDF you have
Open the PDF and try to drag-select a number with your mouse. If the text highlights, the file contains real text and you can copy it. If you can only drag a box over the whole page, it is a scan: a picture of a page. Copying from a scan gives you nothing, and you need text recognition first (many PDF viewers and phone scanning tools offer it; check what yours has).
This one test saves most of the frustration, so do it before anything else.
Three ways to get the table out
Select and paste. Drag over the table in the PDF viewer, copy, and paste into one cell of the spreadsheet. Works for most simple tables, and it is the method used below.
Import from PDF. Recent versions of some spreadsheet apps can read tables directly from a PDF file, usually under their Data tab. Where it exists it keeps columns separate and is worth trying first. Menu names vary by version, so look in your own app rather than trusting a screenshot.
Retype only what you must. For a scan with five rows, typing is quicker than fixing the output of text recognition. Check each number twice.
Worked example: a table in a PDF invoice
Say the invoice has three line items, a subtotal and a tax line. These are example numbers.
Item | Qty | Unit price | Line total |
|---|---|---|---|
Widgets | 12 | $4.50 | $54.00 |
Cable | 5 | $8.20 | $41.00 |
Labels | 20 | $1.25 | $25.00 |
Paste into one column: Click cell A1 and paste. Often each row arrives as one long piece of text such as
Widgets 12 $4.50 $54.00in a single cell.Split it into columns: Select the pasted cells and use your spreadsheet's split-text feature (often called Text to Columns, or Split text to columns). Choose a space as the separator. Item names with spaces, such as "Blue widgets", will split wrongly, so fix those rows by hand afterwards.
Remove the dollar signs: Pasted prices are frequently text, not numbers. Use find and replace to remove
$, or make a helper column with=VALUE(SUBSTITUTE(D2,"$","")). Left-aligned numbers are a sign they are still text.Add a check column: In E2 type
=B2*C2and fill down. For 12 × 4.50 that gives 54, for 5 × 8.20 it gives 41, and for 20 × 1.25 it gives 25. These should equal the printed line totals.Check the totals: Type
=SUM(D2:D4). You should see 120. Then check the tax:=D5*0.08with D5 as the subtotal gives 9.6, and 120 + 9.6 = 129.6, which matches the printed total.
If your SUM disagrees with the printed subtotal, stop. Either a number is still stored as text (SUM skips text), a row is missing from the paste, or the invoice itself has an error worth raising with the supplier.
Cleanup you will usually need
Delete blank rows and repeated page headers that came from a table spanning two pages.
Trim stray spaces with
=TRIM(A2); invisible leading spaces break lookups later.Check dates.
03/04/2026means 3 April in some countries and March 4 in others, so compare against the PDF.Look at negative numbers: a credit may arrive as
(25.00)in brackets or with a trailing minus, and both can paste as text.
Mistakes to avoid
Pasting over the only copy. Keep the PDF and work on a copy of the sheet.
Trusting how it looks. A cell can show 54.00 and still be text. Test with a SUM.
Fixing numbers silently. If you change a value to make the total match, you have hidden the real problem.
Merging cells. Merged cells break sorting and filtering; keep one value per cell.
Doing it faster
Once the first invoice works, save the sheet with the check columns already in place and reuse it: paste the next invoice and the checks tell you straight away whether it landed correctly. If you get stuck on a formula while the invoice is open, DuckyHelper can see your screen and talk you through the step out loud; try it for 10 minutes with no card at download.
Frequently asked questions
Why do my numbers paste as text?
PDF text carries currency symbols, thousands separators or hidden spaces, and the spreadsheet keeps the whole thing as text. Removing those characters and converting with a value function fixes it.
Can I trust text recognition on a scan?
Treat it as a draft. It confuses similar characters such as 1 and 7 or 0 and O, so always compare totals with the printed ones.
Get started
