To convert a scanned PDF to Excel, use optical character recognition (OCR), export the recognized table, and check the resulting rows and columns against the original. A scan is a picture of data, so ordinary copy and paste may not produce usable cells. No conversion method can guarantee perfect columns on every document.
This guide explains documented Adobe and Microsoft workflows and provides a worked checking example. It is a documentation-based guide, not a hands-on accuracy ranking.
Choose a method for your document
- A complete scanned PDF: start with an OCR-capable PDF application such as Acrobat.
- One small, clearly printed table: try Excel’s Data from Picture feature using an image of the table.
- A PDF with selectable text: a PDF table importer may work without a separate OCR step. Check the import preview before loading the data.
Try selecting an individual word in your PDF. If you can only select the page as an image, OCR is likely needed. Selectable text is a useful clue, but does not guarantee accurate table structure.
Method 1: Export a scanned PDF with Adobe Acrobat
- Open a copy of your PDF in Acrobat.
- Find the PDF export tool. Adobe’s documented workflow uses Export PDF.
- Select the spreadsheet output and Microsoft Excel Workbook.
- Export the file. Adobe says text recognition runs automatically when the document contains scanned text.
- Save the workbook and open it in Excel for checking.
Menu labels can vary by application version. Check that your Acrobat plan includes the required conversion and OCR features; do not assume the free Reader app or a free online conversion has identical capabilities. See Adobe’s PDF-to-Excel instructions.
Method 2: Import an image of a table into Excel
For a small table, capture a clear, straight-on image of the relevant PDF area. Crop out unrelated page content without cutting off headings or values.
- In a supported Excel for Microsoft 365 installation, choose Data > From Picture > Picture From File.
- Select the image and let Excel analyze it.
- Review the recognized values and correct errors in the preview.
- Select Insert Data, then compare the worksheet with the source.
This method takes an image, rather than importing the PDF directly. Availability and menus depend on your platform and version. Microsoft lists Windows requirements and separate platform instructions in its Data from Picture documentation.
A worked example: check values, not just appearance
The following is invented practice data, not output from a tested converter. Imagine a scanned invoice with these two lines:
- Item A: quantity 2, unit price $15.00, line total $30.00.
- Item B: quantity 3, unit price $8.50, line total $25.50.
The expected subtotal is $55.50. If quantity is in column B, unit price in C, and line total in D, enter =B2*C2 in a spare column and compare it with D2. Repeat for the second item. Then use =SUM(D2:D3) to check the subtotal.
A matching subtotal is only one check. Two incorrect rows can cancel each other out. Compare the individual quantities, descriptions, and amounts too.
Fix common conversion problems
- Descriptions split across rows: compare each wrapped description with the PDF before joining cells or deleting rows.
- Headers repeated between items: check page boundaries and remove only repeated headings, not transaction records.
- Amounts in the wrong column: check the column labels and the first and last rows on every page. Re-import a smaller table area if necessary.
- Missing leading zeros: treat identifiers such as ZIP codes and invoice IDs as text before import where possible. Formatting afterward cannot recover information already lost; return to the original.
- Ambiguous dates: confirm the source convention. In a US-format example, 04/05/2026 means April 5; a document using day/month/year means May 4.
Microsoft explains how Excel handles leading zeros and long identifiers. Its PDF connector documentation also discusses large files and multiline-row problems.
Before using the spreadsheet
Keep the source PDF alongside the workbook. Check row counts, blank cells, page breaks, decimal points, negative signs, and totals. Use an approved service for business documents, and remove unnecessary personal details before uploading files.
Frequently asked questions
Will the original formulas be restored?
A scanned page displays printed results, not the original spreadsheet formulas. Recreate calculations in Excel and compare their results with the source.
Why does a neat-looking spreadsheet still contain errors?
Readable formatting does not prove that every character or row was recognized correctly. Check the data itself, especially identifiers and amounts.
Should I use a chatbot instead?
A chatbot may offer another extraction workflow, but a plausible-looking table still needs source-by-source checking. For more context, read how PDF uploads work in Claude, or browse our AI tools directory.