# Excel Studio | Free Online Excel Editor

> Excel Studio by Cromagnon: edit XLSX files online with real formulas, charts, pivot tables and conditional formatting. Free, private, no upload, no sign-up.

Canonical: https://cromagnon.app/studios/excel-studio
Last updated: 2026-10-25

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

## Features

### 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.

## File formats

- Opens: Excel (XLSX), Older Excel (XLS), CSV
- Saves: Excel (XLSX), CSV, PDF, JSON, Chart pictures (PNG, SVG)

## How to

### 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.

## 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

- **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.

## Keyboard shortcuts

| Keys | Action |
| --- | --- |
| Ctrl + Z / Ctrl + Y | Undo / redo |
| Ctrl + B / I / U | Bold / italic / underline |
| Ctrl + ` | Show formulas instead of results (and back) |
| Ctrl + click a link | Open the link in a cell |
| Shift + click | Select a block of cells |
| Enter / Shift + Enter | Confirm the cell and move down / up |
| Alt + Enter | New line inside a cell |
| Tab (while typing a formula) | Accept the suggested function |

## Privacy

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

|   | Cromagnon Excel Studio | Typical online spreadsheets |
| --- | --- | --- |
| Price | Free, every feature | Free with limits, or a subscription |
| Account | Not needed | Required |
| Where the file is processed | On your device | On their servers |
| Opens and saves real XLSX | Yes | Usually, after import |
| Charts, pivot tables, conditional formatting | Yes | Yes, sometimes on paid plans |
| Formula explanations | Yes | Rare |
| Ads | None | Sometimes |

## Who it's for

- **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.

## Common problems

- **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

- **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.

## 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.

## Related

- [CSV Studio](https://cromagnon.app/studios/csv-studio)
- [Math Studio](https://cromagnon.app/studios/math-studio)
- [Invoice Studio](https://cromagnon.app/studios/invoice-studio)
- [PDF Studio](https://cromagnon.app/studios/pdf-studio)
- [Excel merger](https://cromagnon.app/tools/excel-merger)
- [Excel to CSV](https://cromagnon.app/tools/excel-to-csv)
- [Excel formula viewer](https://cromagnon.app/tools/excel-formula-viewer)
- [Duplicate remover](https://cromagnon.app/tools/duplicate-remover)
