Create a PowerPoint Presentation From Excel (no code)

John WilsonCEO PowerPoint Alchemy


Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data and added a title and bulletted text based on the data. This article shows you how how to do this with no code at all.

There are several steps that will sound complicated at first reading but it is actually quicker to do than to explain.

The Excel Data

The text based data needs to look like this. The first entry on each line is the title and the other entries will end up as bullets. Each new line will create a new slide.

excel1.jpgYou may have as many lines as you wish and each line may contain more points that will become bullets. Bear in mind that too many bullet points will create very busy slides.

Convert To PowerPoint

The first step is to save your Excel file as a CSV (Comma Separated Values) file. Do this by choosing SAVE AS and then changing the Save Type to CSV (Comma Delimited) *.csv. You will get messages that some features are not supported. Ignore these and choose to continue saving.

Once saved you need to open the csv file in WORD. To do this open WORD and choose Open then select "All Files" instead of "All Word Files".

In Word the file should look like this:

excel2.jpgIn order to make the file readable by PowerPoint you will need to replace each comma with a line break AND a Tab. Do this by choosing replace in Word and then click "More". In "Find what" enter a comma and use the special button to enter a manual line break and a tab character in the Replace with box.

The dialogue should look like this:

excel3.jpgWhen you run the replace you should have:

excel4.jpgSave this as a Text file (*.txt)

Create The Presentaion

Open PowerPoint and choose OPEN. Change "All PowerPoint Files" to "All Outlines" and locate and open the text file you just saved. You should now have the data as a Presentation!
John WilsonCEO PowerPoint Alchemy

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.