Excel-based workflow for PowerPoint


The first step is to get the image download from the publisher. It comes as a zip file that you usually download from their FTP site. Click on the icon to the left to simulate extracting the files from a typical download, or browse for a zip file on your computer using the button below. The structure of the zip file must match that of the sample zip file exactly! To make your own in Windows, make a folder and then fill it with other folders that contain .jpg or .jpeg files. Compress it by right-clicking on the first folder, the one that holds all the others, and Send to -> Compressed folder.


Imagine this is Windows and the widget below is a window in the File Explorer. From here you can automatically generate an Excel index, which you will use to give each slide in the PowerPoint a title matching its filename, and put the images in their correct order in the slideshow. Push the button at the bottom of the widget below to make the Excel index for the selected folder. (On my computer, this would be done with a VBA macro.)


With this editable faux-Excel index, you have to scan through the PDF manuscript and see which page the figures are on, and type that page number into the 2nd column of the grid. You can just make up page numbers at random. As I set it up in the Excel file on my computer, the sort order and title will fill in automatically for you, based on the text pattern of the filename and whether any other rows have that same page number. When you're done, scroll to the bottom of the page and click the PowerPoint button. The Excel grid will sort itself and export a slide for each row with a page number.


This project was made possible by: