Page 6 / 9

Importing a Table from Excel

Usually, we don't make tables in PowerPoint; we create them in Excel. It is a significantly more efficient program for processing tables. The information presented as a table is often already in a ready-made Excel file. Next, let's learn how to import a table from Excel to a PowerPoint presentation. In practice, importing is done by copying to the clipboard, i.e.:

Copy the table from Excel to the clipboard
Paste the contents of the clipboard into PowerPoint

Downloading and opening the base file

Download and open the Excel file Importing_table_and_chart.xlsx. We copy the table in it to the clipboard.

Importing_table_and_chart.xlsxXLSX · Importing_table_and_chart.xlsx

The Objective

We add a fourth slide to the PowerPoint_Exercise.pptx, to which we will add the table from Excel. It might look like this:

Task: Add a new slide to your presentation

Choose the template Title and Content. Write "Sales tracking" as the title.

Task: Copy the table from Excel to the clipboard

Task: Paste the table into the PowerPoint presentation

Return to your presentation in PowerPoint. Paste the table to the slide by clicking Use Destination Styles. Afterwards the slide should look like this:

Nice

### Pasting an Excel table to a PowerPoint presentation

Move to the slide you want to paste the table. Navigate to the **Home** tab, group **Clipboard**, and click on the arrow pointing down (⌄) in the lower part of **Paste**. Now you will see all pasting options.

Use Destination Styles button is first from the left.

Pasting options

	Use Destination Styles: Pastes an Excel table so the formatting of the table is changed to match the theme/template of the presentation (colors, fonts). The table can still be edited and formatted in PowerPoint.
	Keep Source Formatting: Pastes an Excel table so the formatting of the table remains original. The table can still be edited and formatted in PowerPoint.
	Embed: Pastes the entire Excel workbook to the presentation. Double-clicking the table takes you to Excel, where you can edit the table. The object to be edited is not the original table but a copy of it. Note that all users can double-click to explore the contents of the entire Excel workbook, not just the area attached to the presentation. This import method also increases the size of the PowerPoint presentation by the size of the workbook.
	Picture: Pastes the table as a picture. You cannot edit or format it afterwards.
	Keep Text Only: Pastes the table as text with a tab character indicating the columns. The text can be formatted and edited in PowerPoint, but it cannot be made a table.

Task: Format the table to your liking, and add a text box

Format the table to your liking and to be as clear as possible.

As you probably noticed, Excel and PowerPoint work very well together. They complement each other.

Next, we shall move on to creating charts. Shall we?

Mark as complete: