Excel Online is the free, browser-based version of Microsoft Excel available at office.com. You don't need to install anything — open Chrome, Edge, Firefox, or Safari, sign in with a free Microsoft account, and you're working in Excel. Files save automatically to OneDrive. It's Microsoft's direct answer to Google Sheets, and it's been steadily improving since its launch.
The question most people have: how close is it to the desktop version? Closer than you'd expect for everyday work, and farther than you'd want for advanced tasks. Excel Online handles formulas, basic charts, sorting, filtering, conditional formatting, tables, and most of the functions you use day-to-day. What it doesn't handle: VBA macros, Power Query, Power Pivot, and some of the more advanced statistical tools that power analysts and financial modelers rely on. If those aren't in your workflow, Excel Online might be all you need.
For anyone studying excel formulas or preparing for spreadsheet work, Excel Online is a legitimate free practice environment. Every formula you learn in the desktop app works identically in the browser version. VLOOKUP, XLOOKUP, SUMIF, INDEX/MATCH, IFERROR, array formulas — all present and functional. The formula bar behaves the same way, autocomplete works, and error handling is identical.
Getting to Excel Online takes about 60 seconds:
That's it. No trial period, no credit card, no download. The free Microsoft account gives you Excel Online plus Word Online, PowerPoint Online, and 5GB of OneDrive storage. School and work accounts through Microsoft 365 get the same browser apps plus the full desktop versions.
If you have an existing excel spreadsheet file (.xlsx or .xls), upload it directly to OneDrive and it opens in Excel Online automatically. Most formatting, formulas, and chart types survive the upload without issues. The one common problem: if your file contains VBA macros, those macros won't run in the browser — you'll see a warning that macro functionality is disabled.
The gap between Excel Online and desktop Excel has narrowed significantly since Microsoft added XLOOKUP, dynamic arrays, and LAMBDA functions to the browser version. For most users doing budgets, reports, data entry, and basic analysis, Excel Online handles the job without frustration. Where you'll feel the limits:
Everyday spreadsheet tasks work seamlessly. Formulas across all major categories — lookup, math, text, date, logical, statistical — are present. Charts cover the basics: bar, column, line, pie, scatter, and area. Pivot tables work in Excel Online, though with slightly less flexibility in field arrangement than the desktop app. Tables with structured references, data validation dropdowns, and conditional formatting rules all function normally. Collaborative editing is actually better in Excel Online than in desktop Excel — changes appear in near real-time for all users, similar to Google Sheets.
VBA macros are the biggest omission. If your workflow depends on recorded or written macros to automate repetitive tasks, you need the desktop app. Power Query — Excel's data transformation tool for importing, cleaning, and reshaping data from external sources — is desktop only. Power Pivot and the Data Model, used for complex multi-table analysis and DAX formulas, aren't in the browser version. Some advanced chart types (funnel charts, waterfall charts, treemaps) are available in desktop Excel but not online. Sparklines render but can't be added in the browser.
Excel Online starts to lag noticeably with files above 50,000 rows. Calculation-heavy files with thousands of volatile functions (TODAY(), NOW(), INDIRECT()) recalculate slowly in the browser. For large data work — 100k+ rows, complex models, multi-sheet formulas — the desktop app is faster and more stable. Excel Online is optimized for the typical business user with moderate-sized files, not for data engineers processing large datasets.
For reference, google sheets vs excel comparisons often focus on exactly this performance gap at scale. Both browser-based tools have similar limits on large datasets — the desktop Excel advantage shows up at the high end of data volume and complexity.
Both are free, both run in browsers, both handle most everyday spreadsheet tasks. The choice usually comes down to ecosystem and function names. If your team uses Microsoft 365 — Outlook, Teams, SharePoint — Excel Online integrates more naturally. Files stored in OneDrive connect to Teams channels and SharePoint sites without extra steps. If your team lives in Google Workspace, Google Sheets connects directly to Gmail, Drive, and Meet with less friction.
Function compatibility matters if you're switching between tools. Excel and Google Sheets share most formula names and syntax — VLOOKUP, SUMIF, IFERROR, IF — identically. The main differences: Excel's XLOOKUP isn't available in Google Sheets (Sheets uses a different syntax), and Google Sheets has unique functions like IMPORTRANGE and GOOGLEFINANCE that Excel doesn't have. For people preparing for job interviews or certification exams, studying microsoft excel specifically matters because most employer tests use the desktop version.
Offline capability gives Excel Online a slight edge over Google Sheets for occasional offline work. Both tools require the browser to be pre-configured for offline mode, but Excel Online with OneDrive's sync client tends to work more reliably offline than Google Sheets' offline extension. That said, neither matches native offline Excel.
Several Excel Online features aren't obvious to new users:
When someone emails you an .xlsx file, you can open it directly in Excel Online without converting to a different format. Upload to OneDrive → open in browser → edit → it stays as .xlsx. No format conversion, no loss of formulas, no new file. This round-trip compatibility is essential for teams where some members use desktop Excel and others use the browser version.
Click Share in the top right and send a link. You can grant Can Edit (full access), Can Review (comments only), or Can View (read-only). Links can be scoped to specific people or anyone with the link. Unlike emailing an attachment, sharing a link means there's always one current version — no version-conflict headaches when multiple people edit and send files back and forth.
OneDrive keeps version history for every file. If you accidentally delete content or overwrite important data, click File → Version History to restore an earlier version. This is something desktop Excel without OneDrive doesn't offer automatically. The version history is a safety net that Google Drive also provides for Sheets.
Right-click any cell and add a comment. @mention a colleague to send them a notification. This is useful for review workflows — an analyst can add a comment asking a manager to check a formula before the file gets submitted. The comment thread persists, so reviewers can respond and mark issues resolved without cluttering the spreadsheet with notes in cells.
For anyone pursuing microsoft excel certification, practicing in Excel Online covers the majority of MOS exam content. The certification tests formulas, data management, charts, and table operations — all available in the browser version. The one gap: MOS Excel exams may include macro-related tasks that require desktop Excel knowledge.
Everyday business spreadsheets. Budget tracking, invoices, project timelines, inventory lists, and data entry forms work perfectly in Excel Online. If you're collaborating with a team on shared files, Excel Online is faster and cleaner than emailing attachments. Students and freelancers who need Excel functionality without a subscription get everything they need for school projects, client deliverables, and personal finance tracking. It's also the right choice for Chromebook users who can't install desktop software.
Complex automation and large data work. If your workflow involves VBA macros, scheduled data refreshes from external databases, Power Query transformations, or files routinely over 100,000 rows, you need desktop Excel. Financial analysts building complex models, actuaries running simulations, and data engineers processing large datasets hit limits in Excel Online faster than in the desktop app. For these use cases, a Microsoft 365 subscription that includes the full desktop app is worth the cost.
When to pay for desktop Excel. Microsoft 365 Personal costs $6.99/month and adds: the full desktop Excel app (Windows and Mac), 1TB OneDrive storage, offline access without setup, full macro/VBA support, Power Query, Power Pivot, and all advanced chart types. For professional or heavy-use scenarios, the upgrade cost is minimal relative to time saved. Many employers cover Microsoft 365 as a business expense. Students get Microsoft 365 free through their school — check your institution's software licensing before paying.
If you've used desktop Excel before, Excel Online will feel immediately familiar. The ribbon interface, keyboard shortcuts (Ctrl+C, Ctrl+V, Ctrl+Z, Ctrl+Shift+L for filters), and formula syntax are identical. The main adjustment is that files auto-save — there's no manual save step, which takes a day or two to trust after years of Ctrl+S muscle memory.
For beginners new to spreadsheets entirely, Excel Online is a low-friction entry point. Start with a blank workbook, type data into cells, use AutoSum (Alt+=) to add numbers automatically, and build your first formula by typing = followed by a function name. The formula autocomplete suggests functions as you type, and hovering over a function name shows its argument structure and a brief description. The learning curve for basic Excel tasks is a few hours of practice, not weeks.
Templates in Excel Online cover common use cases: personal budgets, project trackers, invoices, calendars, and expense reports. Access them from the New tab in Excel Online. Templates are fully editable once opened — swap out placeholder content with your actual data. For specific exam prep or learning structured exercises, consider using the excel practice test alongside your work in Excel Online to test your knowledge as you build skills.
One practical tip: keyboard shortcuts work across Excel Online and desktop Excel. Investing time to learn shortcuts — Ctrl+Shift+$ for currency format, F2 to edit a cell, Ctrl+D to fill down, Alt+Enter for a line break within a cell — pays off in both environments. The shortcuts don't change between versions or between Excel and Excel Online, so time spent learning them in the browser transfers directly to the desktop app and vice versa.