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

Creating PowerPoint Outlines in Excel

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

Author: Geetesh Bajaj

Product/Version: Microsoft Excel
OS: Windows and Mac OS X

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 -- but rather than go and discuss what an Excel junkie means, I'll show you how an outline can indeed be created in Excel -- this works on all versions of Excel for Windows and Mac OS X -- for this particular tutorial, I used Excel 2010:

  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.

    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.

PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2016, 2013, 2011, 2010, 2007 and 2003 for Windows
PowerPoint 2016 and 2011 for Mac
PowerPoint Online for Windows and Mac

Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?

Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences ebook.

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-2017, Geetesh Bajaj. All rights reserved.

since November 02, 2000