Two Types of Projects

Converting scanned documents or PDF files to Excel, Google Sheets, CSV and other spreadsheet formats usually involves one of these two scenarios.

  1. Individual documents or reports that have well-defined rows and columns
  2. Large batches of documents with complex tables or separate fields combined to make a table
Convert PDF to Excel Spreadsheet or Google Sheet

Spreadsheet or Google Sheet

Simple Tables and Reports

The first scenario can be managed using desktop OCR applications like ABBYY FineReader, ReadIRIS and Tungsten Kofax OmniPage. These applications can convert standard table data to individual spreadsheets. The output would be one Excel or CSV file per document, and will usually require a bit of clean-up to remove extra text on the document that isn't part of the table. What they can't do well is data validation or appending multiple documents to a single spreadsheet to build a dataset.

Complex Tables or Multiple Field Regions

The second scenario uses data capture software that identifies common data elements across multiple documents and maps them to columns in your Excel, CSV or database output. In these projects, zonal OCR is the most basic application, capturing several data points from each document and exporting them as a single row of data.

Convert PDF to Excel Spreadsheet or Google Sheet

Complex documents that include header/detail data, multiple tables, nested tables or tables with overlapping columns can all be captured and converted to structured data like XML, JSON or relational database tables.

Data Capture Expertise

ScanStore has been exclusively focused on OCR data capture and forms processing solutions for over 20 years.

Let our experts help you with your OCR project. Use the contact form or online chat in the sidebar for a consultation.

Contact Us for FREE Consultation on Your OCR Project

=

Software Options

Desktop OCR, batch scanning and zone OCR, or enterprise data capture platforms, we have software solutions and expertise to handle any OCR to Excel project.