<

Create a PowerPoint Presentation From Excel (no code)

Published on
4,262 Points
1,262 Views
Last Modified:

Outline

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!
0
Comment
Author:JSRWilson
0 Comments

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Join & Write a Comment

This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month