Insert Excel data in PowerPoint

You can link data from a saved Excel spreadsheet to your Microsoft PowerPoint 2013 desktop presentation. So if data changes in the spreadsheet, you can easily update it in your PowerPoint presentation.

Link an entire Excel spreadsheet to PowerPoint

  1. In PowerPoint, on the Insert tab, click or tap Object.

    Insert Object

  2. In the Insert Object dialog box, select Create from file.

    Create from file

  3. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to.

  4. Before you close the Insert Object box, select Link, and click OK.

    Click Link

    Important    The linked object in your presentation displays all the data from the active, top spreadsheet tab in the linked Excel workbook. When you save the Excel workbook, make sure the spreadsheet you want in your presentation is the one you see when you first open the workbook.

Link a section of data in Excel to PowerPoint

  1. In Excel, open the saved workbook with the data you want to insert and link to.

  2. Drag over the area of data you want to link to in PowerPoint, and on the Home tab, click or tap Copy.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Home tab, click the arrow below Paste, and select Paste Special.

    Paste Special

  5. In the Paste Special box, under As, select Microsoft Excel Worksheet Object.

    Choose Microsoft Excel

  6. Check the Paste link box, and click OK.

Copy and paste (unlinked) Excel data in PowerPoint

In this case, the Excel data will not be linked to your PowerPoint presentation. You copy the data from an Excel worksheet and paste it into your presentation. The worksheet does not send automatic updates to PowerPoint.

  1. In Excel, open the workbook with the data you want to copy.

  2. Drag over the area of data you want to copy, and on the Home tab, click or tap Copy.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste.

  5. Under Paste Options, pick one of the following:

    • Use Destination Styles Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation.

    • Keep Source Formatting Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the spreadsheet.

    • Embed Embed to copy the data as information that can be edited in Excel later.

    • Picture Picture to copy the data as a picture that can't be edited in Excel.

    • Keep Text Only Keep Text Only to copy all the data as a single text box.

      Tip    Move the mouse pointer over each Paste option to see a preview of what the pasted selection would look like.

See Also

Copy an Excel chart to another Office program

Applies To: PowerPoint 2013



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language