How to Convert a Scanned PDF to Excel

Scanned PDFs have no text layer at all. Here's how to tell if yours is one, and how to get real spreadsheet data out of it anyway.

More from this article

  • A scanned PDF is a different problem from a regular one, even though both have the same file extension. A PDF exported from an accounting system or Word has an actual text layer underneath, the letters are stored as letters. A scanned PDF, a photocopy, a fax, a phone photo of a paper document saved as PDF, is really just a picture of a page wearing a PDF file extension. There's no text to select, copy, or extract in the normal sense, which is exactly why "convert PDF to Excel" and "convert a scanned PDF to Excel" aren't quite the same task.
  • How to tell if your PDF is actually scanned
  • Before anything else, it's worth checking which kind of PDF you actually have, the fix is different depending on the answer:
  • A related giveaway: if the PDF came from a scanner, a fax machine, or a "scan to PDF" phone app, it's almost certainly the scanned kind regardless of how clean it looks on screen.
  • Why a scanned PDF needs a different approach
  • Because there's no embedded text layer, a tool that only reads text-layer PDFs will return nothing useful from a scanned one, not an error, sometimes just an empty or garbled result, because there's genuinely no text for it to find. Getting data out of a scanned PDF requires reading the page visually and recognizing the text and structure from the image itself, the same underlying process covered in What Is OCR and How Does It Work?.

Keep reading