Creating Excel spreadsheets (xlsx)
Claude can generate Excel spreadsheets (.xlsx) directly from natural language prompts on claude.ai. When you describe what you need — a budget tracker, a sales model, a data summary — Claude uses its code execution environment to programmatically build a real .xlsx file you can download and open immediately in Microsoft Excel or compatible software. The generated files contain working formulas, multiple sheets, charts, conditional formatting, and proper number formatting, not just static data tables.
This capability works through Claude's built-in code execution sandbox, where it uses Python libraries (such as openpyxl and xlsxwriter) to construct the workbook. Because the file is generated programmatically, formulas are live and editable — change an input cell and dependent calculations update normally in Excel. Claude can also combine data from uploaded files (CSVs, PDFs, text files) into a single structured workbook.
A separate but related product, the Claude for Excel add-in, embeds Claude directly as a sidebar inside Microsoft Excel for users who want AI assistance within their existing spreadsheet workflow rather than generating new files from scratch. The add-in is in beta and available to Max, Team, and Enterprise plan users.
When you’d use it
- ◆Personal budget tracker — An individual wants a monthly budget spreadsheet with income rows, expense categories, and an automatic savings calculation without building it manually.
- ◆Sales performance report — A sales manager needs a Q1 report with month-over-month growth percentages, running totals, and a trend chart, generated quickly from raw figures they paste into the prompt.
- ◆Multi-scenario financial projection — A financial analyst needs a 12-month revenue model with bull, base, and bear scenarios, color-coded inputs, and a dashboard summary — built to be fully editable so assumptions can be adjusted later.
- ◆Data extraction from PDFs into a structured workbook — An operations team receives multiple PDF invoices and wants all customer names, order numbers, and subtotals compiled into a single Excel file with a sales-tax formula column added automatically.
- ◆Rental property comparison model — A property owner wants to compare short-term versus long-term rental income using current market data, with Claude researching rates and building the comparison directly into a multi-sheet model.
What changed recently
- ◆2025-10-27 — Claude for Excel add-in released as a beta research preview for Max, Team, and Enterprise users, enabling Claude to read, analyze, modify, and create workbooks directly inside Microsoft Excel via a sidebar.
- ◆2025-11-19 — File creation (including .xlsx, .pptx, .docx, and PDF) launched as a preview feature for Max, Team, and Enterprise plan users, with Pro access to follow.
- ◆2026-01 — Claude for Excel expanded to support additional Excel-native operations: sorting and filtering data, editing pivot tables and charts, applying conditional formatting rules, setting data validation, and applying finance-specific print formatting.
- ◆2026-04-22 — Support articles for file creation and Claude for Excel updated on support.claude.com, reflecting current feature state including the 30MB file size limit, trusted-source security guidance, and Google Drive save integration.
This is the short version
The full chapter has three worked examples, the common pitfalls, and the workflow that makes it pay — plus the other 84 features, kept current.
Get Claude Master — $97 →