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.

Convert Excel to PowerPoint

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.

excel to powerpoint

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.

spreadsheet to powerpoint

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.

spreadsheet to ppt

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.

excel spreadsheet powerpoint

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

Notice:

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 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

5 comments on “Convert Excel to PowerPoint with Excel2PowerPoint

  1. Hi,
    this Add-in looks great. Unfortunatly I can’t get it working on Win8.1 and MS Office 2013. There is a runtimeerror 5 Message: unvalid procedure or argument. If I click on “debug” I am pointed towards the sub “createToolBar” in line 12 “iHelpMenu = …
    Any Idea how to solve this?

    All the best
    Sebastian

Leave a Comment

Your email address will not be published. Required fields are marked *