Use the contact form or online chat in the sidebar for a consultation. Let our experts help you with your OCR project. ScanStore has been exclusively focused on OCR data capture and forms processing solutions for over 20 years. 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.Ĭomplex 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. 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. What they can’t do well is data validation or appending multiple documents to a single spreadsheet to build a dataset. 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. These applications can convert standard table data to individual spreadsheets. The first scenario can be managed using desktop OCR applications like ABBYY FineReader, ReadIRIS and Kofax OmniPage. You can also merge multiple converted files to generate one master output file.Īdditionally, Nanonets can compute derived metrics based on the data in the converted bank statement.Convert PDF to Excel Spreadsheet or Google Sheet Simple Tables and Reports This would help customise the output of the converted bank statement. Nanonets can customise the selection of tabular data to just the pages, columns, rows or cells of your interest. So what if you want to customise the output? Sign up to Nanonets to check out advanced features. Not all the data in the bank statement must be relevant to you. Download your converted CSV bank statement file by clicking 'Download.

You should now be able to see a preview of the data captured from the bank statement. Step 2 - Click ConvertĬlick ‘ Convert to Excel’ to convert your bank statement. You can choose to recognise all text in the bank statement or only restrict the converter to tabular data. Select the PDF bank statement from your computer, or just drag and drop into the upload box. Here are the steps to convert bank statements using Nanonets' free bank statement converter: Step 1 - Add bank statement How to Convert Bank Statements to Excel with Nanonets How to convert bank statement to Excel with Nanonets

Ocr pdf to excel expense sheet