Build formulas, charts, pivot tables, and scheduled spreadsheets — without writing a single line of code.
In this guide you'll learn how to use Claude Cowork mode to create Excel spreadsheets from scratch, populate them with formulas and charts, transform raw data into pivot-table-ready files, and even schedule automatic weekly reports — all by describing what you need in plain English.
Excel is one of the most powerful tools in any professional's toolkit, but it comes with a steep learning curve. Even experienced users spend hours building formulas, formatting tables, and debugging VLOOKUP errors. Claude Cowork mode removes that friction entirely.
With Cowork mode, you describe what your spreadsheet should do in plain English and Claude produces a properly formatted .xlsx file — complete with working formulas, named ranges, conditional formatting, and charts — in under a minute. You don't need to know any Excel syntax. You don't need to hire a data analyst. You just need to describe your goal clearly.
This guide covers six practical scenarios, from simple expense trackers to scheduled weekly reports. Each section includes a ready-to-use prompt you can copy and adapt for your own needs.
Before you can create Excel files, you need to have Claude Cowork mode installed and set up. If you haven't done that yet, start with our Getting Started guide — it takes less than 10 minutes. Once you're in Cowork mode:
The most common spreadsheet request. This prompt builds a clean, functional monthly expense tracker with dropdown categories and automatic totals.
Create an Excel file called "Expense-Tracker.xlsx" with a sheet called "March 2026". Columns: Date (dd/mm/yyyy), Category (dropdown: Food, Transport, Housing, Utilities, Entertainment, Other), Description, Amount (£). Add a SUM formula at the bottom of the Amount column for the monthly total. Format the Amount column as currency (GBP). Add conditional formatting to highlight any row where Amount exceeds £100 in light yellow. Freeze the header row.
What you get: A clean spreadsheet with a working data validation dropdown, currency formatting, auto-totalling, and colour-coded high-spend rows. Ready to use immediately.
This prompt is ideal for sales teams or small business owners who need a monthly summary with a visual trend chart.
Create an Excel file called "Sales-Report-Q1.xlsx". Sheet 1 (Data): Columns Month, Units Sold, Revenue (£), Target (£), % of Target. Populate with placeholder data for Jan, Feb, and March 2026. Add a formula for % of Target (Revenue/Target). Sheet 2 (Chart): Create a clustered bar chart comparing Revenue vs Target for each month. Add a chart title "Q1 Sales vs Target". Use a professional colour scheme — blue for Revenue, grey for Target.
If you have messy raw data — exported from a CRM, an accounting tool, or copied from a website — Claude can clean and restructure it. Upload your file first, then use this prompt.
I've uploaded a CSV file with raw sales data. Please: (1) Remove any duplicate rows. (2) Fix inconsistent date formats — standardise all dates to dd/mm/yyyy. (3) Remove rows where Amount is blank or zero. (4) Sort the data by Date ascending. (5) Add a "Month" column that extracts just the month name from the Date. (6) Create a summary tab that shows Total Revenue and Total Units per Month. Save the cleaned file as "Sales-Data-Clean.xlsx".
Pro tip: Always specify what "clean" means to you. Claude will follow your exact rules rather than making assumptions.
This builds a project management tracker — the kind that replaces a basic Trello board for people who prefer spreadsheets.
Create an Excel project tracker called "Project-Tracker.xlsx". Columns: Task Name, Assigned To, Start Date, Due Date, Status (dropdown: Not Started, In Progress, Complete, Blocked), Priority (dropdown: High, Medium, Low), Notes. Add conditional formatting: Complete rows → light green background. Blocked rows → light red background. High Priority rows → bold text. Due Date within the next 7 days → orange background. Freeze the top row and set column widths to fit content. Add 10 example tasks with realistic data.
For finance teams and business owners, this creates a comparative budget template that uses Excel functions to auto-populate actuals against budget figures.
Create an Excel file "Budget-vs-Actuals.xlsx" with two sheets. Sheet "Budget": Category, Budgeted Amount (£) for 12 months. Include 8 expense categories: Salaries, Marketing, Rent, Software, Travel, Equipment, Contractors, Miscellaneous. Sheet "Actuals": Same categories, with actual spend columns for each month. On a third sheet "Summary": Use SUMIF formulas to total Budget vs Actuals per category. Add a Variance column (Actuals minus Budget) and format negative variances (over-budget) in red. Add a simple bar chart comparing Budget vs Actuals totals by category.
The most powerful use case: setting up a recurring report that Claude runs automatically every week without any manual trigger. This uses the Scheduled Tasks feature in Cowork mode.
Every Monday at 8:00 AM: Read the file "weekly-data.csv" in my output folder. Create an Excel report called "Weekly-Report-[current date].xlsx" with: Sheet 1 — a clean, formatted version of the data. Sheet 2 — a summary showing: total rows, total amount, breakdown by category, and the top 5 items by amount. Sheet 3 — a line chart showing the trend. Save the file to my output folder.
How to set this up: In Cowork mode, open the Scheduled Tasks panel, paste the prompt above, and set the schedule to "Every Monday at 8:00 AM". From that point on, the report is created automatically — you just open your folder on Monday morning and it's there.
A few things that cause inconsistent Excel results from Claude, and how to fix them:
Not specifying the currency or number format. Always say "£ GBP" or "$ USD" and whether you want commas in large numbers (1,000 vs 1000).
Forgetting to say "save as .xlsx". Without this, Claude may output the data as a table in chat rather than as an actual file. Always end your Excel prompt with "Save as [filename].xlsx".
Overly complex formulas in one prompt. If you need something complex (like a multi-sheet VLOOKUP with dynamic named ranges), break it into two prompts: one for the data structure, one for the formulas and formatting.
Not selecting an output folder first. If you haven't selected a folder in the folder picker, Claude may not have a place to save the file. Always select your folder before starting.
Pick any of the prompts above, copy it into Claude Cowork mode, and adapt it for your specific data. Most of these take under 60 seconds to produce a finished .xlsx file. For more on spreadsheet features, visit the Features page or read the full Tips & Tricks guide.
Join the community for insights, updates and practical how-tos.