Pdf Data Extraction Using Python | Pypdf2 Extract PDF Data to Excel | Extract Text From PDF to Excel 

Thank you so much! I've broke my brain till was solving such task.

Fantastic. Exactly what I am looking for. Thanks buddy! One quick question. I found you are using 3 PDF files for this demo which are named file1, file2, file3. Should the PDF names should be in some sequential order for iterating each files through loop or can the files names be any?

Vedio for pypdf2 instalation because I have as issue which is download as file like word or internet explorer

can you please share the code used in this video ?

Hello, I have an error : Traceback (most recent call last): File "C:\Users\milad\PycharmProjects\pythonProject5\main.py", line 6, in for file_name in os.listdir('all_format_pdf'): FileNotFoundError: [WinError 3] The system cannot find the path specified: 'all_format_pdf' how can I fixed?

do we need install pre-requisites before. please share how

Sir I have one question,please answer me. I have pdf in regional language like hindi,marathi and font in pdf are not in unicode,then how can i extract data in excel from pdf.I need that pdf data in unicode within excel. Example:- Pdf file like voter lists in regional languages. Please answer me as i am trying all the time but all things are disapointing me. Thanks in advance

Hi can you please tell me is it possible to extract table of similar structures in different pdfs to an excel sheet using python

When running the code at @2.39 I got a syntax error for for file_name. Any idea why? Im using Jupyter Notebook.

I have another question please, how can i extract all pdf pages not only the first page ? Because some of my pdf files have like 14 pages, so how should i extract all of them ?

How u installed pypdf2 in ur pc

Sir, in my case , I have scanned PDF files, I want to copy only a specific text from each page, Text sample xxxxx-xxx-xxx-IR-xxxxx I know only IR is fix on each page, before and after IR I don't know what is the text, but I want to copy all together from each page. Please help. If you and VBA macro please share. Or any other tools. Thanks

Sir I want extract text fields and below table also, can we do that?

Sir, I want to remove header, footer from every pages. Could you please help me?

Anyone knows, how to convert excel file sheets into pdf format using python.

are you on fiverr ???

I am getting an error "zipfile.badzipfile:file is not a zip file" can you pease help me

i am getting that error when tired to run the script ( 'tuple' object has no attribute 'seek')

for file_name in os.listdir('BAML'): print(file_name) #Loop on Files load_pdf = open(r'M:\Public Trade Operation\\Middle Office Package\\2023\\01 January\\Trade Confirmation\\US trades\\BAML\\'+file_name, 'rb') read_pdf = PyPDF2.PdfReader(load_pdf) #Load All Pdf in Variable page_count = len(read_pdf.pages) #Count the pdf pages first_page = read_pdf.pages[0] #read only the first page page_content = first_page.extract_text() #extract string output page_content = page_content.replace(' ','') print(page_content) Hello, I have multiple pdf in the folder, it did show all the pdf name when i print(file_name) However, it only print the content of the first pdf rather than all of them Would you please take a look, thx a lot

Bro I've done exactly like you and installed the libraries required, but there's an error popping up in line 4 ( for file_name in os.Listdir('.........') ) The error is: FileNotFoundError: [WinError 3] The system cannot find the path spacified: '....' Do you have any solution might help please ?

Can you please send me the code sir.

My last question 😁 I'm trying to extract this data from the pdf files into just 2 columns in excel, first column is the pdf file names and second column is the text what I have extracted for each pdf file name, I used your method in the video but it only works for the pdf file names in column 1 and second column for the text what I extracted no, always when I run the code for both columns it pops up long error [ Traceback ( most recent call last): ........... in check_string raise IllegalCharacterError openpyxl.utils.exceptions.IllegalCharacterError ] And when I run the code just for the first column, it works well and it writes the pdf file names in the first column in excel. l just want to write the text what I have extracted for each pdf file in excel in column 2 I don't want to write specific details like names and addresses and mob no I want to write in excel the whole extracted pdf text, if you have any tips or solution for that please tell me and thank you so much 🤗

hi sir, i have doubt, i need extract specified text like email -xxxxx@xxxx phone nos-(xxx)xxx-xxxx and name in a sheet and convert the data into excel or csv.wrote this program. plz help to solve . code mentioned below. import PyPDF2 import openpyxl import re import pytesseract as tess tess.pytesseract.tesseract_cmd=r"C:/Tesseract-OCR/tesseract.exe" from PIL import Image excel=openpyxl.Workbook() sheet=excel.active sheet.title='pdf' sheet.append(['phone number']) pdfFileObj = open('C:\Program Files\Python310/filename.pdf', 'rb') pdfReader = PyPDF2.PdfFileReader(pdfFileObj) num_pages = pdfReader.numPages count = 0 text = "" #The while loop will read each page. while count < num_pages: pageObj = pdfReader.getPage(count) count +=1 text += pageObj.extractText() text=text.replace(' ','') #print(text) print('---------') """ """ phone = re.findall('\(\d{3}\)\d{3}-\d{4}', text) #print(phone) zip_code=re.findall('\d{5}',text) my_zip=set(zip_code) #print(my_zip) email=re.findall('@*?\.',text) print (email) sheet.append(['phone','zip_code']) excel.save('C:\Program Files\Python310/file.xlsx') print('DONE!!')