ExcelTool.io

Online Excel Editor

Open an .xlsx, .xls or .csv file and edit it right here — cells, formulas, formatting, rows and columns — then download the result. No account, no upload: your file never leaves your device.

Drop your file here or click to upload

Supports .xlsx, .xls, .xlsm, .xlsb, .csv · up to 50MB · or paste a file from your clipboard

or download sample-budget.xlsx
or download hidden-frozen.xlsx

You can also paste a table straight in from Excel or Google Sheets once a sheet is open. Only need to read a file? Open it in the read-only Excel Viewer.

Edit Excel files online without uploading them

Most tools that promise to edit Excel online do the same thing: you hand over your file, a server opens it, and you hope the copy is deleted later. That is a poor trade for a sales report, a payroll sheet or anything with customer data in it — and on plenty of corporate networks those sites are blocked outright.

This editor works differently. The page loads a spreadsheet engine into your browser, and your workbook is opened by that engine on your own machine. There is no upload step to wait through, no size tier to hit, and no account to create. If you want to prove it: open a file, switch off your wi-fi, and carry on editing. Everything keeps working, because nothing was going anywhere.

What you can do here

  • Edit like a spreadsheet, not a form. Arrow keys, Tab and Enter move the cursor. Ctrl+arrow jumps to the edge of your data. Shift extends the selection. F2 or a double-click opens a cell. Ctrl+Z undoes.
  • Write formulas that calculate. 169 functions, live recalculation in dependency order, and circular references flagged instead of silently wrong. Selecting a formula outlines the ranges it reads.
  • Use dynamic arrays. UNIQUE, SORT, FILTER, SEQUENCE, TEXTSPLIT and the rest spill their results across the cells below and to the right, and resize as your data changes. Anything in the way stops the spill rather than being overwritten.
  • Copy and paste between apps. Paste a block from Excel, Google Sheets or a web table and it lands as a proper grid. Copy from here and it pastes back with its layout intact.
  • Fill and format. Drag the fill handle to continue 1, 2, 3 or Jan, Feb, Mar or dates a month apart. Set bold, colours, alignment, currency, percentages and date formats.
  • Restructure. Insert and delete rows and columns — formulas are rewritten so they keep pointing at the right cells — sort a block, freeze panes, merge cells, and add or rename sheets.
  • Find and replace across one sheet or the whole workbook, including inside formulas.
  • Leave and come back. Your workbook is saved to this browser as you type, so a closed tab or a flat battery is not the end of the afternoon.

How to edit an Excel file online

  1. Open your workbookDrag an .xlsx, .xls, .xlsm, .xlsb or .csv file onto the page, or start from a blank sheet. It opens straight away because there is nothing to upload.
  2. Edit itClick a cell and type. Use the arrow keys, Tab and Enter to move, drag the fill handle to continue a series, write formulas starting with =, and format with the toolbar. Ctrl+Z undoes anything.
  3. Download the resultPress Ctrl+S or click Download .xlsx. Your formulas, formatting and layout are written into a fresh Excel file on your device.

Keyboard shortcuts

ShortcutWhat it does
F2Edit the selected cell
Ctrl + arrowJump to the edge of the data
Shift + arrowExtend the selection
Ctrl + ASelect the whole sheet
Ctrl + C / X / VCopy, cut and paste
Ctrl + D / RFill down, fill right
Ctrl + B / I / UBold, italic, underline
Ctrl + Z / YUndo and redo
Ctrl + FFind and replace
Ctrl + ;Insert today's date
Ctrl + SDownload the workbook as .xlsx

The 169 functions this editor calculates

Rather than claim "all Excel formulas", here is the actual list. Anything outside it returns #NAME? rather than a wrong number, and formulas the editor cannot evaluate are still saved back into the file untouched.

Math: SUM, SUMSQ, PRODUCT, SUMPRODUCT, ABS, SIGN, ROUND, ROUNDUP, ROUNDDOWN, MROUND, CEILING, FLOOR, INT, TRUNC, MOD, QUOTIENT, POWER, SQRT, EXP, LN, LOG, LOG10, EVEN, ODD, FACT, GCD, LCM, PI, RAND, RANDBETWEEN, SIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2, DEGREES, RADIANS

Statistics: AVERAGE, AVERAGEA, COUNT, COUNTA, COUNTBLANK, MAX, MIN, MEDIAN, MODE, STDEV, STDEV.S, STDEVP, STDEV.P, VAR, VARP, LARGE, SMALL, RANK, PERCENTILE, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, MAXIFS, MINIFS

Logic: IF, IFS, IFERROR, IFNA, AND, OR, XOR, NOT, TRUE, FALSE, SWITCH

Text: CONCAT, CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, LOWER, UPPER, PROPER, TRIM, CLEAN, SUBSTITUTE, REPLACE, FIND, SEARCH, REPT, TEXT, VALUE, EXACT, CHAR, CODE, UNICHAR, UNICODE, T, TEXTBEFORE, TEXTAFTER

Lookup: VLOOKUP, HLOOKUP, XLOOKUP, LOOKUP, MATCH, XMATCH, INDEX, CHOOSE, ROW, COLUMN, ROWS, COLUMNS, TRANSPOSE

Array: UNIQUE, SORT, SORTBY, FILTER, SEQUENCE, RANDARRAY, VSTACK, HSTACK, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, TOCOL, TOROW, TEXTSPLIT

Date: TODAY, NOW, DATE, TIME, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, WEEKDAY, WEEKNUM, DAYS, EDATE, EOMONTH, DATEDIF, NETWORKDAYS, WORKDAY, DATEVALUE

Info: ISBLANK, ISNUMBER, ISTEXT, ISNONTEXT, ISLOGICAL, ISERROR, ISERR, ISNA, ISEVEN, ISODD, NA, N, TYPE

Finance: PMT, FV, PV, NPER, NPV

Need a formula written for you? The function reference and the VLOOKUP and IF generators build them step by step.

Where an editor in a browser is the right tool

On a Chromebook or a Linux laptop with no Excel installed. On a work machine where IT has not provisioned Office and will not. On someone else's computer, where signing into your Microsoft account is not something you want to do. When a colleague emails an .xlsx and you need to fix one number before sending it back. And when the file is the kind of thing you would never upload to a stranger's server.

For a workbook that leans on macros, pivot tables or charts, open it in Excel or LibreOffice instead — this editor deliberately does not pretend to handle those.

Frequently Asked Questions

Related Tools