How to Export Excel Data to PowerPoint (3 Ways)

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will learn the methods of linking an Excel file to a PowerPoint. By doing so, we can present our Excel data in a PowerPoint slide.

PowerPoint offers a convenient way when it comes to presenting data. As both Excel and PowerPoint are Microsoft products, linking the two is relatively seamless. So, you may choose PowerPoint to present your Excel data.

Excel to PowerPoint

Download Practice Workbook

You can download the workbook from here and practice yourself.

Benefits of Linking Excel and PowerPoint

Linking an Excel file automatically to PowerPoint offers useful benefits.

  • This is a time-saving technique. You need not manually type all the data in PowerPoint one by one.
  • There are a variety of paste options available in PowerPoint. You may choose your required one.
  • The entire process is seamless and error-free.

Insert and Update Excel Data in PowerPoint: 3 Ways

  • We will link Excel data to PowerPoint using the following dataset.

img2-dataset to link to PowerPoint

1. Linking an Entire Worksheet to PowerPoint

  • We will link this entire worksheet to PowerPoint.

img3-linking entire worksheet to PowerPoint

  • Go to Insert >> Object.

img4-inserting object in PowerPoint

  • Insert Object window will appear.
  • Select the options as shown in the following image to browse for the Excel file.

img5-browsing for Excel file

  • Select the Excel file and click OK.

img6-Excel file selection

  • Check the Link option and click OK.

img7-link creation in PowerPoint

  • As a result, the entire worksheet will be inserted into the PowerPoint slide.

img8.1- Excel data is linked to PowerPoint

2. Linking a Section of Excel Data to PowerPoint

  • We will link a portion of the worksheet (up to row 9) to PowerPoint.

img8-dataset for partial linking

  • Select cells B2:E9.
  • Click on Copy.

img9- Copying a part of the dataset

  • In PowerPoint, select Paste >> Paste Special.

img10- Pasting Dataset

  • The Paste Special option will pop up.
  • Select the options as shown in the following image.

img11- Paste Option selection

  • Hence, the selected portion of the worksheet will be linked to the PowerPoint slide.

img12- Part of the dataset is linked to PowerPoint

3. Updating Linked Excel Data in PowerPoint

  • Sometimes, you’ll need to update the slide if you want to reflect any corresponding change in the worksheet.
  • We’ll change the value of cell D6.

img13- Dataset to be updated

  • The value of cell D6 is now changed to 7.

img14- Data is changed

  • The data in PowerPoint is not updated.
  • We need to update the data in PowerPoint now.

img15- data in PowerPoint is not updated

  • Right-click on the dataset and select the Update Link option.

img16- select the update link

  • Consequently, the data is updated in the PowerPoint slide.

img17- data is updated

How to Copy and Paste Static Excel Data in PowerPoint

  • We can copy and paste data from Excel files in a static manner.
  • As a result, changes in Excel data won’t be reflected in the PowerPoint slide.

img18- static dataset

  • Select cells B2:E13.
  • Click on Copy.

img19- Copying dataset from Excel

  • In PowerPoint, go to Paste >> Keep Source Formatting.

img20- paste option in PowerPoint

  • The data will be copy pasted in a static manner consequently.

img21- data is copied in static form

Things to Remember

While working with the Excel to PowerPoint linkage, you should remember the following issues.

  • Decide whether you want to create a dynamic or static linkage before establishing a link.
  • Use the paste option in PowerPoint that serves your purpose best.
  • Remember that a change in Excel data may not necessarily reflect on the PowerPoint slide.
  • You can copy and paste almost everything (graphs, images, etc) from Excel to PowerPoint following the methods mentioned in this article.

Frequently Asked Questions

1. Can we export MS Excel files directly as PPT?

No, MS Excel files cannot be directly exported as PPT.

2. How do I copy Excel into PowerPoint without lines?

You can use the paste special option to copy and paste Excel into PowerPoint without lines.

3. How do I export a file in PowerPoint?

To export a file, you need to go to Select File >> Export.



In this article, we have explored the methods to link Excel files to PowerPoint slides. This enables us to present our data in a better way. If you have followed this article thoroughly, you will be able to implement these methods yourself. Feel free to let us know in the comment section if you face any issues doing so. Team Exceldemy will be there to solve your issue. Have a good day!

Excel to PowerPoint: Knowledge Hub

<< Go Back to Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hadi Ul Bashar
Hadi Ul Bashar

Hadi Ul Bashar holds a BSc degree in Biomedical Engineering from Bangladesh University of Engineering and Technology.  In January 2023, Bashar joined SOFTEKO as an Excel and VBA content developer. Since then, he has authored over 50 articles. He was engaged in two specialized training programs focused on VBA and Chart & Dashboard designing in Excel. Currently he is creating video content on Excel and VBA and has created over 70 videos. Reading books and traveling are his... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF