PDF/Image to Text (OCR)

Reads text out of a PDF, an image file, or an image that's already pasted into your worksheet, and writes the recognized lines into a new "OCR" sheet - line per row, words separated into columns based on layout.

When to use it

  • Turning a scanned rent roll, T-12, or appraisal PDF into Excel rows you can work with
  • Extracting text from a screenshot or photo of a document that wasn't shared in editable form
  • Quickly grabbing the contents of a single page or range of pages out of a long PDF
  • Pulling tabular text out of a chart image into rows for further parsing

How it works

  1. 1
    Click PDF/Image to Text in the More Tools dropdown.
  2. 2
    Quick path - if a picture is already selected on the worksheet, SkySuite immediately exports it to a temp file and OCRs it without a dialog.
  3. 3
    Picker path - otherwise the OCR window opens. Drop or browse a single file (PDF or image). For PDFs you can pick a page range.
  4. 4
    Optionally tick Show confidence score to get a recognition-quality readout, and choose Print as multipage to put each PDF page on its own sheet.
  5. 5
    Click Run - SkySuite reads the text out of the file, parses it into a row-by-row matrix, and writes the results to one or more OCR sheets in the active workbook.

Tips & shortcuts

  • Long PDFs have a per-run page cap. If you hit it, split the document or run it in page ranges.
  • Numbers detected in the text are converted to actual numeric Excel values, so a recognized "1,234.56" becomes 1234.56 (not a string).
  • Multipage PDFs default to "one continuous sheet" with a blank row between pages; tick the multipage option in the window to split per page.
  • The confidence score is the average across every recognized word, expressed as a percent.