Microsoft Excel Online: Features, Limits & How to Use It

Microsoft Excel Online is the free, browser-based version of Excel that runs in any modern web browser without requiring installation. Included with any Microsoft account (including the free Outlook.com accounts), it provides core spreadsheet functionality — formulas, charts, data sorting, and filtering — directly in the browser.

For students, small businesses, and anyone who needs basic spreadsheet capability without paying for a Microsoft 365 subscription, microsoft excel online delivers substantial functionality at no cost. For organizations already on Microsoft 365, it provides an additional access point for files stored in OneDrive or SharePoint, enabling editing from any device including tablets and Chromebooks where the desktop application isn't available.

Excel Online isn't a stripped-down placeholder — it's a fully functional spreadsheet application for most common use cases. Creating and editing workbooks, writing formulas using hundreds of supported functions, building charts from data ranges, applying conditional formatting, sorting and filtering data, and collaborating with others in real time are all fully supported.

The limitations that exist are mostly around advanced features: VBA macros don't run in the browser, some Power Query functionality is limited, pivot tables have more restricted customization options, and performance on very large datasets is slower than the desktop application. For the majority of spreadsheet tasks, Excel Online is a capable tool.

The collaboration features are among Excel Online's strongest advantages. Multiple users can edit the same workbook simultaneously, with each person's cursor and changes visible to others in real time. Comments and notes function as a shared discussion thread attached to specific cells. Version history automatically preserves prior versions so any change can be undone.

For teams sharing data, tracking project status, or collaboratively building reports, these real-time collaboration features work significantly better in Excel Online than in the desktop application, where shared workbook functionality has historically been more limited and less reliable. Understanding the full range of microsoft excel online capabilities starts with knowing what makes the browser version distinct from the desktop version.

Excel Online supports the full function library used by the vast majority of Excel users in daily practice. VLOOKUP, XLOOKUP, INDEX/MATCH, IF, SUMIF, COUNTIF, TEXT, DATE, IFERROR, and the complete financial and statistical function libraries are all available. Dynamic array functions introduced in recent Excel versions — FILTER, SORT, UNIQUE, SEQUENCE — work in Excel Online and automatically spill into adjacent cells.

The formula engine is consistent with the desktop version, meaning that formulas written in Excel Online produce the same results as the same formulas in the desktop application. This consistency is important for organizations where some users work in the browser and others work on the desktop — the same workbook behaves the same way regardless of how it's opened.

Charts and visualization work fully in Excel Online. You can create line charts, bar charts, pie charts, scatter plots, and combination charts from data ranges, then format them with titles, axis labels, colors, and styles. The chart formatting options in the browser version are somewhat less extensive than the desktop application's options, but the core chart creation workflow is essentially the same. For dashboards and reports that need to be accessible from any browser without desktop application requirements, Excel Online charts render correctly and can be embedded in SharePoint pages or Teams tabs alongside other content.

Data tables and Excel Tables (structured table objects created with Ctrl+T) function correctly in Excel Online. Table references in formulas — the structured reference syntax like =Table1[Sales] — work as expected, and tables auto-expand when new rows are added. For the microsoft excel online formula features that interact with table structures, VLOOKUP and XLOOKUP work with table references the same way they do in the desktop version, which is a significant practical benefit for formula-heavy workbooks that need to be maintained in the browser.

The most significant limitation is VBA macros. Excel Online does not execute VBA code. Workbooks containing macros open in the browser, but the macros are inactive. Clicking a macro button or using a keyboard shortcut assigned to a macro does nothing.

If your workflow depends on macro automation, you need either the desktop application or Office Scripts — the browser-compatible automation alternative that uses TypeScript and runs on Microsoft's cloud infrastructure. Office Scripts require a Microsoft 365 Business or Enterprise subscription (they're not available on the free tier), but they provide genuine automation capability within Excel Online for organizations on qualifying plans.

Power Query (Get & Transform) functionality is partially available in Excel Online. You can view existing queries and refresh them, but creating new queries or editing the query editor interface isn't fully supported in the browser. For workbooks that pull data from external sources via Power Query, the refresh functionality usually works, but building the data transformation pipeline requires the desktop application. This limitation matters most for business intelligence workbooks where the data pipeline needs to be modified as source structures change.

Pivot table functionality is more limited in the browser. You can interact with existing pivot tables — drilling down, filtering, refreshing — and you can create basic pivot tables from scratch, but advanced pivot table configurations including calculated fields, custom sort orders, and some conditional formatting options require the desktop application. For standard summarization and analysis tasks, Excel Online pivot tables work adequately. For complex pivot table designs, the desktop application remains necessary. For keyboard shortcuts and navigation efficiency, the microsoft excel online shortcut guide notes which keyboard shortcuts differ between the browser and desktop versions.

Real-time co-authoring is where Excel Online genuinely surpasses the desktop application in everyday workflow. When multiple users have the same workbook open through OneDrive or SharePoint, their edits appear in near-real-time for all other users. Each person's cursor position is visible with their name attached, making it easy to see who is editing which cell. This eliminates the "who has the file locked?" problem that plagues teams using shared network drives or emailed spreadsheets. For teams that collaborate heavily on shared data, the real-time co-authoring experience in Excel Online represents a meaningful workflow improvement over sending files back and forth.

Version history in Excel Online is automatic and continuous. Every session's changes are preserved, and the version history timeline allows restoring any prior state without manual saving or version naming. This safety net changes how users work — knowing that accidental deletions or formula overwrites can be undone from version history reduces the anxiety around making changes to important shared workbooks. The desktop application's version history (through AutoSave and OneDrive) provides similar protection, but the browser's version is typically more granular and more reliably maintained.

Comments and @mentions work as a structured discussion layer within Excel Online. Adding @username in a comment sends that person a notification in Outlook and Teams, creating an integrated communication thread tied to specific data. For teams using Microsoft 365 for their communication and collaboration tools, this integration means that spreadsheet discussions happen in context rather than in a separate email chain that loses the connection to the specific cell being discussed. The microsoft excel online guide to collaborative spreadsheet workflows explains how to set up shared workbooks, manage permissions, and use comments effectively in a team environment.

Choosing between Excel Online and the desktop application usually comes down to two factors: what features you need and what device you're using. For standard data entry, formula work, and analysis tasks, Excel Online handles everything most users do in Excel every day. For advanced work involving VBA macros, complex Power Query pipelines, very large datasets (over 100,000 rows where performance differences become noticeable), or extensive pivot table customization, the desktop application is the right tool. Many professionals use both: the browser version for quick edits, reference lookups, and collaborative review, and the desktop application for intensive analytical work.

The device consideration is separate from the feature consideration. On a Chromebook, a tablet, or any computer where Microsoft Office isn't installed (including Linux systems), Excel Online is the only way to work with Excel files natively without third-party applications. Google Sheets and LibreOffice Calc can open .xlsx files, but they're different applications with different behavior. Excel Online, being Microsoft's own browser application, handles Excel files with full fidelity — formulas, styles, and data structures all preserve exactly as created in the desktop version.

For Excel certification and skills development, understanding Excel Online is increasingly important because many organizations' worksheets live in OneDrive or SharePoint rather than on local drives, making browser-based access a daily workflow reality rather than an edge case. For exam preparation and skills practice that covers both desktop and browser-based Excel features, the microsoft excel online practice resources on this site include questions on both the core formula functionality that works identically across both environments and the specific features that differ between them.