Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Need help with extracting data from a scanned form

New Here ,
Jul 27, 2022 Jul 27, 2022

My office has collected thousands of paper forms from customers.  The forms were all physically scanned and saved into one large pdf document. Each page of this document  is one distinct form.  Is there a way that I can extract certain data points from each page of this document (Customer Name, Employer, email address) and export the data into an excel file?

TOPICS
How to , Scan documents and OCR
2.0K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Jul 31, 2022 Jul 31, 2022

Hi Jane,

Hope you are doing well.

 

 Is there a way that I can extract certain data points from each page of this document (Customer Name, Employer, email address) and export the data into an excel file?

 

This would have been much easier if it was supposed to be extracted from a Fillable PDF form or if it was an interacting form and distributed via Adobe Acrobat. 

 

However, it's a Scanned paper form, so we can try it by converting it to an interactive PDF form using Adobe Acrobat. To do that,

  • Choose Tools > Prepare Form.

  • Once done, click More> Export data> You can export form data as an FDF file, an XFDF file, an XML file, or a text file. 
  • Enter a name for the file and the folder where you want to store the data file.
  • Click the Save as Type drop-down arrow and select the file format you want to use.
  • Click Save.

Note: This may or may not give you an accurate result, as it's initially a paper form. 

 

Thanks,

Akanchha

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 31, 2022 Jul 31, 2022
LATEST

For this tasks there are specialized OCR tools available at the market such as ScannerVision. Those allow to define to scan certain areas of scanned documents for specific data to execute predefined workflows. Acrobat isn't able to such things.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines