Yes, Google Drive can read a scanned PDF for free using its built-in OCR, but there is a catch that matters for financial data: it hands back plain text with the table layout gone, so you end up rebuilding the columns by hand. This guide shows the exact Google Drive steps, explains why the grid disappears, and covers the faster route when you need a clean Excel table you can actually total.
Can Google Drive convert a scanned PDF to Excel?
Partly. Google Drive runs OCR when you open a scanned PDF with Google Docs, turning the image into selectable text. It does not, however, produce an Excel file or keep the table structure. You get a text document, then have to copy that text into Sheets or Excel and rebuild the rows and columns yourself. For a paragraph of text that is fine. For a statement or a ledger, the cleanup is the real work.
How to convert a scanned PDF to Excel in Google Drive, step by step
The path runs through Google Docs, because that is where Drive applies OCR. Here is the full sequence:
- Upload the scanned PDF to Google Drive (drag it into the Drive window or use New, then File upload).
- Right-click the file, choose Open with, then Google Docs. Drive runs OCR and opens a new Doc with the recognized text at the top and a copy of the original image below it.
- Read through the recognized text and fix any obvious misreads against the scan.
- Select the text, copy it, and paste it into Google Sheets or Excel.
- Use Data, then Split text to columns in Sheets, or Data, then Text to Columns in Excel, to break each line into separate cells.
- Clean up the columns, confirm the numbers are stored as numbers, and export or download as .xlsx.
It works, and it costs nothing. The friction is in steps four through six, which is where a scanned financial table fights back.
Why Google Drive loses your table's columns
Google Drive OCR is built for documents and paragraphs, not spreadsheets. It recognizes the characters and the reading order, but it does not detect cell boundaries, because a scanned page has no grid information to read. So a row that printed as three neat columns comes back as one line of text with the values run together or separated by uneven spaces. Multi-column financial statements scramble the worst, and any cell where the text wrapped onto a second line lands in the wrong place. You are left reassembling the table by eye.
How to rebuild the columns after Google Drive OCR
If you stick with the Drive method, the fastest cleanup is Text to Columns. Paste the OCR text into a single column, select it, open Data, then Text to Columns, and split on the delimiter that separates your values, usually a space or a tab. Then check the numbers: OCR often leaves amounts stored as text, so a SUM returns zero until you fix them. See why your converted numbers come in as text for the repair. Finally, watch for the look-alike misreads OCR makes, like 1 versus l and 0 versus O, and foot the total against the printed figure. For more on keeping figures exact, the accurate PDF to Excel converter page walks through the checks.
When to use a dedicated OCR converter instead
If you do this more than once, or the document is a financial table where the columns are the point, skip the rebuild. A table-aware OCR converter recognizes the scan and maps the characters back into the original grid, so a date, description, and amount land in three separate cells with the figures kept numeric. Drop your file into the converter at the top of this page, or read the full guide to converting a scanned PDF to Excel and the OCR PDF to Excel converter for how the table recognition works. Have a year of statements? Run them through the batch converter in one pass. The same approach handles scanned invoices, which is what tools like invoice OCR software are built for, and AP teams processing supplier bills at volume often pair it with accounts payable automation downstream.
Does Google Sheets have OCR for a PDF?
No. Google Sheets has no built-in OCR and cannot import a PDF directly. The OCR lives in Google Drive and Google Docs, not in Sheets, so you have to recognize the scan in a Doc first and then move the text into Sheets. If you want the data to land in spreadsheet cells in one step, an OCR converter that exports .xlsx or .csv skips the round trip entirely.
How accurate is Google Drive OCR on a scanned PDF?
On a clean, high-resolution scan, Google Drive OCR reads text well, often in the high 90s percent for everyday documents. Accuracy drops fast on low-resolution scans, faint print, skewed pages, and dense numeric tables, which is exactly where financial data lives. Because Drive returns plain text, an error in a figure is easy to miss once the table structure is gone. Scan at 300 dpi or higher, keep the page straight, and always foot the total against the original before you trust the result.
Is it safe to upload a scanned financial PDF to Google Drive?
Google Drive encrypts files in transit and at rest, so the connection itself is secure. The risk with sensitive financial scans is access: who else is on the account, which folders are shared, and how long the file sits there. For one-off conversions, a tool that processes the file and deletes it right after limits how long your data exists anywhere. The same question applies to any online tool, which is covered in is it safe to convert a PDF to Excel online.
Google Drive is a reasonable free option when you have a single scanned page and a few minutes to tidy the columns. For a clean Excel table out of a financial scan, or a stack of them, a converter that keeps the grid and the numbers saves the part that takes the longest. You can also convert a PDF to Google Sheets directly if Sheets is where the data needs to live.