Excel to PowerPoint: Automate Slides

Key insights

• Claude AI add-in: The video demo shows how to generate PowerPoint slides automatically from Excel by installing the Claude AI add-in in both Excel and PowerPoint.
  It walks through connecting the two apps and running a simple conversion from a formatted sheet to a slide.
• Setup: Install the add-in in Excel and PowerPoint and authorize the connection, then keep the Excel workbook and the PowerPoint file open at the same time.
  Opening both files is required for the add-in to read data and create slides.
• Data-to-slide workflow: Format your Excel table (clear headers, consistent ranges) and use natural-language prompts to ask the add-in to create charts, layouts, or entire slides.
  The demo also shows using prompts inside PowerPoint to run quick analysis without switching back to Excel.
• Multi-workbook support: The tool can pull from multiple Excel files to build slides (the creator tested separate files for different years).
  It can also update existing presentation slides with new data, but you must manage which workbook supplies each slide.
• Microsoft Copilot: For Microsoft 365 users, Copilot offers native Excel-to-PowerPoint automation and tighter Office integration, while Power Automate can schedule or scale flows for regular exports.
  Choose the native option for enterprise security and automated workflows when available.
• Limitations: Key constraints include the need to keep both files open and lack of true automatic refresh of data; the add-in won’t update slides unless you trigger it or reopen files.
  Best practices: test on a copy, standardize templates, and save workbooks before running slide generation.

Overview of the Video

In a recent YouTube tutorial, Kenji Farré (Kenji Explains) [MVP] demonstrates how to turn Excel data into PowerPoint slides automatically using the Claude AI add-in. He walks viewers through setup, shows live examples, and runs several practical tests to reveal strengths and limitations. Consequently, the video serves as a hands-on look at an AI-assisted workflow that bridges spreadsheets and slide decks.

Setup and First Steps

Kenji begins by installing the add-in in both Excel and PowerPoint and enabling the connection between them, which is the foundational step. He emphasizes that both files must be open at the same time for the integration to work, and that connection settings must be correct before any automation can run. Therefore, initial setup is simple but sensitive to file state and permissions.

Demonstrations and Practical Tests

Following setup, Kenji formats a sample sheet in Excel and converts it into a single PowerPoint slide, showing how the add-in interprets tables and numeric ranges. Next, he tries to run data analysis directly inside PowerPoint using Claude AI, rather than relying on pre-processed results from Excel, which illustrates the tool’s flexibility. Then, he expands the test by generating slides from multiple workbooks — three separate files for three years — to show how the add-in handles several data sources in one session.

Updating Existing Presentations and Key Limitations

Kenji also tests updating an existing presentation with fresh Excel data and notes practical constraints, such as the need to have source files open and the lack of automatic refresh. As a result, users must run manual steps to bring new data into slides, which adds maintenance overhead for recurring reports. In addition, the video highlights that complex formatting and custom templates may require extra cleanup after generation.

Tradeoffs, Challenges, and Best Practices

The workflow offers clear gains in speed and consistency, yet it comes with tradeoffs between convenience and control. While AI-driven generation removes repetitive chart-making, it may not always choose the exact layout or narrative a user expects, so manual edits remain important for final polish. Furthermore, teams must weigh data security and governance, because add-ins that move data between apps introduce policy and privacy questions that IT groups should review.

Implications for Teams and Recommendations

For teams that produce regular reports, this approach can save time and reduce errors when used with consistent data layouts and clear naming conventions. Still, Kenji’s tests suggest best practices: keep both files open during generation, standardize column headers, and test templates on sample data before bulk runs. Additionally, organizations should plan for version control and implement review steps so AI-produced slides align with brand and compliance standards.

Final Assessment

Overall, the video by Kenji Farré (Kenji Explains) [MVP] presents a practical, lower-friction way to move from spreadsheet analysis to presentation-ready slides. Moreover, the demonstrations help viewers understand where automation helps and where human judgment is still required, especially around formatting, narrative flow, and data governance. In short, this method is promising for Microsoft-centric teams, but it works best when paired with clear processes and oversight.

Keywords

Excel to PowerPoint automation, convert Excel data to PowerPoint slides, automate slides from Excel, Excel data export to PowerPoint, PowerPoint from Excel VBA, Office 365 automate PowerPoint from Excel, create PowerPoint slides from Excel, Excel chart to PowerPoint automatically