This friendly tool helps you quickly understand what's in your PowerPoint presentations by creating an Excel file with a neat overview of all your slides.
- Scans through all PowerPoint files in a folder you choose
- Picks out the most important phrase from each slide
- Identifies slides that are just images
- Creates a nicely formatted Excel file with all this information
-
Make sure you have Python installed on your computer
-
Create a file named
.env
in the same folder as the program and add your OpenAI API key like this:OPENAI_API_KEY=sk-Abc123xYz456MnP789QrStUvWxYz0123456789
-
Open Terminal (on Mac) or Command Prompt (on Windows)
-
Navigate to the program's folder
-
Install the required packages by typing:
pip install -r requirements.txt
- Open Terminal
- Type
python
(with a space after it) - Drag the
ppt-scanner.py
file into the Terminal window - Type another space
- Drag the folder containing your PowerPoint files into the Terminal window
- Press Enter
If your files are in a folder called "My Presentations", it might look like this:
python /Users/yourname/Desktop/ppt-scanner.py /Users/yourname/Documents/My\ Presentations
The program creates an Excel file named ppt_slides.xlsx
in the same folder as your PowerPoint files. This Excel file will have:
- The name of each PowerPoint file
- The slide numbers
- A key phrase that tells you what's on each slide
- Clear marking of slides that are just images
- The program works with both
.ppt
and.pptx
files - Image-only slides will be marked as "[Image Slide]"
- The Excel columns are sized for easy reading
If you run into any issues or have questions, here are some common solutions:
- Make sure your OpenAI API key is correctly set up in the
.env
file - Check that you have all the required packages installed
- Make sure you're pointing to the correct folder containing your PowerPoint files
This program needs:
- Python 3.6 or newer
- The packages listed in
requirements.txt
- An OpenAI API key