Scanned PDF to Google Sheets

How to turn scanned and photographed tables into an editable Google Sheet

Answer in brief

A scanned PDF is a picture of a page, so there is no text in it to copy. To get its tables into Google Sheets, the page first has to be read with OCR or an AI vision model, and then the rows and columns have to be rebuilt.

The Convert PDF to Google Sheets™ add-on by Easy Image to Text does both steps inside Google Sheets. Upload the scanned PDF, pick the pages, and the tables are written straight into your sheet.

What makes a scanned PDF different

A PDF exported from software, such as an online bank statement or an invoice from an accounting tool, contains real text. A scanned PDF is different: it is an image of a paper page wrapped in a PDF file, whether it came from a scanner, a phone scanning app or a fax.

The quickest way to tell is to try selecting text. If you can't highlight a single word, or a search for a word you can see finds nothing, the PDF is scanned.

This matters because most quick conversion tricks rely on the text already being in the file. With a scan, every number has to be recognised from the image first, which is why PDF table extraction for scanned pages needs OCR or an AI model.

Why the usual methods struggle with scans

Copy and paste

There is no text to copy, so this simply doesn't work on a scanned page.

Opening the PDF with Google Docs

Google Drive can run OCR when you open a scanned PDF with Google Docs. It recovers the words, but not the table: columns usually come out as one long line of text per row, or in the wrong order. You then have to paste everything into Google Sheets and split it back into columns by hand.

Basic OCR tools

Traditional OCR reads characters well on clean scans, but it reads them line by line. Telling which value belongs to which column, especially in tables without borders, is where it tends to fail.

For a side-by-side look at every option, see ways to convert PDF to Google Sheets, compared.

How AI handles scanned tables

An AI vision model looks at the whole page the way a person does. It reads the characters and the layout together, so it can tell where each column starts, which row a wrapped description belongs to, and which line is the header.

The Convert PDF to Google Sheets™ add-on turns every PDF page into an image before reading it. A scanned page and a digital page therefore go through exactly the same process, and scans don't need any special settings.

The extracted data is written to the sheet as plain text, so values like account numbers keep their leading zeros and amounts keep their minus signs.

How to convert a scanned PDF to Google Sheets

  1. Install the Convert PDF to Google Sheets™ add-on from the Google Workspace Marketplace.
  2. Open a Google Sheet and launch the add-on from the Extensions menu.
  3. Upload the scanned PDF. If your scan is a photo or an image file such as JPG or PNG, upload that instead, or paste a screenshot.
  4. Select up to 5 pages by ticking the thumbnails or typing ranges such as 1-3.
  5. Click Extract Data. Each page is written to its own new sheet, usually within 10 to 40 seconds.
  6. Check the numbers against the scan, then click Download CSV if you need the data as a file.

Each successfully extracted page uses 1 credit, and pages that fail do not use any. New users get 3 free credits.

How to get the best results from a scan

  • Scan at a good resolution. 300 DPI is a reliable setting for documents with small print.
  • Keep pages straight and upright. Rotate sideways or upside-down pages before uploading, and avoid strongly tilted scans.
  • Use even lighting for phone photos. Shadows, glare and curled pages make characters harder to read.
  • Prefer the original over copies of copies. Each round of printing and scanning blurs the text a little more.
  • Split very dense pages. If a page holds a huge table in tiny print, crop it into parts and extract each one.

Checking scanned data for errors

Even good recognition can misread a poor scan, so it's worth a quick check before you rely on the numbers, especially for accounting work.

  • Compare totals in the sheet with the totals printed on the page.
  • Look out for look-alike characters: 0 and O, 1 and l, 5 and S, 8 and B.
  • Check decimal points and thousands separators, which can blur together on low-quality scans.
  • Confirm that negative amounts kept their minus sign or brackets.

Frequently asked questions

Can Google Sheets convert a scanned PDF on its own?

No. Google Sheets can't open PDFs at all. Google Docs can run OCR on a scanned PDF, but it gives you text rather than a table, so the columns have to be rebuilt by hand.

How do I know if my PDF is scanned?

Try to select or search for a word you can see on the page. If you can't select it or the search finds nothing, the PDF is a scanned image.

Does the add-on work with phone photos of documents?

Yes. You can upload a photo as an image file or paste a screenshot. Straight, sharp, evenly lit photos give the most accurate results.

Can it read handwritten tables?

Yes, but accuracy depends on how clear the handwriting is. Printed text is read far more reliably.

Does a scanned page cost more credits than a digital one?

No. Every successfully extracted page uses 1 credit, whether it is scanned or digital.

Will the table layout be kept?

Yes. Rows, columns and headers are rebuilt in the sheet. Visual styling such as fonts and colours is not copied.

Have a stack of scanned statements or invoices? Try the Convert PDF to Google Sheets™ add-on by Easy Image to Text: install it free from the Google Workspace Marketplace, or learn more about PDF to Google Sheets conversion.

Last updated: 2026-11-09