How to use the Spreadsheet Editor tool
- 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.
- Edit the cellsClick a cell and type. Press Enter to move down and Tab to move right. Start with = to enter a formula.
- Organise the dataInsert or delete rows and columns, sort by a column and add more sheets.
- 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.
| Formula | What it does |
|---|---|
| =A1+B1 | Adds 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&" "&B2 | Joins text from two cells. |
| =Sheet2!B5 | Reads 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
| Key | Action |
|---|---|
| Arrow keys | Move between cells. Hold Shift to select a range. |
| Enter / Tab | Save the cell and move down / right. |
| F2 or double-click | Edit the cell without replacing its contents. |
| Delete | Clear the selected cells. |
| Ctrl + C / X / V | Copy, cut and paste. |
| Ctrl + Z / Ctrl + Y | Undo 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.