[Answered] Get Data from Password protected PDf - Bank Statement

[Nikhil Patki]

it is not asking to input password
hence unable to load data in excel from pdf about my bank statement.
even using adobe acrobat
the file is not getting exported to excel workbook
it doesn't show any progress when i select the file and click on export
also nor the file is being exported into excel

 

[Yousuf Shovon]

hence unable to load data in excel from pdf about my bank statement.
even using adobe acrobat
the file is not getting exported to excel workbook

Hello Nikhil Patki,
Thanks for sharing your experience with us.
I understand you are unable to load data in Excel from PDF about my bank statement.
Well, first we need to see if the problem is limited to your first copy of the PDF. To do so:
Scan your document into a new PDF file using Acrobat, then export it to Excel. See this article to export PDF data to Excel.
This is the easiest way.
Another workaround you can follow:
1. open the PDF file in Word, and convert it to Word.
2. Then copy the data from Word to Excel.
Try these methods and let us know.

Regards,
Yousuf Shovon

 

[Nikhil Patki]

You have mentioned a complicated and critical method.
Also these statements are originally sent by bank via mail in PDF format itself.
1) how can I re-scan a PDF file itself again
2. i'm not sure whether PDF can be opened in word.
also even if it opens first i convert to word then to excel to much lengthy as well as complicated process.
as being statement already there are various data cleaning tasks to be performed.