Excel Studio Live Updated October 2026

Excel AI: create, clean and analyze spreadsheets with AI

Excel Studio is MultipleChat's AI for Excel: generate a workbook from one sentence, upload an XLSX, CSV or TSV file to profile and clean it, and get any Excel formula written and explained.

One Excel AI tool for the whole job: templates, plain-English refinement, 27 instant tools and a Formula Assistant, with ChatGPT, Claude, Gemini or Grok doing the AI work.

13 templates 27 instant tools Formula Assistant Profile on upload XLSX, CSV, TSV export Refine in plain English
data-studio
Gemini
Generate
Tools
Formula

account-statement-2026-09.csv

57.9 KB · 321 rows · 11 columns

321

Rows

11

Cols

9

Dupes

1,461

Missing

Remove duplicates
Fix date formats
Running total column
Pivot / summarize
✓ 9 duplicates removed

Instant tools

No AI call, no AI credits

Profiled on upload

Rows, duplicates, missing values
Upload XLSX, CSV or TSV
Export XLSX · CSV · TSV
Instant tools use no AI credits
Live preview before download
Hosted on Azure in Switzerland
Capability Matrix

What this Excel AI tool actually does.

Chat can make a spreadsheet. Excel Studio is for working with one: generating it properly, understanding a file you already have, and getting the formulas right.

Start creating spreadsheets

Generate

13 workbook templates

Describe what you need, pick a template, a style preset and a row count. The AI builds formatted columns, formulas, summary rows and charts where appropriate.

Refine

Plain-English changes

"Add a column that calculates the 30-day average." The AI modifies only the parts you asked about and rebuilds the file.

Profile

Know your file on upload

Upload an .xlsx, .csv or .tsv file (up to 10 MB) to see row and column counts, duplicate rows, missing values and per-column min, max and mean. Free after sign-in.

Instant tools

27 tools, no AI credits

Clean, add formula columns, format, reshape and validate your data with one click. No AI call is needed, and the tools are free after sign-in.

Formula Assistant

Any Excel formula, explained

The exact formula, a step-by-step explanation, edge-case warnings and alternatives. Paste your headers for real ranges.

Export

XLSX, CSV or TSV

Check the live HTML preview, then download the format you need.

How it works

Describe it. Preview it. Download it.

Start from a sentence or from a file you already have. Either way you preview the result before anything is downloaded.

1

Generate or upload

Describe a new workbook and pick a template, style preset and row count. Or upload an existing .xlsx, .csv or .tsv file and Excel Studio profiles it automatically. Save older .xls files as .xlsx first.

13 templates, including Custom / Freeform
Row count, column count and duplicates
Missing values and per-column min, max, mean
2

Refine or apply tools

For a generated workbook, describe changes in the Refine panel and the AI rebuilds only those parts. For an uploaded file, click instant tools to clean, format, add formula columns or reshape it.

"Add a column that calculates the 30-day average"
"Change the header colours to dark blue"
"Add a pie chart to the Summary sheet"
3

Preview, refine, download

A live HTML preview shows the spreadsheet before you download it. Keep refining as many times as you need, then export the file.

Preview before downloading
Iterate with follow-up prompts
Export as .xlsx, .csv or .tsv
AI for Excel

What you can ask Excel AI to do.

Six everyday jobs, with the kind of instruction that gets them done. Examples are illustrative.

Build a workbook from one sentence

Describe the business, period and columns. The AI plans the sheets and builds formatted columns, formulas, summary rows and charts where they help.

"Monthly budget for a 50-person startup with income and expense categories, subtotals and variance against plan."

Add calculated columns

Ask for derived columns in plain language: averages, growth, margins or weighted scores. The Refine panel changes only what you asked about.

"Add a column that calculates the 30-day average, and a Profit Margin % column next to Revenue."

Charts and summary sheets

Add a chart or a summary sheet to a generated workbook without rebuilding everything else.

"Add a pie chart to the Summary sheet showing expenses by category."

Restyle and reformat

Change colours, headers and layout until the file is ready to send to a client or your accountant.

"Change the header colours to dark blue and freeze the first row."

Write and explain formulas

The Formula Assistant returns the exact formula with an explanation, edge-case warnings and alternatives.

"Sum column D only where column C says Approved and column E is greater than 1000."

Clean an uploaded file

Profile an .xlsx or .csv on upload, then fix what it finds with instant tools: duplicates, dates, blanks, split or merged columns.

Remove duplicates → Fix dates → Fill blanks → Download .xlsx

Need a quick file? Ask in chat.

"Make me a Q3 budget spreadsheet" works in any MultipleChat conversation and returns a download link. Open Excel Studio when you want templates, style presets, side-by-side previews and several rounds of revisions.

Questions about your data? Use an AI sandbox.

In chat, ChatGPT, Claude or MultipleChat sandboxes run code on an uploaded spreadsheet to calculate totals, find trends and draw charts. ChatGPT and Claude sandboxes need an eligible paid plan.

AI data analysis guide →
Instant Tools 27 tools

Precision operations. Immediate results.

Some spreadsheet jobs do not need AI at all. Upload a file on the Tools tab and click a card: deduplication, date fixes, running totals, table formatting and pivots run instantly, without an AI call and without using AI credits.

27

instant tools

0

AI credits used

5

tool groups

1

click per tool

Open Excel Studio

Cleaning

Trim Whitespace

Strip leading/trailing spaces from all text cells

Remove Duplicates

Delete duplicate rows with smart column selection

Fix Case

UPPERCASE / lowercase / Title Case conversion

Remove Empty

Drop rows or columns that are entirely blank

Fill Blanks

Forward-fill or back-fill empty cells

Fix Dates

Standardize date columns to a consistent format

Split Column

Split by comma, semicolon, pipe, or custom delimiter

Merge Columns

Join multiple columns into one with a separator

Formulas

Summary Row

Add SUM, AVERAGE, COUNT at the bottom

Running Total

Cumulative sum column for any numeric field

% of Total

Each row as a percentage of the column total

Growth %

Period-over-period percentage change

Rank

Rank rows by value, highest or lowest first

Formatting

Auto Table

Convert to formatted Excel Table with filters

Color Scale

Heat map conditional formatting (red–yellow–green)

Data Bars

In-cell horizontal bar charts for numeric columns

Threshold Highlight

Highlight cells above, below, or between selected values

Fix Numbers

Auto-apply currency, percentage, date formats

Auto-Width

Fit column widths to content automatically

Freeze Header Row

Keep the header visible while scrolling

Reshape

Pivot Summary

Group rows and aggregate values

Transpose

Flip rows and columns in one click

Split by Category

One sheet per unique value in a column

Validation & Protection

Dropdown Validation

Add controlled dropdown lists to selected cells

Range Validation

Restrict numeric input to safe minimum and maximum values

Protect Formula Cells

Lock formulas while keeping editable areas open

Named Ranges

Create named ranges for cleaner formulas and templates

Generate

Build complete spreadsheets from a single sentence.

Describe the spreadsheet you need and pick one of 13 templates. The AI builds a realistic workbook with formulas, formatted columns, summary rows and charts where appropriate, all in one step.

💰

Budget Tracker

Monthly income/expense categories with variance analysis

📊

Profit & Loss

Revenue, COGS, expenses and net income with monthly columns

🌊

Cash Flow Forecast

Operating, investing, and financing with runway calculation

🏦

Loan Amortization

Payment schedule with principal, interest, and balance

🧾

Invoice

Line items with quantity, unit price, tax, and total

📈

Sales Pipeline

Deals with stages, probability, and weighted forecast

👥

Employee Roster

Staff directory with departments, salary, and tenure

📦

Inventory Tracker

SKUs with reorder points, unit cost, and total value

📅

Project Tracker

Tasks, dates, dependencies, and status tracking

🎯

OKR / KPI Scorecard

Objectives, key results, targets, and progress

⚖️

Comparison Matrix

Options vs weighted criteria with scores and ranking

🧮

Expense Report

Dated expenses, categories, vendors and totals by category

🔧

Custom / Freeform

AI decides the best structure based on your description

What spreadsheet do you need?

e.g. Monthly budget for a 50-person startup, Sales pipeline tracker for a SaaS team...

Live preview before you download
Formula Assistant

Stop Googling. Describe what you need.

Tell the Formula Assistant what you are trying to calculate, optionally paste your column headers, and get the exact formula ready to paste, a step-by-step explanation, edge-case warnings and alternative formulas. See formula examples

→

"Weighted average of column B using weights in column C"

✓
=SUMPRODUCT(B2:B100,C2:C100)/SUM(C2:C100)

+ explanation, edge cases and alternatives

Any complexity

from IF to LAMBDA

Step-by-step

explanation included

Alternatives

multiple approaches

Describe the formula you need

Column headers & sample data (optional — improves accuracy)

AI Models

Four AI models. Choose per task.

Pick the model per task. If one model's workbook or formula is not quite right, try the same request with another.

ChatGPT

OpenAI

A dependable choice for structured workbooks and precise, step-by-step instructions.

Claude

Anthropic

Good at long, nuanced instructions and multi-condition formulas.

Gemini

Google

Fast, with strong multilingual output for translated headers and labels.

Grok

xAI

A useful second opinion when you want a different structure or approach.

Excel AI vs AI in Excel

Which AI for Excel fits the job?

Excel Studio runs in your browser and hands you a finished .xlsx file. If you want AI inside the Excel window itself, Microsoft offers Copilot in Excel for Microsoft 365. Many people use both.

MultipleChat chatExcel StudioCopilot in Excel
Where it runsAny MultipleChat conversationA dedicated web workspaceInside Excel for Microsoft 365
Best forOne quick file, or questions about data in an AI sandboxNew workbooks from templates, file profiling and cleanup, formulasWorking in a workbook you already have open
AI modelsChatGPT, Claude, Gemini, Grok and PerplexityChatGPT, Claude, Gemini or GrokMicrosoft Copilot
OutputDownload cards in the chatXLSX, CSV or TSV after a live previewChanges in your open workbook

Copilot in Excel details are from Microsoft's support documentation (October 2026) and may differ by license.

Plan availability

Profiling and the 27 instant tools are free after sign-in. AI features (workbook generation, AI processing, refinement and the Formula Assistant) are included with Pro ($20/month) and are not available during the 7-day trial. Smart ($90/month) includes more Studio usage, and team plans start at $25 per seat per month. Studio usage is tracked separately from normal chat usage, and Studios need a MultipleChat account. See plans

MultipleChat Studios

One workflow. Three studios.

Excel Studio is strongest when it becomes the start of a real business deliverable: clean the numbers, write the document, then present the result.

Why this matters: many users do not want another chatbot tab. They want a finished file: a cleaned spreadsheet, a written business document, or a deck they can send to a client.

Security & Privacy

Know where your spreadsheet goes.

Profiling and instant tools work without calling an AI model. When you ask the AI to generate or refine a workbook, your request goes to the model you selected.

⚡

No AI for instant tools

Cleaning, formatting and reshaping run without an AI call

☁️

Hosted in Switzerland

Application and file storage on Microsoft Azure, Switzerland North and West

🔒

Encrypted at rest

Stored data is encrypted with AES-256 and access is logged

🛡️

TLS 1.3 to AI providers

Requests reach model providers over encrypted commercial API connections

Details in the privacy policy.

Excel AI FAQ

Questions before you start.

The practical details people ask about Excel Studio.

What is Excel AI?+

Excel AI means using an AI model to build, clean or explain spreadsheets. In MultipleChat, Excel Studio is the Excel AI workspace: it generates workbooks from a plain-language description, profiles files you upload, runs 27 instant tools and includes a Formula Assistant that writes and explains Excel formulas.

Is Excel Studio AI in Excel, or a separate tool?+

It is a separate web workspace. You create or clean the spreadsheet in Excel Studio, check the live preview, and download an .xlsx file that opens in Excel. If you want an assistant inside the Excel window, Microsoft offers Copilot in Excel for Microsoft 365.

What can this AI for Excel create?+

Workbooks from 13 templates: Budget Tracker, Profit & Loss Statement, Cash Flow Forecast, Loan Amortization, Invoice, Sales Pipeline / CRM, Employee Roster, Inventory Tracker, Project Tracker, OKR / KPI Scorecard, Comparison Matrix, Expense Report and Custom / Freeform. Each comes with formatted columns, formulas, summary rows and charts where appropriate.

Can I upload my own spreadsheet?+

Yes. Upload an .xlsx, .csv or .tsv file (save older .xls files as .xlsx first) and Excel Studio profiles it automatically: row count, column count, duplicate rows, missing values and per-column min, max and mean. To change the file, use the 27 instant tools for cleaning, formulas, formatting, reshaping and validation. Instant tools handle files up to 10 MB and 20,000 cells.

Do the instant tools use AI credits?+

No. The 27 instant tools, such as Remove Duplicates, Fix Dates, Running Total, Auto-format as Table and Pivot / Summarize, run without an AI call, so they do not use AI credits. They are free after sign-in.

How does the Formula Assistant work?+

Describe what you want to calculate in plain English and optionally paste your column headers. You get the formula ready to paste, a step-by-step explanation, edge-case warnings and alternative formulas.

Which file formats can I download?+

Excel (.xlsx), CSV or TSV. A live HTML preview of the spreadsheet is shown before you download.

Which plan includes Excel Studio?+

Profiling and the instant tools are free after sign-in. AI features (workbook generation, AI processing, refinement and the Formula Assistant) need Pro ($20/month) or Smart ($90/month, more Studio usage) and are not available during the 7-day trial. Team plans start at $25 per seat per month. Studio usage is separate from normal chat usage.

Excel Studio

Make spreadsheets with AI, not spreadsheet pain.

Start from a template or upload a file. Generate the workbook, clean the data, get the formula, and download business-ready Excel output.