Indezine Logo

  This is the print version of this page. All content is copyright 2000-2018.

Creating PowerPoint Outlines in Excel

Learn how to create outlines for presentations in Microsoft Excel that are formatted for failsafe import into Microsoft PowerPoint.


Product/Version: All Versions

OS: Windows and Mac

Typically, the last thing I would want to do is create my presentation outline in a spreadsheet program like Microsoft Excel. In one of my training sessions, I was showing participants how they could create presentation outlines for PowerPoint in Notepad or Microsoft Word, and one of the attendees wanted to know how he could create an outline in Excel! To understand why anyone would want to create an outline in Excel, you probably need to be an Excel junkie. Rather than go and discuss what an Excel junkie means, I'll show you how an outline can indeed be created in Excel. This technique works on all versions of Excel for Windows and Mac OS X.

  1. Launch a new Excel workbook (see Figure 1).

    Excel workbook
    Figure 1: Excel workbook
  2. Now type in all the text content you want using these guidelines (refer to Figure 2):

    1. For slide titles, use column A.
    2. For first level bullets (or subtitles in a title slide), use column B on a different row.
    3. For the second level bullets, use column C on a different row.
    All text you type in the different column cells will end up being placed as text placeholders in PowerPoint. If you don't know what a text placeholder in PowerPoint is, look here.

    Text content for your slides
    Figure 2: Text content for your slides
  3. As you can see in Figure 2, the text is placed so that PowerPoint can understand which line of text is a slide title, the first level bullet, the second level bullet, etc.
  4. Once you are done, save your workbook as text (tab delimited) file with a .txt file extension, as shown in Figure 3.

    Save workbook
    Figure 3: Save workbook
  5. Thereafter you might see one or two warning windows from Excel that scare you about dire consequences, as shown in Figure 4. Click OK and No buttons in these dialog boxes.

    Warning windows

    Warning windows
    Figure 4: Warning windows
  6. Your outline for a PowerPoint presentation is now ready. To learn how to import this outline into various versions of PowerPoint look here: Outlines: Import.

Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2018, Geetesh Bajaj. All rights reserved.

since November 02, 2000