Convert invoice PDF to Excel on iPad (2026 walkthrough)

Your suppliers email PDFs. Your accountant wants Excel. You’re on an iPad because that’s where the inbox is when the invoice lands, and because the Mac is two rooms away and you don’t feel like context-switching to process one vendor bill.

The gap between “PDF in Mail” and “row in a spreadsheet” is the most-repeated, least-automated task in small-business bookkeeping. Doing it on iPad has historically meant one of three bad options: typing line items by hand, uploading the invoice to a web converter that doesn’t know what an invoice is, or AirDropping to a Mac and giving up on iPad-native workflow.

This guide covers the workflow that actually works in 2026: extract invoice PDFs to Excel on iPad, on-device on iPadOS 26+, with line items, totals, and tax landing in the right columns the first time.

Why invoice PDFs are harder than they look

“Invoice to Excel” sounds like one problem. It’s actually four, and most converters only handle the first:

Header metadata. Invoice number, issue date, due date, PO number, vendor name and address, your billing address. These are scattered across the top third of the page in boxes, not in a table. A generic table extractor skips them or smashes them into the line-item grid.
Line items. The actual table: description, quantity, unit price, line total, sometimes tax per line, sometimes a discount column. Templates vary wildly between vendors — even two invoices from the same supplier can diverge if they updated their billing software.
Totals block. Subtotal, tax (often split across multiple rates — standard VAT, reduced VAT, zero-rated), shipping, discounts, grand total. This is visually a small table but structurally a set of key-value pairs that need to land in specific columns alongside the line items.
Payment terms and footer. Bank details, payment reference, late-fee policy. Usually irrelevant for bookkeeping export but sometimes you need the payment reference in a separate column.

A tool that grabs “all the tables” gives you a mess. A tool that understands an invoice as an invoice puts the header metadata in a normalized set of columns, the line items in their own rows, and the totals in a reconciled summary. That’s what you want exported to Excel — because a pivot table on vendor × month × tax_rate is the whole point of doing this at all.

Why iPad is a reasonable place to do this

Bookkeeping on iPad used to be a compromise. In 2026 it isn’t:

iPadOS 26 brings Apple’s Foundation Models framework to iPad, which means the same on-device LLM that powers Apple Intelligence can parse your invoices locally — no upload, no round-trip.
Stage Manager and external-display support mean you can have Mail, ignitai, and Numbers side by side on a single iPad screen or on a connected monitor, which removes the last ergonomic reason to prefer a Mac.
Apple Pencil Pro is genuinely useful for marking up an invoice before extraction — circle the line items table, cross out a duplicate page, annotate a discount — and for reviewing the extracted sheet.
The PDFs are already there. Invoice emails land in Mail on iPad first for most people, because that’s the device that’s on when email arrives.

If you already work from an iPad as your primary computer, the workflow below is native. If you have a Mac and just want iPad as the capture device for invoices that arrive while you’re out, the same workflow applies and the file syncs via iCloud Drive.

Method 1: ignitai on iPad (the on-device way)

ignitai handles invoice extraction as a language task, not a table-coordinate task. The full flow, end to end:

Open the invoice PDF in Mail, Files, or your email client. Tap the share sheet. Pick ignitai. (If it’s not there, scroll right in the share sheet and tap “Edit Actions” to enable it.)
Describe what to extract. For vendor invoices, the prompt that works for almost every standard US/EU template is something like: “For each line item, return description, quantity, unit price, line total, and tax rate. In a separate sheet, return invoice number, issue date, due date, vendor name, subtotal, total tax, shipping, and grand total.” Save this as a preset — the second invoice you process becomes one tap.
Pick XLSX as the output format. XLSX preserves number formatting (currency, decimals, tax rates as percentages) when you open the file in Numbers for iPad or Excel for iPadOS. CSV works too if you’re piping into another tool.
Hit Extract. On iPad Pro M4 or newer running iPadOS 26, the on-device model handles a typical 1–3 page invoice in about 5–10 seconds. On older iPad hardware (or iPadOS 17.4–25.x), ignitai falls back to a hosted pipeline with documented zero retention — still private, just not local.
Review the preview. ignitai shows both the line-item sheet and the header/totals sheet before you save. Spot-check three things: the line-total sum matches the invoice subtotal, the tax amounts match per-rate, and the vendor name is spelled the way the rest of your ledger spells it.
Save to Files. Drop it in iCloud Drive. Numbers or Excel for iPadOS opens it natively; your Mac picks it up automatically if you run both.

Practical time: about 30 seconds of user time per invoice once the preset is saved. For a batch of vendor bills at month-end, see the batch section below.

Method 2: Numbers + Text to Columns (one-invoice fallback)

If you have exactly one invoice, you don’t want to install anything, and the PDF is genuinely text-based (not a scan):

Open the PDF in Files.
Tap and hold to select the line-item table with your finger or Pencil.
Tap Copy.
Open Numbers. Create a new sheet. Paste.
Tap Organize → Convert Text to Columns. Fix the boundaries manually.
Type the header metadata (invoice number, date, vendor) into a separate sheet by hand.

This only works on clean text-based PDFs with a simple line-item grid. The moment you hit a scan, a multi-line description, or a merged cell, the copy fails and you’re typing everything. For a single invoice from a vendor you’ll never see again, fine. For any repeat vendor, skip straight to Method 1 so you can save the preset.

Method 3: AirDrop to Mac

If your Mac is nearby and you don’t need iPad-native processing, AirDrop the PDF over and follow the Mac-side batch workflow. The Mac version of ignitai uses a larger drag-and-drop surface and shows the extracted table on a bigger screen for review. It’s the right call when you have twenty invoices to process at a desk, not three scattered through the day.

The reason this iPad guide exists is that for most people invoices arrive on the device that’s on — which is an iPad or iPhone, not the Mac. Context-switching to a Mac for a 30-second task is its own friction, and across a month that friction turns into “I’ll do it later” and then “I’ll do it at tax time.”

Method 4: Web converters (and why not for invoices)

You can find half a dozen “PDF invoice to Excel” web tools. They work in the technical sense. The reasons not to use them:

You’re uploading. Invoices contain your vendor list, your purchase patterns, your bank reference, and your billing address. Even the “secure” converters send the file to a server you don’t control. For a competitor-intelligence-free small business, this is category-adjacent to uploading bank statements.
Free tiers are feature-gated. Expect 1–3 files/day before you hit a paywall, watermarks, or a “sign up to download” gate. Three invoices in, the math stops favoring the web tool.
Invoice-aware extraction is rare. Most web converters treat every PDF as a generic “table in a document” and miss the header metadata entirely. You get line items with no vendor name. That’s worse than useless — it’s an invoice you can’t reconcile.

For a public demo PDF they’re fine. For live vendor bills, no.

Cleaning the output: the checks that matter

Three quick checks separate “I have a file” from “I have a usable bookkeeping row”:

Line-total reconciliation. In the line-item sheet, add a column: =quantity * unit_price. It should equal the extracted line_total for every row. Where it doesn’t, the vendor applied a discount or rounding convention you need to note, or the extractor misread a number. Either way, catching it here costs 30 seconds; catching it at year-end costs hours.
Tax reconciliation. Sum the per-line tax amounts. It should equal the total-tax value from the header sheet. European invoices often split across multiple VAT rates; keep them in separate columns (tax_standard, tax_reduced) or you’ll lose the per-rate breakdown your accountant needs for the VAT return.
Date format. Invoice PDFs use 04/17/26, 17 Apr 2026, 2026-04-17, and a dozen other variants. Standardize on ISO (YYYY-MM-DD) in Numbers before any date arithmetic: select the column → Format inspector → Date & Time → ISO 8601. Your aged-payables report will thank you.

Skip these three checks and you’ll find the error at reconciliation time, when the P&L is off by $47.83 and you have no idea which of forty invoices is to blame.

Batch mode: month-end in one pass

The real win is end-of-month, when you have twenty invoices from twelve vendors in a Files folder and your accountant wants one consolidated sheet.

On iPad:

In Files, select all the invoice PDFs. Hit Share → ignitai.
Apply the same extraction prompt across the batch (or the saved preset).
ignitai processes them sequentially on-device and produces a single XLSX with two sheets — line_items and invoices — both with a source_file column so every row traces back to its PDF.
Open in Numbers. Pivot by vendor, by month, by tax rate. Hand the file to your accountant.

For quarterly VAT or tax-year prep, this is the difference between a half-day and an afternoon. For monthly bookkeeping discipline it’s the difference between doing it and not.

When this workflow doesn’t fit

Honest edge cases:

Invoices with embedded images of line items. A few suppliers ship PDFs where the table is a rendered screenshot. ignitai handles these via the scan path (OCR first, then extraction) but the accuracy is a few points lower than on text-based PDFs. Spot-check more carefully.
Project-billing invoices with time-tracked sub-line items. If your vendor bills by the hour with fifty time entries per project, the line-item table can blow past a reasonable sheet size. Ask your vendor for a CSV export — most time-tracking tools have one.
Invoices in non-Latin scripts without translation needs. ignitai’s prompt can include “preserve original-language descriptions” or “translate descriptions to English.” Pick one explicitly or you’ll get inconsistent output across the batch.
Credit notes and partial refunds. These look like invoices but the amounts are negative. Add “credit notes should have negative line_total and negative total values” to the prompt, or sort them into a separate batch.

Bottom line

For one invoice, on iPad, that needs to end up in Excel: install ignitai, hit Share → ignitai, save the XLSX. For a month of vendor bills, the same workflow batches transparently with source-file provenance baked in. For the actual edge cases — time-tracked project invoices, non-Latin scripts, credit notes — tighten the prompt or fall back to vendor-native exports.

The point of doing this on iPad specifically is that the PDFs are already there, the on-device AI in iPadOS 26 means the invoice never has to move, and the Mac-side batch workflow is one AirDrop away when you want a bigger screen for review. The iPhone version of this workflow uses the same app and the same presets, so captures on the go sync cleanly.

Get ignitai on the App Store — free download, $19.99/mo unlocks unlimited extractions and batch mode after the 3-day trial.