Convert Excel to PowerPoint with Excel2PowerPoint
Excel to PowerPoint is an interesting open source project available in SourceForge that you can use to convert an Excel spreadsheet into a PowerPoint presentation.
The application is bundled inside an Excel spreadsheet using Macros. As soon as you download the project from the online repository, you will need to unzip and open Excel To Powerpoint.xls file and then enable the Macros.
This will add a new menu and button in Excel and give you instructions how to use the macro. Basically this works in the following way. You fill a Master Table spreadsheet with all the source data that you want to export to PowerPoint, and then prepare a PowerPoint template.
Using the template file, the macro will grab all the information found in the Master Table and process it to generate a PowerPoint presentation.
This program will convert every row in the worksheet “Master Table” into a single slide using a powerpoint template you can create and modify. If you have enabled macros then you should see a menu named “One sheets” to the left of your help menu:
When you enable the macros, in PowerPoint 2010 you will see a new button added to Add-Ins menu. Here click on One Sheets to display the options. When you click on Create One Sheets then will convert the Excel spreadsheet Master Table into a PowerPoint presentation.
You will be asked to choose a template file. The project comes with a free sample template that you can use Sample Template.ppt – This template has a master slide with internal product template slides that will be populated with the rows found in the Master Table.
And here you can see how the Master Table looks. Of course you can change the values and meta data. For example, if you need to convert a spreadsheet into PPT PowerPoint presentation you may be interested to use your own text and descriptions. You can do this by changing the text under Text1, Text2, Descriptive, etc, or changing the column names and target PowerPoint template when you run the macros. Notice that the Excel script uses an identifier column.
Finally, when you run the One Sheets command, the PowerPoint presentation will be created. Using the sample template we could generate a PowerPoint presentation that looks as follows.
It is important to notice that the project is currently only available for 32 bits, but easily I could convert it to 64 bits adding the PrfSafe directive after each declaration. You can do it if you want to run it in a 64 bit machine.
Download Excel to PowerPoint project from Excel2Powerpoint
If you need to run this application in either 32bit and 64bit then we have modified the source code to support this by adding the PrfSafe directive. You can download it from the following link.
1.13 MB zip