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

This thread is solved

Nikhil Patki

New member
1707535681763.png
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
 
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
 
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.
 

Online statistics

Members online
0
Guests online
14
Total visitors
14

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top