How to Use Claude for Excel (Step-by-Step Tutorial), by Kevin Stratvert on YouTube. 9 min 23 s.
- Video length
- 9 min 23 s
- Time to do it
- 20 minutes
- Difficulty
- Easy
- Steps
- 8
What you need
Steps
Install Claude for Excel from the official Claude add-in source, then sign in with your Claude account when Excel prompts you.
Open your workbook and click the Claude button on the ribbon to launch the sidebar next to your sheet.
Select the messy data range and ask Claude to clean and standardize it, for example trim spaces, fix casing and remove duplicates.
Review the cleaned output before accepting it, and keep a copy of the original sheet in case you need to undo.
Select cells with broken formulas and ask Claude to find and fix the errors, then check each result against your expected values.
Ask Claude to generate a summary with charts or a pivot table from your cleaned range, and confirm the fields it uses.
Prompt Claude to analyze the data and list insights, such as trends or outliers, then verify the numbers yourself.
Explore the advanced options in the sidebar, like saving prompts or reusing a cleaning routine on other sheets.
Tips and common mistakes
Always keep a backup copy of the workbook before letting the AI change formulas or delete rows.
Check every formula Claude writes, since a wrong cell reference can quietly break your totals.
Give clear prompts that name the exact columns and the result you want, like remove duplicate emails in column B.
Save the workbook as a new version after each big change so you can roll back.
Questions
Do I need a paid Claude plan?
The add-in requires a Claude account, and some features may need a paid plan. Check the current plan details on the Claude site before installing.
Will Claude change my original data?
It can edit the sheet when you accept its suggestions. Work on a copy or a separate tab so your source data stays untouched.
Can Claude build pivot tables for me?
Yes, the tutorial shows Claude creating reports, charts and pivot tables from your data. Review the layout and field choices before relying on them.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
