Splitting PDFs + renaming PDFs (using Excel)

A small script that renames PDFs using an Excel file and splits PDF pages.

IMPORTANT

BACKUP YOUR FILES BEFORE PROCEEDING.

VIDEO TUTORIAL/EXPLANIATION:

https://www.youtube.com/watch?v=E__BORbSOdk

Note: This tutorial assumes you have:

1. Python 3.9.5
2. pip3
3. Visual Studio Code (VSC)

STEPS

1. Change default profile within VSC:

   • CTRL + SHIFT + P
   • Search "Terminal: Select Default Profile"
   • Click "Command Prompt"

2. Create and activate the virtual environment + install library (run commands in a new CMD terminal)

   1. py -m venv venv
      • (Creates virtual environment)
   2. venv\Scripts\activate
      • (activates virtual environment)
   3. python -m pip install --upgrade pip
      • (Upgrade pip in virtual environment)
   4. pip3 install -r requirements.txt
      • (Install the required libraries for this project)