Skip to main content

How to convert Excel to PowerPoint with AI

Posted
Written by Tina Benias
Abstract image of a PowerPoint presentation and Excel sheet

Turn an Excel spreadsheet into a draft PowerPoint presentation with Copilot in Microsoft PowerPoint. An Excel workbook can hold valuable data for a presentation, including key figures, trends, and results. Copilot can use that information to draft slides with charts and tables that make the data easier to showcase and present.

Learn how to convert Excel to PowerPoint with AI assistance and refine the generated slides to create a clear presentation.

How to convert Excel data into presentation slides with Copilot

Copilot can use the data in an Excel workbook to draft presentation slides with charts, tables, and key insights. Use the following steps to create a draft presentation from an Excel workbook.

  1. Save the workbook to OneDrive or SharePoint, with clear column headers and one table per sheet.

  2. Open a new or upload an existing presentation in PowerPoint and start a chat with Copilot.

  3. Attach the Excel file to the chat from OneDrive or SharePoint.

  4. Describe the slides required and specify the worksheet or table, the audience, and the presentation length.

  5. Send the request for Copilot to draft slide with charts or tables built from the workbook data.

  6. Check figures and labels are correct before sharing the presentation.

What happens when spreadsheets become slides?

Copilot uses the data in an Excel workbook to draft a presentation around the key information. AI selects the slide layout and data visualizations to suit the data and presentation topic. Charts can highlight trends and show comparisons, while tables keep important figures together, and slide titles provide context for the data.

The presentation captures a snapshot of the workbook data at the time Copilot creates the slides. Changes to the original workbook do not automatically update the data in PowerPoint. Each chart, table, and text element remains editable, so the presentation can be updated directly in PowerPoint. Copilot can also use information from multiple worksheets to create the presentation.

PowerPoint presentation example with data from Excel

How to refine Excel data slides with AI

Continue improving the newly generated data slides with Copilot. Explore types of edits to help turn the initial draft into a presentation that communicates the workbook data clearly.

  • Enhance titles: ask Copilot to rewrite slide titles as short statements describing the data or key result.

  • Update charts and graphs: review generated charts, graphs, or tables and chat with Copilot to modify the design colors or data labels. Follow up with manual changes to charts using the Design tab in PowerPoint for the web.

  • Improve slide focus: enhance data understanding by splitting a long table across two slides, or working with AI to select rows the audience needs.

Tips for converting Excel into PowerPoint

A few practical checks can help when converting Excel data to PowerPoint with Copilot. Keep the workbook clean and current, check the file setup, and make sure the resulting slides are accurate and accessible.

  • File setup: remove password protection and save .xlsm files as .xlsx before converting to create a file that can be accessed by Copilot.

  • Clean data: remove blank rows and duplicate entries in Excel before converting data into slides.

  • Maintain the workbook: update figures in Excel so the workbook remains as an accurate data source. Copilot slides use the data from the time of the request, so ask Copilot to generate new data visualizations using the latest figures when needed.

  • Accessibility text: chat with Copilot to add alt text to each chart and table on the slides for readers who use a screen reader.

The next monthly report or sales review starts with a workbook already saved in OneDrive. Open Microsoft PowerPoint and add a spreadsheet to a Copilot chat to present the results as clear charts and tables.

Explore how to convert Word documents into PowerPoint to reuse existing workplace documents to build impressive presentations.

Frequently asked questions

Can Copilot in PowerPoint use more than one Excel file at a time?

Slides drafted with Copilot in PowerPoint come from one workbook per request. Combine the sheets into one workbook before starting, or add slides from each workbook in separate requests to the same presentation.

How to insert an Excel table or chart into PowerPoint?

There are two easy ways to insert an Excel table or chart into a slide. To manually link data, open the spreadsheet to copy the table or chart in Excel and paste it into PowerPoint using destination styles, source formatting, an embedded workbook, a linked workbook, a picture, or text only. Choose Keep Source Formatting to keep the Excel look. Find the full steps to insert and update Excel data (opens in a new tab).

To insert Excel data into a slide with Copilot, start a chat, attach the Excel file, and specify the name of the worksheet, table, or chart to add to the slide. Review the AI-generated data slide to ensure figures and labels are accurate.

Is it safe to use Copilot with confidential spreadsheets?

Copilot follows existing Microsoft 365 permissions, so it works only with files the signed-in person already has access to. It uses the security and compliance settings already in place for the organization. Read more about Copilot data, privacy, and security (opens in a new tab) for organizations.

Read more