How to Convert a Scanned PDF to Excel (Free Methods)

Table of Contents

Common and frustrating are scanned invoices, bank statements, and printed tables, none of which are actually editable because the data inside them isn't. If you've ever tried to copy numbers out of a scanned PDF straight into Excel, you've probably ended up with a single unreadable block of text instead of neat rows and columns. Converting a scanned PDF to Excel requires OCR (Optical Character Recognition) that's specifically good at detecting table structures, not just plain text.

This guide walks you through free ways to convert a scanned PDF into an editable Excel spreadsheet, with notes on which method handles tables best. If your scan is mostly plain paragraphs rather than tables, our guide on converting a scanned PDF to an editable Word document is a better fit.

Why Table Data Is Harder to OCR Than Plain Text

Standard OCR reads characters left to right, top to bottom. Tables break that pattern; rows and columns need to be detected as a structure, not just a string of numbers and words. That's why some free tools accurately convert scanned paragraphs but scramble scanned tables. The methods below are chosen specifically because they retain table structure reasonably well.

Method 1: Convert a Scanned PDF to Excel Using Microsoft Excel

Excel doesn't open scanned PDFs directly for OCR the way Word does, but it can import data extracted through Word's OCR first.

1. Open Microsoft Word and go to File > Open, then select your scanned PDF.
2. Confirm the prompt to convert the PDF into an editable Word document.
3. Once converted, select the table data in Word and copy it.
4. Open Excel, right-click a cell, and choose Paste Special > Text (or use Match Destination Formatting) to preserve rows and columns as closely as possible.
5. Manually check that each row and column are lined up correctly, since this indirect method can sometimes shift cells.

Method 2: Convert a Scanned PDF to Excel Using Google Sheets

Google Drive's OCR engine handles table structures more reliably than most free tools, making this one of the better free options for tabular scans.

1. Upload your scanned PDF to Google Drive.
2. Right-click the file and select Open with > Google Docs (Drive's OCR runs through Docs first, even for tables).
3. Once the text and table appear, select the extracted table and copy it.
4. Open a new Google Sheet, right-click a cell, and select Paste special > Paste values only.
5. Adjust column widths and check that rows aren't merged incorrectly.
6. Use File > Download > Microsoft Excel (.xlsx) if you need an Excel file specifically.

Method 3: Use a Free Online OCR Tool with Table Detection

Some free online OCR tools specifically support exporting to Excel format and are built to detect table borders and structure.

1. Go to a free tool such as Sejda's OCR tool or OnlineOCR.net.
2. Upload your scanned PDF.
3. Select Excel (.xlsx) as the output format, if available, rather than Word or plain text.
4. Run the conversion and download the resulting spreadsheet.
5. Open the file and review columns closely. Table-aware OCR is improving, but merged cells or uneven spacing in the original scan can still throw off the structure.

From testing this myself: simple tables with clear borders (like invoices or basic statements) convert cleanly with most of these tools. Complex or borderless tables often need manual realignment afterward; budget a few extra minutes for cleanup rather than expecting a perfect one-click result.

Tips for Better Table OCR Accuracy

• A scan at 300 DPI or higher low resolution makes it harder for OCR to detect thin table borders.
• Scan straight and flat; even slight skewing can misalign entire columns.
• Tables with visible gridlines convert more accurately than borderless or shaded tables.
• Always double-check numeric columns; specifically, misread digits (like "1" vs "7") are easy to miss at a glance but costly in a spreadsheet.

Comparison: Which Method Should You Use?

Method	Cost	Best For	Table Accuracy
Microsoft Word + Excel	Free (if you own Word/365)	Users who already have Office installed	Moderate
Google Docs + Sheets	Free	Anyone with a Google account, no installation needed.	Good
Online OCR Tools (Excel export)	Free (with limits)	Quick, one-off table conversions	Good, varies by table complexity

Frequently Asked Questions

Why do my table columns get merged or scrambled after conversion?
This usually happens when the original scan has faint or missing gridlines, making it hard for OCR to detect where one column ends and another begins. Re-scanning at a higher resolution or with visible borders can help.

Can I convert a scanned PDF to Excel without any software installed?
Yes, Google Sheets (via Google Docs' OCR) or a free online OCR tool with Excel export both work entirely in the browser with no installation needed.

Is Google Sheets or Microsoft Excel better for OCR table conversion?
Google's OCR through Docs tends to handle table structure slightly better for free, casual use. Excel doesn't OCR directly, so it relies on data first being extracted elsewhere.

What if my scanned PDF has both text and tables?
You may want to use two different guides depending on the content: convert this to Word for the surrounding text, and handle the tables separately using this Excel method. See our related guide on converting scanned PDF documents for additional tool options.

Have you run into a scanned table that just won't convert cleanly? Let me know in the comments what tool you tried; I'm happy to help troubleshoot.