Home   Articles   PowerPoint Tricks   Best Methods to Insert Data from Excel in PowerPoint

Best Methods to Insert Data from Excel in PowerPoint

Excel spreadsheets often contain data that needs to be presented in the form of a PowerPoint presentation to explain data, trends and forecasts. Recreating Excel data in PowerPoint can be quite time-consuming. There is an easier way to show Excel data in PowerPoint and it takes just a few seconds to import it. You can learn all about the three best methods to insert data from Excel in PowerPoint by following simple steps given below.

Method 1: Link an Excel Worksheet to PowerPoint

You can link an Excel worksheet to PowerPoint by going to Insert-> Object.

insert object in excel

In the next step, click Create from file, and select the Excel worksheet you wish to link.

create from a file

Make sure you check the Link checkbox and click OK.

Advertisement

Note: A linked object displays data from your top Excel worksheet from the selected file. In order to link your desired worksheet, make sure it is the top worksheet in your Excel file, i.e. the worksheet you see first when you open the Excel workbook.

link excel spreadsheet

Method 2: Link a Section from Excel to PowerPoint

If you want to link a section of your excel data to PowerPoint, you can copy the data you want to insert into PowerPoint, go to the Home tab in PowerPoint and select Paste -> Paste Special.

paste data in powerpoint from excel spreadsheet

Now, select Paste Link and select Microsoft Excel Worksheet Object and click OK.

insert data from excel in powerpoint

Method 3: Insert Unlinked Excel Data in PowerPoint

You can also insert unlinked data from Excel in PowerPoint. To do this, simply copy the data in Excel that you wish to insert in PowerPoint and go to Home -> Paste to select an option to paste the unlinked data. The available options allow you to use destination theme, keep the source formatting, embed data to edit it later in Excel, keep text only or paste the data as an image.

paste excel data in powerpoint

Using either of the two methods given above will enable you to insert your Excel data in PowerPoint.

excel data in powerpoint

Using the methods given above you can save time in making your PowerPoint slides by inserting data right from your Excel workbook. This can not only save you valuable time but also make it easier for you to show your Excel data in the form of individual slides without the need to recreate it in PowerPoint.

Advertisement

Related Articles

Leave a Reply

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation. If you have questions regarding how to download the templates, please visit this link.