Cross-App Excel to PowerPoint Workflow
Analyze Excel data and auto-generate PowerPoint slides using the Microsoft 365 connector in a single Cowork session.
Last tested Mar 28, 2026
Access Scope
Local Folders
Connected Services
Permitted Actions
Why these permissions? Read access to your Excel files is necessary to analyze the data. Write access to your PowerPoint location allows Cowork to create and save the new presentation. No delete or rename access needed — this is purely data analysis and creation.
Workflow Steps
Connect Microsoft 365 connector
Open Cowork Settings → Connectors and enable the Microsoft 365 connector. Authenticate with your Microsoft account and grant read access to Excel files and write access to create PowerPoint files.
Point Cowork at your Excel file
In your Cowork prompt, reference the Excel file you want to analyze. Provide the exact file path or location.
Ask Claude to analyze the data
Use a prompt that asks Claude to read the Excel file, examine all sheets, and identify the top 5 insights, trends, or key findings.
Generate the PowerPoint from findings
In the same session, ask Claude to create a PowerPoint presentation using those insights. One insight per slide, including charts or data visualizations.
Review and refine
Download the generated PowerPoint, review the slides for accuracy and formatting, and refine the content or structure as needed.
Cowork Prompt Pack
Cowork-readyAnalyze the data in [filename].xlsx. Read all sheets and identify the top 5 key insights, trends, or data points. For each insight, include: the finding, supporting numbers, and why it matters. Then create a PowerPoint presentation called [output].pptx with one slide per insight. Include the data or a relevant visualization on each slide. Format professionally with a title slide. Do not modify the original Excel file.
Verification Checklist
0 of 6 verified
Why this workflow matters
Data analysis and presentation creation are usually separate workflows. You spend hours analyzing spreadsheets, taking notes, and manually building PowerPoint slides. Each insight requires copying numbers, formatting tables, and designing visuals. With Cowork, the entire process—from data extraction to slide generation—happens in one session.
The Excel-to-PowerPoint workflow is perfect for:
- • Quarterly business reviews turning metrics into executive summaries
- • Sales teams generating weekly pipeline slides from data
- • Product managers creating feature performance decks
- • Data analysts presenting findings to stakeholders
- • Anyone who needs to turn spreadsheet data into compelling slides quickly
Before you connect: Prepare your data
Excel-to-PowerPoint works best when your data is well-organized. Messy spreadsheets with multiple sheets, merged cells, and inconsistent formatting often confuse automated analysis.
Best practices for data organization:
- • One metric per sheet: If you have KPIs, product metrics, and financial data, use separate sheets
- • Headers in the first row: Use clear column names (Date, Revenue, Growth %) instead of numbers
- • Consistent data types: Don't mix text and numbers in the same column
- • No merged cells: Merged cells confuse data analysis. Use consistent formatting instead
- • Date columns formatted consistently: Use YYYY-MM-DD format for clear sorting and comparison
Tips for best results
Name your sheets descriptively: Use "Q3-Revenue" and "Q3-Growth" instead of "Sheet1" and "Sheet2". Claude uses these names in the presentation.
Provide context in your prompt: Tell Claude who the audience is. A deck for executives needs different insights than one for the operations team.
Specify the story: Instead of "analyze this data," try "Show me the three biggest wins and the one area that needs attention." This shapes the insights Claude highlights.
Request a data dictionary if your columns are unclear: "Column D contains revenue in thousands USD" helps Claude correctly interpret and present the data.
Common questions
Can Cowork create charts and visualizations?
Yes. Ask Claude to include specific charts: "Add a bar chart comparing Q2 and Q3 revenue" or "Include a trend line for user growth." Claude will describe the chart format and you can add visual refinements after the initial generation.
What if my data has errors or inconsistencies?
Cowork will work with what it's given. Start with a "read-only" pass to have Claude flag data quality issues before generating slides. This lets you fix problems first.
Can I combine data from multiple Excel files?
Yes. Ask Claude to read multiple files, and specify how to combine the data. "Combine Q1, Q2, and Q3 data from separate files into one trend analysis" works well.
How long should each slide's analysis be?
Tell Claude upfront. "Three bullets per slide maximum" or "One key metric + one supporting chart per slide" gives you control over presentation density.
Safety and best practices
Before connecting and sharing
- • Grant access only to specific Excel files you intend to analyze, not entire drive access.
- • Review the generated PowerPoint before sharing with others. Check for accuracy, formatting, and sensitive data.
- • If the Excel file contains sensitive or confidential data, be careful with the presentation scope and distribution.
- • For large Excel files (1000+ rows), consider breaking the analysis into multiple smaller sessions to ensure accuracy.