Free Online Spreadsheet Editor

Open an Excel or CSV file, edit it in your browser and save it as XLSX or CSV. Type values, use formulas such as SUM and IF, insert rows and columns, sort data and work with several sheets. No Excel, no sign-up, and your file stays on your device.

  • Opens XLSX, ODS & CSV
  • Formulas included
  • No sign-up
A1

🔒 Your spreadsheet is opened and edited in your browser and saved only on this device. Start a cell with = to enter a formula, for example =SUM(A1:A10).

How to use the Spreadsheet Editor tool

  1. Open or start a spreadsheetClick “Open file” or drop an .xlsx, .ods or .csv file onto the grid, or start typing in an empty sheet.
  2. Edit the cellsClick a cell and type. Press Enter to move down and Tab to move right. Start with = to enter a formula.
  3. Organise the dataInsert or delete rows and columns, sort by a column and add more sheets.
  4. DownloadSave the result as an Excel (.xlsx) file with its formulas, or as a CSV file.

Features

  • Works with Excel filesOpens .xlsx and .ods workbooks with all their sheets and formulas, plus CSV and TSV files. Excel files keep their formatting, charts and images.
  • FormulasMore than 80 functions, including SUM, IF, VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIF, ROUND and text and date functions.
  • Rows, columns and sortingInsert and delete rows or columns, and sort any column A to Z or Z to A. Formulas are updated automatically.
  • Copy and pasteCopy cells to and from Excel, Google Sheets and other apps. Formulas pasted inside the editor adjust their references.
  • Undo and autosaveUndo mistakes with Ctrl + Z. Your work is kept in this browser so you can continue later.
  • PrivateFiles are opened and edited on your device. Nothing is uploaded.

Edit Excel files without Excel

Sometimes you only need to change a few numbers in a spreadsheet, add a row or check a total, and the computer in front of you has no Excel. This editor opens the file directly in the browser on any device. Make your changes and download the workbook as .xlsx again, with its sheets and formulas.

Using formulas

A formula starts with an equals sign. Refer to cells by their column letter and row number, and to ranges with a colon. Arguments are separated by commas or semicolons. Function names typed in Spanish, as in Spanish versions of Excel (SUMA, SI, BUSCARV…), are recognised too and saved with their English names, the format .xlsx files use.

FormulaWhat it does
=A1+B1Adds two cells. Use - * / and ^ for other calculations.
=SUM(B2:B20)Adds all numbers in a range.
=AVERAGE(B2:B20)The average of a range. MIN, MAX, MEDIAN and COUNT work the same way.
=IF(C2>=40,"Pass","Fail")Shows one value if a condition is true and another if it is false.
=ROUND(D2*18%,2)Calculates 18% of a value and rounds it to 2 decimal places.
=SUMIF(A2:A50,"Rent",B2:B50)Adds the amounts in column B where column A says “Rent”.
=COUNTIF(C2:C50,">100")Counts the cells greater than 100.
=A2&" "&B2Joins text from two cells.
=Sheet2!B5Reads a cell from another sheet.

Supported functions:

  • Math: SUM, PRODUCT, SUMPRODUCT, ROUND, ROUNDUP, ROUNDDOWN, TRUNC, INT, CEILING, FLOOR, ABS, SIGN, SQRT, POWER, EXP, LN, LOG, LOG10, MOD and PI.
  • Statistics: AVERAGE, MEDIAN, MIN, MAX, COUNT, COUNTA, COUNTBLANK, LARGE, SMALL, RANK, STDEV, STDEVP, VAR and VARP.
  • Conditions: IF, IFS, IFERROR, AND, OR, NOT, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIFS, MINIFS, ISBLANK, ISNUMBER and ISTEXT.
  • Lookup: VLOOKUP, HLOOKUP, XLOOKUP, INDEX and MATCH.
  • Text: CONCAT, LEN, UPPER, LOWER, PROPER, TRIM, LEFT, RIGHT, MID, FIND, SEARCH, SUBSTITUTE, REPT, EXACT, TEXT and VALUE.
  • Dates: TODAY, NOW, DATE, YEAR, MONTH, DAY, WEEKDAY, DAYS and EDATE.

Keyboard shortcuts

KeyAction
Arrow keysMove between cells. Hold Shift to select a range.
Enter / TabSave the cell and move down / right.
F2 or double-clickEdit the cell without replacing its contents.
DeleteClear the selected cells.
Ctrl + C / X / VCopy, cut and paste.
Ctrl + Z / Ctrl + YUndo and redo.

What is kept when you open an Excel file?

For Excel (.xlsx) files the editor writes your changes into the original workbook, so the rest of the file stays as it was. Fonts, bold and italic, text and fill colors, borders, number, currency, percent and date formats, column widths, row heights and merged cells are shown in the grid and kept in the downloaded file. Charts, images, conditional formatting, data validation, frozen panes and print settings are not shown in the grid, but they are still in the file you download.

A few things to know: you cannot change the formatting itself here, only the contents of the cells. Charts keep the cell range they were made with, so check them after you insert or delete rows. Sorting is switched off on sheets with merged cells. Formulas that use a function outside the supported list show the value saved in the file, or #NAME? after a change, and are saved unchanged so they still work in Excel. CSV and ODS files hold values and formulas only.

Limits

Up to 20,000 rows and 200 columns per sheet are opened. Larger files are cut at that size, and a message tells you when this happens. For very large CSV files, use our CSV to Excel converter instead.

Frequently asked questions

Is this spreadsheet editor free?
Yes. There is no sign-up, no limit on the number of files and no watermark.
Can I open and save Excel files?
Yes. Open .xlsx files, edit them and download .xlsx again. The file opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers.
Are formulas kept?
Yes. Formulas in the file are read, recalculated as you type and saved in the downloaded Excel file.
Can I open old .xls files?
Yes. Old .xls files are converted to .xlsx first and then opened in the editor. If the conversion is not available, save the file as .xlsx in Excel and open that.
Is cell formatting kept?
Yes, for Excel (.xlsx) files. Fonts, colors, borders, number formats, column widths, merged cells, charts and images are kept in the downloaded file.
Is my file uploaded?
No. The file is read and edited by your browser. The autosaved copy stays on this device.
How do I edit a CSV file?
Open the CSV file, change the cells and click “Download CSV”. The file is saved in UTF-8, so all languages are kept.