Spreadsheet editor

Spreadsheets in the browser, without Excel

Open the editor with the button above. Type straight into the cells; a formula starts with an equals sign and is calculated the moment you confirm it. Download the finished workbook as XLSX for Excel, LibreOffice Calc and Google Sheets, or as CSV. You can also open a workbook you already have.

• Formulas: over fifty functions from SUM and AVERAGE to VLOOKUP, IF and the date functions. Arguments are separated with a semicolon.
• Formatting: bold, italic, underline, text and fill colour, alignment, text wrapping and number formats including currency, percentages and dates.
• Working with the table: sorting, filtering by text, inserting and deleting rows and columns, dragging column widths, double-clicking a column edge to fit the content, freezing panes.
• Multiple sheets: add, rename and move sheets. A formula can point at another sheet, for example =Data!A1*2.

Work in progress is kept in the browser's storage, so it survives closing the tab. Nothing is sent to a server.

Keyboard shortcuts

• Arrows move the selection, Shift extends it, Ctrl + arrow jumps to the edge
• Enter or F2 starts typing into a cell, Tab confirms and moves across, Delete clears the contents
• Ctrl + C, X, V copy and paste with formulas, Ctrl + Z undo
• Ctrl + B, I, U formatting, Ctrl + S downloads the XLSX

Frequently asked questions

Will the result open in Excel?

Yes. The downloaded file is an ordinary XLSX in the Office Open XML format, values, formulas, number formats and colours included.

Is any data sent to a server?

No. The calculations and the file assembly both run in your browser, so you can open a payroll or revenue table even on a machine nothing is allowed to leave.

Which functions does the editor know?

Maths (SUM, AVERAGE, MIN, MAX, ROUND, MOD, SQRT), logic (IF, AND, OR, IFERROR), text (LEFT, MID, LEN, SUBSTITUTE, TRIM), lookup (VLOOKUP, MATCH, INDEX), conditional totals (SUMIF, COUNTIF, AVERAGEIF) and dates (TODAY, DATE, YEAR, MONTH, DAY, DAYS). An unknown function shows up as the #NAME? error.

Can it handle a large table?

The grid renders only the visible cells, so thousands of rows scroll smoothly. Bear in mind the workbook lives in the browser's memory though: for hundreds of thousands of rows a database is the better tool.

What can the editor not do?

Charts, pivot tables, conditional formatting and macros. Use Excel or LibreOffice Calc for those; a file from our editor opens in them normally.

Which decimal separator is used?

The English convention: a decimal point and a comma between thousands. When typing we accept both, so 1234.5 and 1 234,5 end up as the same number.