When to convert a PDF to Excel
- Sort a bank statement into categories and work out what you spent each month.
- Pull a supplier's PDF price list into your own sheet to compare prices.
- Move invoice line items into your bookkeeping without retyping them.
- Filter and sort stock, sales or grade reports that arrived as PDF.
How the conversion works
A PDF does not store tables; it stores small pieces of text, each at an exact spot on the page. The converter gathers the pieces on each line, finds the columns from the wide gaps between them and recognises lines that line up as a table. Every cell lands in its own Excel cell; values that look like numbers become numbers, and bold header rows stay bold. Headings and notes outside the table can go into column A line by line, or be left out.
Everything happens on your device, so the speed depends on your computer or phone; an ordinary bank statement is ready in a few seconds.
What comes through to Excel
| Comes through | Left out or simplified |
|---|---|
| Each value from aligned columns in its own cell | Table borders and cell colours |
| Amounts, quantities and percentages as numbers | Merged cells |
| Thousands separators and two-decimal display | Text that wraps in a table with no date or amount column (stays as separate rows) |
| Descriptions that wrap onto several lines, joined into one cell | |
| Bold header rows | Pictures, logos and signatures |
| One sheet per page, or all pages on one sheet | Formulas (a PDF only holds their results) |
If the result is not what you expected
- Two columns ended up in one cell. In cramped tables with very little space between columns, two values can fall into the same cell. In Excel, use Data → Text to Columns to split that column on spaces.
- Amounts are left-aligned and will not add up. They stayed as text, usually because the amount contains a letter or an unusual symbol. Select the cells and choose Convert to Number from the warning icon.
- Letters come out garbled. Some PDFs draw letters only as shapes; copying the text shows the same problem. OCR PDF helps with these files.
- The Excel file is empty. The PDF is a scan; run OCR PDF on it first.
For other routes, such as Excel's own PDF import or copying through Word, see how to copy a table from PDF to Excel. Working with a bank statement? Converting a bank statement PDF to Excel covers password-protected statements, repeated headers and totalling spending by category; for invoices, converting an invoice PDF to Excel shows how to check line items and VAT and build a monthly invoice list. On a Mac? See converting a PDF to Excel on a Mac for opening the result in Numbers, or converting a PDF to Excel on your phone on iPhone and Android.
Tips for the best result
- If you only need the table pages of a long report, extract them first for a tidier spreadsheet.
- To collect several monthly statements in one table, untick "Put each page on its own sheet"; all pages are written one under another on a single sheet.
- If you also want to edit the text around the table, PDF to Word suits better; Word keeps the table as a table too.
- Only need plain text? Use PDF to text.