How to Convert an Invoice PDF to Excel (Step by Step)

Do you need to know how to convert invoice PDF to Excel? You are not alone. Many small teams get their bills as PDF files. But their books live in Excel. So the numbers must move from one to the other.

An invoice to Excel converter does this job for you. It reads the PDF and builds a clean sheet. You do not have to type a thing. This guide shows each step in plain words.

You need no new skills. If you can open a file and click a mouse, you can do this. One bill takes just a few minutes. And it gets faster once you know the steps.

This guide uses plain words and short steps. It fits first-time users best. But if you convert bills each week, the same steps still work for you. You will just move through them fast. By the end, you will know the full path: upload, review, fix, check, and export.

Step by step: how to convert invoice PDF to Excel

The full job has four short steps. This table shows what you do and what you get at each step.

That is the whole flow. The parts below walk through the steps with more care. They show what the tool finds and what you should check.

One tip before you start: keep the PDF open in a tab next to the tool. Then you can match each field on screen to the bill as you go. Most checks take a glance, not a hunt. If a field is blank on screen but full on the bill, that is a sign the layout is odd. The fix steps below still work — you just type that one field by hand.

The review screen is the heart of the job. Each field sits in its own box, ready to edit. Rows sit in a grid that looks like the sheet you will get. If the tool is not sure of a value, it marks the field so your eye goes there first. Work top to bottom: firm, number, dates, rows, sums. It takes a minute, and it is the minute that keeps your books true.

What the tool pulls out of the PDF

A good tool does more than copy text. It finds the key facts on the bill. It reads the name of the firm that sent the bill. It finds the bill number and the date it was sent. It reads each row of goods or work: what it was, how many you got, and the price of each one.

Last, it reads the three big sums: the subtotal, the tax, and the full total. All of this lands in neat columns in the sheet. So you can sort the rows, add them up, and check them with ease.

The rows are the part most teams care about most. A total tells you what to pay, but rows tell you what you paid for. We wrote a full guide on how to get line items out of an invoice PDF if you want to go deep on that one part.

A worked example, start to end

Let us walk through one real bill. A parts firm sends you a bill as a PDF. The bill has three rows: two brake discs at $60 each, one set of pads at $80, and one hour of work at $40. The rows add up to $240. Tax on top is $24. The full total on the bill is $264.

You upload the file. In a few seconds, the tool shows the fields it found. The firm name is right. The bill number is right. All three rows are there, each with its count, its price, and its sum. The subtotal reads $240 and the tax reads $24. So far, so good.

One field is off, though. The date shows the wrong year. That can happen when a bill uses a short date form. It is a two-click fix: click the date field, type the right year, done. This is why the review step exists. The tool does the hard work of reading. You do the quick work of checking.

Next, the sums. The rows add to $240, which is the subtotal. The subtotal plus the tax is $264, which is the total. The tool shows a green pass. Now you export the file. You get an Excel sheet with the same facts in neat columns. The whole job took about two minutes. Typing it by hand would have taken longer — and each typed digit would have been a chance for a slip.

At export, you pick the shape of the file. Plain Excel is best if you want to work in the sheet. CSV is best if you move the data into an app. There are also two presets that shape the columns for QuickBooks and Xero. Pick the one that fits your next step. The data is the same in each case — only the column names and order change.

Check the numbers before you save

No tool is right all the time. Odd page layouts can trip it up. So take one minute to check the result. Do the rows add up to the subtotal? Does the subtotal plus the tax match the total? Our tool runs this check for you and flags any gap. You see a pass, a warning, or a fail, plus the exact size of the gap.

If a field looks wrong, click it and fix it on the screen. Then export the file. A fast check now saves hours of pain at the end of the month. A slip caught here is cheap. A slip caught by a client, or on a tax form, is not.

What do the three marks mean? A pass means both checks are clean. A warning means a small gap — a cent or two, most times from rounding. A fail means a real gap that needs your eyes. The tool shows the size of the gap in each case, so you can judge fast. Small and round? Most times it is rounding. Big or odd? Look at the rows one by one till you find it.

There is one more check worth your time. Match the bill to what you got. Did the goods come to your door? Was the work done? A bill can add up just fine and still not be yours to pay. The math check is fast. The match check keeps you from paying for things you never got.

Common slips and how to dodge them

A few slips show up again and again in this job. Most are easy to dodge once you know them by name.

• You upload a statement, not a bill. A statement lists many bills at once. Convert the bills one by one, not the statement.
• The bill has more than one page. That is fine — the tool reads all the pages. But each page counts toward your plan, so a long bill uses more of it.
• You pick the wrong file type at export. Pick Excel if you want to edit sums and use formulas. Pick CSV if you just move data from app to app.
• You skip the check step. One minute of checks now beats an hour of fixes at the end of the month.
• You save the sheet with a vague name. Use the bill number in the file name. You will thank yourself when you hunt for it later.

One more case: the bill is in a tongue you do not read. The sums still convert fine, since sums are just digits. But check the row text with care. If the rows matter for your books, ask the firm for a copy in your own tongue.

Last, watch the money unit. A bill can be in dollars, euros, or pounds. The tool reads the unit sign on the bill and keeps it with the sums. If your books are in a new unit, note the rate you use to change the sums. Write the rate in the sheet, in a cell of its own. A note like that saves a hard talk with your tax help at the end of the year.

When a PDF will not convert

Some PDFs are just a photo of a bill. They have no text to read. If you can not click and drag to select words in the file, it is a scan. Our tool reads scans with OCR, which turns the photo into text. Totals and bill numbers read well this way. But rows from a scan can have slips, so check them with extra care.

Scans vary a lot. A flat, sharp scan from a real scanner reads best. A phone photo on a dark desk reads worse — lines bend, and digits can blur. If a scan fails or reads poorly, scan it once more, flat and in good light. That one step fixes more scans than any other. We wrote a full guide on how to turn a scanned invoice PDF into Excel, with the test numbers for what OCR gets right and what it misses.

How long it takes and what it costs

A one-page bill takes about a minute from upload to export. Most of that minute is your check, not the tool. The tool itself needs just a few seconds for a text PDF. Scans take a bit more time, since the tool must read the photo first.

The free plan gives you 10 pages a month. That fits a sole trader or a very small firm. The paid plans give you 100 or 500 pages a month. Think in pages, not in bills: a three-page bill uses three pages of your plan. If a bill is long, that is fine — it just counts more.

If your team types bills by hand now, the real cost is the hours, not the tool fee. The math is stark: even a small team can lose a full work day each month to typing, and that count does not include the time spent fixing slips. Ten free pages a month are a cheap way to test if the tool earns its keep. Time one bill both ways — typed, then converted — and the gap speaks for itself.

Your next step

Pick one bill from your inbox and try it now. The free plan gives you 10 pages a month, and you need no card. If your team gets more bills than that, see the pricing plans. And if you face a whole month of bills at once, read the guide on how to convert a month of invoices at once.

One last thought: the first bill is the slow one. The fifth bill takes half the time. By the tenth, the steps are a habit. That habit is worth more than the time it saves — it means each bill in your books was read, checked, and saved in the same clean way.

Sources and further reading

• Convert PDFs to Excel and XML formats in Acrobat — Adobe's own steps for turning a PDF into an Excel file in Acrobat, plus the export settings it lets you change.
• Common questions about importing data to QuickBooks Online — Intuit lists what QuickBooks Online can take in and which file types work, so you know what your sheet needs to become.

← All guides