{"id":86,"date":"2019-02-28T19:24:02","date_gmt":"2019-03-01T00:24:02","guid":{"rendered":"https:\/\/www.simpleocr.com\/?page_id=86"},"modified":"2022-06-21T10:56:35","modified_gmt":"2022-06-21T14:56:35","slug":"convert_image_to_excel","status":"publish","type":"page","link":"https:\/\/www.simpleocr.com\/convert_image_to_excel\/","title":{"rendered":"Convert Image to Excel"},"content":{"rendered":"

Two Ways to Convert Image to Excel<\/strong><\/h2>\n<\/div>

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

    \n
  1. Individual documents or reports that have well-defined rows and columns<\/li>\n
  2. Large batches of documents with complex tables or separate fields combined to make a table<\/li>\n<\/ol>\n
    \"Convert<\/a>

    Convert PDF to Excel Spreadsheet or Google Sheet<\/p><\/div>\n

    Simple Tables and Reports<\/strong><\/h3>\n

    The first scenario can be managed using desktop OCR<\/a> applications like ABBYY FineReader<\/a>, ReadIRIS<\/a> and Tungsten Kofax OmniPage<\/a>. 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\u2019t part of the table. What they can\u2019t do well is data validation or appending multiple documents to a single spreadsheet to build a dataset.<\/p>\n

    Complex Tables or Multiple Field Regions<\/strong><\/h3>\n

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

    \"Convert<\/a><\/p>\n

    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<\/a> tables.<\/p>\n

    Data Capture Expertise<\/strong><\/h2>\n

    ScanStore<\/a> has been exclusively focused on OCR data capture<\/a> and forms processing<\/a> solutions for over 20 years.<\/p>\n

    Let our experts help you with your OCR project<\/a><\/strong><\/em>. Use the contact form or online chat in the sidebar for a consultation.<\/p>\n<\/div>\n

    For more information on OCR data capture<\/strong><\/a> check out these articles:<\/p>\n