How to convert a PDF to Excel
There are four practical ways to get a PDF into a spreadsheet. Which one works depends less on the software and more on how the PDF was made — and whether the page is text or a picture of text.
Convert your first PDF freeEncrypted files
Protected in transit and at rest
Private to your account
Never used to train AI models
Payments by Stripe
We never store your card number
Test before you buy
Check accuracy on your own docket
Step 1 — find out what kind of PDF you have
Open the file and try to select a line of text with your cursor. If the characters highlight, it is a text PDF and simple methods have a chance. If nothing highlights, the page is an image — a scan, a fax or a phone photo — and it needs OCR before any spreadsheet tool can see numbers.
- Text PDF: exported from an accounting or ordering system
- Image PDF: scanned, photographed or faxed paperwork
- Mixed: a printed form with handwriting added on top
Step 2 — try the built-in Excel import
In Excel, go to Data, then Get Data, then From File, then From PDF. Excel lists the tables it can find and previews them in Power Query. For a single tidy table this is fast and free. It falls over when a description wraps onto two lines, when the header repeats mid-page, or when columns are separated by whitespace rather than rules.
Step 3 — clean up with Text to Columns
If you have pasted the PDF text straight into a sheet, select the column, choose Data then Text to Columns, and split on a delimiter or fixed width. This is workable for one document. It becomes unmanageable across suppliers, because every layout needs a different split and every wrapped line breaks the pattern.
- Check that quantities and prices arrive as numbers, not text
- Watch for thousands separators and trailing units such as 'kg'
- Re-check totals against the PDF before trusting the sheet
Step 4 — use a converter that understands the document
Generic converters copy the visual layout. A document-aware converter looks for the fields that matter — product code, description, quantity, unit price, line total — and puts each in its own column no matter how the supplier laid the page out. That is the difference between a sheet you have to repair and one you can total straight away.
- Delivery dockets, supplier price lists and utility bills each get their own extraction
- Scans, carbon copies and phone photos are read with OCR first
- Every file comes back as a Data sheet plus a Summary sheet
- The finished Excel is emailed to you when it is ready
When each method makes sense
For a one-off, clean, text-based table, Excel's own import is the quickest route and costs nothing. For paperwork that arrives every week from a dozen suppliers in a dozen layouts, the time spent repairing generic output is the real cost — that is where a specialist conversion pays for itself in the first hour.
Frequently asked questions
- How do I convert a PDF to Excel?
- Open the PDF, check whether the text can be selected, then either paste into Excel and use Text to Columns, use Excel's Data > Get Data > From PDF option, or upload the file to a converter that reads the table structure. Scanned pages need OCR before any of those work.
- Can I convert a PDF to Excel for free?
- Yes, for simple documents. Excel's built-in From PDF import and free web converters handle a single, clean, text-based table well. They struggle with multi-column layouts, wrapped descriptions, stamps, handwriting and scans — which is most trade paperwork.
- Why does my converted spreadsheet come out in one column?
- Because the converter kept the visual layout instead of the table. A PDF stores characters and positions, not rows and cells, so anything that guesses at column edges will merge a wrapped description into the next field.
- How do I convert a scanned PDF to Excel?
- The page has to be read as an image first. OCR turns the pixels into characters, then the line items still need to be mapped into columns. Our scanned-document conversion does both in one step, including phone photos of carbon copies.
- Which method is best for delivery dockets and price lists?
- For repeated, layout-varying documents, a converter that understands the document type beats a generic one. DocketExcel reads dockets, supplier price lists and utility bills specifically, so the same columns come out regardless of which supplier sent the page.
Stop re-typing paperwork
Check accuracy on your own test document free within 7 days. No card needed, no automatic charge.
Get started