← All studios

Excel Studio | Free Online Excel Editor

Edit, analyze, chart, audit, and export XLS, XLSX, and CSV workbooks locally.

Sign in (free) to sync your workbooks between devices.

Ready1/5
B2fx
ABCDEFGHIJKLMNO
1
Item
Amount
Status
2
Example
1250
Ready
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
B · Sum 1,250 · Avg 1,250 · Count 12 rows · 3 columns · 14 empty · Processed locally
Enjoying Excel Studio?Your review and ideas shape what we build next.

Review Excel Studio

Please don't include file contents or passwords.

✅ Free · 🔒 Private · 🚫 No sign-up

Excel Studio: the complete guide

Cromagnon Excel Studio is a free online spreadsheet editor that opens, edits and saves real Excel workbooks (XLSX and XLS) in your browser. It has working formulas, number formats, fonts, fills, borders, merged cells, filters, freeze panes, charts, pivot tables, conditional formatting and data validation, across as many sheets as you need.

Your spreadsheet never leaves your device. Budgets, payroll, customer lists and grades stay private, and the studio autosaves as you work and warns you before anything could be lost. There is no sign-up, no row limit set by us and no paid plan.

Below you'll find every feature, step-by-step tutorials for common spreadsheet jobs, tips, keyboard shortcuts and answers to the questions people ask about editing Excel files online.

  • 100% free
  • Real XLSX in and out
  • Hundreds of formulas
  • Charts and pivot tables
  • No sign-up
  • Files stay on your device

Updated · checked against the studio as it works today

Features

Everything you can do in Excel Studio

Formulas

Hundreds of Excel formulas

SUM, AVERAGE, IF, VLOOKUP, XLOOKUP-style lookups, COUNTIF, dates, text and finance functions that recalculate as you type.

Function suggestions

Start typing = and the formula bar suggests functions and their arguments.

AutoSum

Total the numbers above in one click, or pick Average, Count, Min or Max.

Explain formula

See what a formula does, step by step, in plain words.

Formula builder (optional AI)

Describe what you want in any language and get a formula, using your own AI key.

Show formulas

Press Ctrl + ` to see the formulas instead of the results.

Named ranges

Give a range a name and use it in formulas.

Goal seek

Find the input value that makes a formula reach the result you want.

Format

Fonts, fills and borders

Bold, italic, underline, strikethrough, font and size, fill and text colour, all, outside or no borders.

Number formats

Currency, thousands separators, more or fewer decimals, percentages and dates.

Merge and centre

Merge cells for titles and headers.

Wrap text and alignment

Left, centre and right alignment, and wrapped text in tall cells.

Format painter

Copy the look of one cell to others.

Conditional formatting

Colour cells by rules (greater than, less than, text contains), with colour scales, data bars and icons, in a rule manager.

Clear formatting

Return selected cells to plain values.

Data tools

Sort and filter

Filter buttons on the header row, and sort any column.

Freeze panes

Keep the header row and first columns in view while you scroll.

Find and replace

Across the sheet, with match case.

Data validation

Dropdown lists, whole numbers, decimals, text length and dates, with your own error message.

Remove duplicates and blank rows

Clean a list in one click, and trim stray spaces.

Split and merge columns

Split a column on a separator, or join two columns.

Fill blanks and fill series

Fill empty cells down, or drag the fill handle for 1, 2, 3… and Mon, Tue…

Transpose

Turn rows into columns and back.

Data health

Count used rows and columns, empty cells, formulas and duplicate rows at a glance.

Analyse and present

Charts

Bar, line, pie and scatter charts placed on the sheet, with a title and legend; export them as PNG or SVG.

Pivot tables

Group by a column and summarise values on a new sheet.

Quick stats

Count, sum, average and median of the selected cells.

Compare sheets

See differences between two sheets.

Sheet splitter

Split one sheet into several by the values in a column.

Notes and links

Add notes to cells and turn cells into links.

Files and workbooks

Open XLSX, XLS and CSV

Formatting, formulas and sheets are kept.

Save XLSX, CSV, PDF and JSON

Download a real Excel file, a CSV for other apps, a PDF to share, or JSON for developers.

Multiple sheets

Add, rename, duplicate and reorder sheets.

Templates

Start from a monthly budget, expense tracker, grade book, attendance sheet, invoice or loan / EMI calculator.

Autosave

Your workbook is kept in your browser as you work.

Tutorials

Step-by-step how-to guides

How to open and edit an Excel file online

  1. Press Open and choose an XLSX or XLS file, or drag it onto the studio.
  2. Click a cell and type, or type = to start a formula.
  3. Press XLSX to download the edited workbook.

How to make a budget in Excel Studio

  1. Open Templates and pick Monthly budget, or start with a blank sheet.
  2. Type your categories in column A and amounts in column B.
  3. Select the cell under the amounts and press AutoSum.
  4. Add a pie chart to see where the money goes.

How to remove duplicates in Excel

  1. Select the data (or just click inside it).
  2. Open Quick actions → Remove duplicate rows.
  3. Check the result, then save.

💡 Tip: Run Clean whitespace first: "Ali" and "Ali " only count as the same once the extra space is gone.

How to make a dropdown list

  1. Select the cells that need a dropdown.
  2. Open Data validation and choose List (dropdown).
  3. Type the choices, separated by commas, and add an error message.
  4. Click a cell to pick from the list.

How to create a pivot table

  1. Click inside your data.
  2. Open Pivot Table Creator.
  3. Choose the column to group by and the values to summarise.
  4. Press Add pivot sheet to get the summary on a new sheet.

How to highlight cells with conditional formatting

  1. Select a column or range.
  2. Open Conditional formatting and choose a rule, such as Greater than 1000.
  3. Pick the fill and text colours and add the rule.
  4. Use the rule manager to change or reorder rules later.

How to freeze the top row

  1. Click the cell just below the rows and right of the columns you want to keep.
  2. Press Freeze panes.
  3. Scroll: the header stays in view.

How to convert Excel to CSV or PDF

  1. Open the workbook.
  2. Choose the sheet you want.
  3. Download it as CSV, or as PDF for sharing.

In depth

Which way should you do it?

How to look up a value: VLOOKUP, XLOOKUP or INDEX/MATCH

Finding a price by product code or a name by ID is the most common spreadsheet job. Excel Studio supports all three classic ways.

XLOOKUP (best choice today)
=XLOOKUP(code, codes, prices) looks left or right, gives a clear “not found” value and doesn't break when you insert columns.
VLOOKUP
=VLOOKUP(code, table, 3, FALSE) is the classic. Always use FALSE for an exact match, and keep the code in the first column of the table.
INDEX and MATCH
=INDEX(prices, MATCH(code, codes, 0)) works in every spreadsheet app, which helps when you share with people on older versions.

💡 Not sure how a lookup works? Select the cell and use Explain formula to see it step by step in plain words.

How to summarise a big table: three ways

Totals by month, sales by region, hours by person: pick the tool that fits how often the data changes.

SUMIFS and COUNTIFS
Formulas such as =SUMIFS(amount, region, "North") update the moment the data changes. Best for a fixed summary on a dashboard.
Pivot table
Group by a column and summarise the values on a new sheet in a few clicks. Best for exploring a table you've just received.
Quick stats
Select cells to see their count, sum, average and median at once, with no formula at all.

How to clean a messy spreadsheet

Lists exported from other systems often have duplicates, blank rows, stray spaces and numbers stored as text. Clean them in this order.

Check its health first
Data health counts used rows and columns, empty cells, formulas and duplicate rows, so you know what you're dealing with.
Remove duplicates and blank rows
One click each, plus trimming stray spaces at the start and end of cells.
Split or join columns
Split “First Last” into two columns on a space, or join two columns into one.
Fix numbers stored as text
Set the right number format so totals and sorting work.

💡 Leading zeros in IDs and phone numbers are kept as text on purpose, so 007 stays 007.

How to make a chart that people understand

The right chart type makes the point in a second; the wrong one hides it.

Bar chart
Comparing amounts between categories, such as sales by product.
Line chart
Showing change over time, such as monthly spending.
Pie chart
Parts of one whole, only with a few slices. Use a bar chart if there are more than five or six.
Scatter chart
Seeing whether two numbers move together, such as hours studied and exam scores.

💡 Charts can be saved as pictures (PNG or SVG) for slides and reports.

Modern formulas that save hours

Excel Studio calculates 439 of Excel's functions, including the newer ones that spill their results into several cells.

FILTER
=FILTER(table, status="Due") lists only the rows you want, and updates by itself.
UNIQUE and SORT
=SORT(UNIQUE(names)) gives a clean, sorted list with each name once.
TEXTSPLIT
Splits text on a separator into cells, for example an address into street, city and code.
LET
Names a part of a long formula so you calculate it once and read the formula more easily.

Sharing a spreadsheet with people on other apps

Pick the file type by what the other person will do with it.

XLSX
For people who will edit it in Excel, Google Sheets or LibreOffice. Formulas, formatting, filters and frozen rows come through.
PDF
For people who only need to read or print it.
CSV
For importing into other software. Only the values of one sheet are kept, no formatting.
JSON
For developers and web apps.

Tips and tricks

Get more out of Excel Studio

Ask in your own words

Not sure which formula you need? The formula builder turns a request like "total of column C where B is Paid" into a formula (with your own AI key).

Explain someone else's formula

Inherited a workbook full of formulas? Explain formula walks through what each one does.

Drag to fill

Drag the small square at a cell's corner to continue numbers, weekdays, months or a formula down a column.

Check before you send

Data health shows empty cells and duplicate rows before you share a file.

Keep headers visible

Freeze the top row on long lists so you always know which column is which.

Chart in two clicks

Pick two filled columns and a chart preview appears; insert it on the sheet when it looks right.

Work faster

Excel Studio keyboard shortcuts

Ctrl + Z / Ctrl + YUndo / redo
Ctrl + B / I / UBold / italic / underline
Ctrl + `Show formulas instead of results (and back)
Ctrl + click a linkOpen the link in a cell
Shift + clickSelect a block of cells
Enter / Shift + EnterConfirm the cell and move down / up
Alt + EnterNew line inside a cell
Tab (while typing a formula)Accept the suggested function

Shortcuts don't fire while you are typing in a text box, except Ctrl + S. On a Mac, use ⌘ instead of Ctrl.

Formats

What Excel Studio opens and saves

Opens

  • Excel (XLSX)
  • Older Excel (XLS)
  • CSV

Saves

  • Excel (XLSX)
  • CSV
  • PDF
  • JSON
  • Chart pictures (PNG, SVG)

Privacy

Private by design: your files stay on your device

Spreadsheets are often the most private files people have: salaries, bank exports, customer lists, grades. Excel Studio opens and saves them inside your browser. The workbook is never uploaded to Cromagnon.

Autosave keeps your work in your own browser storage so you can come back to it; clear it any time.

The optional AI formula builder and AI formula explanations are the only features that send anything: your request, the column headers and the first three rows, so the formula fits your sheet. They go only to the AI provider whose key you added yourself, and only when you press the button. Everything else, including Explain formula step by step, works without AI.

Comparison

Excel Studio compared with typical online tools

Cromagnon Excel StudioTypical online spreadsheets
Price✅ Free, every featureFree with limits, or a subscription
Account✅ Not neededRequired
Where the file is processed✅ On your deviceOn their servers
Opens and saves real XLSX✅ YesUsually, after import
Charts, pivot tables, conditional formatting✅ YesYes, sometimes on paid plans
Formula explanations✅ YesRare
Ads✅ NoneSometimes

Made for everyone

Who uses Excel Studio?

Office workers

Reports, trackers and lists, opened and saved as real Excel files.

Small businesses

Budgets, stock lists, price lists and simple invoices.

Students

Lab data, charts and statistics for assignments.

Teachers

Grade books with formulas and conditional colours.

Freelancers

Time sheets and income tracking without a paid office suite.

Anyone on a shared or school computer

Edit a spreadsheet without installing anything.

Troubleshooting

Common problems and how to fix them

A formula shows an error

Use Explain formula to see which part fails. Check for text in number cells and for references to empty or deleted cells.

Numbers are treated as text

Clean whitespace, then reapply a number format. Numbers pasted with spaces or symbols often arrive as text.

My file has macros

Macros (VBA) are not run in the browser. The data and formulas open normally.

The file is very large

Everything runs on your device, so very big workbooks depend on your computer's memory. For huge plain data files, CSV Studio is faster.

I need the old version back

Undo with Ctrl + Z, or reopen your original file; Excel Studio never changes the file on your disk until you download a new copy.

#SPILL! appears

A formula like FILTER or UNIQUE needs empty cells below or beside it for its results. Clear the cells in the way.

VLOOKUP returns #N/A

Check that the code really exists in the first column, that you used FALSE for an exact match, and that there are no extra spaces (trim them with the clean-up tools).

Dates show as numbers

Spreadsheets store dates as numbers. Apply a date format to the cells to see them as dates.

Totals ignore some numbers

Those cells probably hold numbers as text. Change their number format, or re-type a value to check.

Glossary

The words, explained simply

Cell reference
The address of a cell, such as B3. $B$3 is an absolute reference that doesn't change when you copy the formula.
Range
A block of cells, such as A2:A100.
Named range
A range with a name (such as “Prices”) that you can use in formulas instead of its address.
Spill
When one formula fills several cells with its results, as FILTER and UNIQUE do.
Pivot table
A summary that groups rows by a column and totals, counts or averages the values.
Conditional formatting
Colouring cells automatically by a rule, such as red for amounts below zero.
Data validation
Rules for what can be typed in a cell, such as a dropdown list or only dates.
Freeze panes
Keeping the top rows or first columns visible while you scroll.
Fill handle
The small square at a cell's corner; drag it to copy a formula or continue a series such as Mon, Tue, Wed.
Goal seek
Working backwards: finding the input that makes a formula give the result you want.
Circular reference
A formula that refers to its own cell, directly or through others. Excel Studio catches it and warns you.
Macro
A small program saved inside a spreadsheet. Excel Studio keeps your data but does not run macros, for your safety.

FAQ

Frequently asked questions

Is Excel Studio really free?

Yes. Every feature is free, with no sign-up and no paid plan.

Can I open and save XLSX files?

Yes. Open XLSX or XLS and save a real XLSX that opens in Microsoft Excel, Google Sheets and LibreOffice.

Are my spreadsheets uploaded?

No. Workbooks are opened, edited and saved in your browser on your device.

Do formulas work?

Yes. Hundreds of Excel functions recalculate as you type, and you can see formulas with Ctrl + `.

Can I make charts and pivot tables?

Yes. Insert bar, line, pie and scatter charts, and build pivot tables on a new sheet.

Does it support conditional formatting and dropdowns?

Yes. Conditional formatting rules, colour scales, data bars and icons, and data-validation dropdown lists are all included.

Do macros run?

No. VBA macros are not run in the browser, but the rest of the workbook opens normally.

Can I convert Excel to PDF or CSV?

Yes. Download any sheet as CSV or PDF, and the workbook as JSON.

Does it autosave?

Yes. Your workbook is kept in your browser as you work.

Is there a row limit?

We don't set one. Very large files depend on your device's memory; CSV Studio handles huge plain data best.

Does it work on a phone or tablet?

Yes, in any modern browser. A bigger screen helps for large sheets.

What are the keyboard shortcuts?

Ctrl + Z undo, Ctrl + Y redo, Ctrl + B/I/U for bold, italic and underline, and Ctrl + ` to show formulas. On a Mac use ⌘.

What is the best free alternative to Microsoft Excel?

One that opens and saves real XLSX files, calculates Excel formulas correctly and needs no account. Excel Studio calculates 439 of Excel's functions, keeps formatting, and does charts and pivot tables, free in your browser.

Does Excel Studio support XLOOKUP, FILTER and UNIQUE?

Yes, together with SORT, SEQUENCE, TEXTSPLIT, LET, LAMBDA and other modern functions, including results that spill into several cells.

Can I copy and paste between Excel Studio and Excel or Google Sheets?

Yes. Copy cells in one and paste in the other; formulas move their references as they would in Excel.

How many rows can Excel Studio handle?

Large sheets stay smooth: the grid only draws the rows on screen, and sheets of 150,000 rows were tested.

Can I make a budget or expense tracker?

Yes. Start from one of the templates, such as the monthly budget or expense tracker, with formulas already in place.

Can it explain a formula I don't understand?

Yes. Select the cell and use Explain formula to see what it does step by step, and error messages tell you in plain words what went wrong.

Ready to try Excel Studio?

It's free, private and needs no sign-up.

⬆ Back to Excel Studio