<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Create a PowerPoint Presentation From Excel (no code)

Published on
4,347 Points
1,347 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
Author:JSRWilson
0 Comments

Featured Post

Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month