Indezine
PowerPoint Tutorials   PowerPoint Templates   PowerPoint Blog

Import Excel Content as Tables in PowerPoint 2013 for Windows

Learn importing content from Excel as tables in PowerPoint 2013 for Windows. Many times, this can be easier and quicker than recreating the table in PowerPoint.

If you want to use a table in your presentation, you can insert a new table on your PowerPoint slide and then enter content within this table as required. However, as it happens frequently, there may be a table already created within Excel or Word, or the table content may already be populated in a bunch of contiguous Excel cells. Whether you have, a ready-made table, or just a group of in contiguous cells in Excel, it is very easy to import it into PowerPoint 2013 for Windows as a table.

Since the Copy and Paste options work similarly for both Excel and Word tables, it really does not matter what your source is, although in this example we are taking a table created within Excel:

  1. Open your Excel sheet that has the required content, as shown in Figure 1. It can be a table as shown towards the top of the Excel sheet shown in Figure 1, or just a group of cells contiguous as you can see below the table.

  2. Figure 1: An Excel Table, or simple content, both are usable
  3. Is Everything in Excel a Table?

  4. Yes, all contiguous Excel cells may look like tables but Excel by itself has a separate definition for a table. While we won't go into what an Excel table is and what it isn't, we just wanted you to be aware that an Excel table has got to do nothing with the resultant PowerPoint table in this tutorial!
  5. Select the set of contiguous cells containing the required content (or the entire table). Then press Crtl + C keyboard shortcut. Alternatively, right-click—and from the contextual menu that appears, select the Copy option as shown in Figure 2.

  6. Figure 2: Copy the required Excel content
  7. PowerPoint Keyboard Shortcuts

    Do you want more keyboard shortcuts?

    Explore our PowerPoint Keyboard Shortcuts and Sequences Ebook that is updated for all PowerPoint versions.

  8. Open your PowerPoint presentation and navigate to the required slide. Then right-click to bring up the five Paste Options as shown in Figure 3 (highlighted in red).

  9. Figure 3: Paste Options for the copied Excel content


  10. Hover your cursor over any of these options and you will see a Live Preview of the table being pasted into the slide. Let us explore these options in the order they are placed, from left to right:
    1. Use Destination Styles (S): Cancels any style and formatting applied to the copied table and pastes it into the active slide as shown in Figure 4. The keystroke S denotes the shortcut for this option.

    2. Figure 4: Use Destination Styles (S) option
    3. Keep Source Formatting (K): Retains the style and formatting applied to the copied table and pastes it into the active slide as shown in Figure 5. The keystroke K denotes the shortcut for this option.

    4. Figure 5: Keep Source Formatting (K) option
    5. Embed (E): Embeds the copied table into the active slide as an object, and not as a table, as shown in Figure 6. The keystroke E denotes the shortcut for this option.

    6. Figure 6: Embed (E) option
    7. Picture (U): Inserts the copied table into the active slide as a picture, and not as a table, as shown in Figure 7. The keystroke U denotes the shortcut for this option.

    8. Figure 7: Picture (U) option
    9. Keep Text Only (T): Pastes the content of the copied table into a text-box as plain text, and not as a table, as shown in Figure 8. The keystroke T denotes the shortcut for this option.

    10. Figure 8: Keep Text Only (T) option
    Tip: Select either the Use Destination Styles (S) or Keep Source Formatting (K) options to paste the copied Excel table (or content) into the PowerPoint slide as a native PowerPoint table.
  11. In Figure 9 below, you can see that we have pasted the Excel table using the Use Destination Styles (S) option. Notice that the two Table Tools contextual tabs (highlighted in red within Figure 9) appear on the Ribbon. Also, the Selection Task Pane displays the name 'Table' (highlighted in blue within Figure 9) to indicate that the copied content has been pasted as a native PowerPoint table.

  12. Figure 9: Excel table pasted as a native PowerPoint table
  13. Hereafter, you can edit the table attributes and content in PowerPoint. You can also change the style of your new table. Figure 10 shows our PowerPoint table after we resized it larger, and applied a new style.

  14. Figure 10: PowerPoint table applied with a new style
  15. Save your presentation.
Note: If you want to import a table created in a Word document into PowerPoint, select the table in Microsoft Word and follow the same procedure.

See Also:

Import Tables: Import Excel Content as Tables in PowerPoint (Glossary Page)

Import Excel Content as Tables in PowerPoint 2011 for Mac