How to Get PDF Filenames from a Folder into Excel in Python Step by Step Tutorial

In this tutorial, you'll learn how to get files names from folder python read file names from folder python read file names from directory copy list of file names from folder into excel learn easy steps of how to get names of files in a folder to excel How to Automatic Extract Bulk PDF files Names from Folder and Compile them INTO an Excel Sheet by Using Python Commands.

🔍 What You'll Learn:
How to get filenames from a folder into excel sheet tutorial.

Steps:
1. Install python from official Microsoft store.
2. Open cmd run this command 'pip install pdfplumber pandas openpyxl'
3. Create a excel file in same folder with the name of pdf_filenames.
4. Run the python command given below:

import os
import pandas as pd
pdf_folder = 'D:\\pdf'
pdf_files = [f for f in os.listdir(pdf_folder) if f.endswith('.pdf')]
df = pd.DataFrame(pdf_files, columns=['Filename'])
df.to_excel(r'D:\\pdf\pdf_filenames.xlsx', index=False)
print("PDF filenames have been saved to 'pdf_filenames.xlsx'.")
5. Exit python

💬 Join the Discussion!
Have questions or tips of your own? Drop them in the comments below, and don’t forget to like, share, and subscribe for more tips tutorial!

I spend a LOT of time trying to make my videos as concise, polished and useful as possible for you - if you would like to support me😁 Hit that subscribe button to join the fam on this new hajvery tech adventure!

🔔 STAY CONNECT WITH THE HAJVERY TECH
👉 Twitter X: https://x.com/Hajvery_Tech/

#Python #PDFExtraction #ExcelAutomation #DataProcessing #CodingTutorial #TechTips #Programming #HajveryTech #TechTips

------------------------------------------------------------------
📌 Copyright Disclaimer:
Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. Hajvery Tech YouTube Channel
------------------------------------------------------------------

Видео How to Get PDF Filenames from a Folder into Excel in Python Step by Step Tutorial канала HAJVERY TECH