You need to know which version of Excel is right for your work and budget. Excel for Web is a free, browser-based application, while Desktop Excel is a paid, full-featured program. This article explains the key differences in features, performance, and cost. You will learn which tasks require the desktop version and what you can accomplish for free online.
Key Takeaways: Excel Web vs Desktop Features
- File > Save As > Download a Copy: Excel for Web requires this step to edit files offline on your computer.
- Data > Get Data > From File: Desktop Excel supports Power Query for advanced data import and transformation.
- Developer tab > Visual Basic: Only Desktop Excel allows you to create and run VBA macros for automation.
Understanding the Core Platforms and Access
Excel for Web runs entirely within a web browser like Microsoft Edge or Google Chrome. It is part of the free Microsoft 365 web apps available with a Microsoft account. Your files are stored and synced through OneDrive. Desktop Excel is the traditional application you install on Windows or macOS. It is licensed through a Microsoft 365 subscription or a one-time purchase of Office 2021 or earlier. The desktop program works without an internet connection and has direct access to your computer’s file system and hardware.
How You Get Each Version
To use Excel for Web, you simply sign in to office.com with a free Microsoft account. You can create, view, and edit basic workbooks immediately. For Desktop Excel, you must purchase it. The standard method is a Microsoft 365 subscription, which includes the latest desktop apps, ongoing updates, and 1 TB of OneDrive storage. A less common option is a one-time purchase of a standalone version like Office 2021, which does not receive feature updates.
Steps to Identify Your Current Version and Key Limitations
Knowing which features are missing in the free version helps you plan your work. Follow these steps to check your environment and understand common limits.
- Check the application title bar
Open your Excel file. If the window title says “Excel” or “Microsoft Excel” without mentioning a browser, you are using the desktop app. If you see your browser’s name (like Edge or Chrome) in the top bar, you are using Excel for Web. - Look for the Data tab’s Get Data group
In Desktop Excel, the Data tab has a “Get & Transform Data” group with buttons for Power Query. In Excel for Web, this group is missing. You cannot connect to databases, Azure, or other advanced data sources from the web version. - Try to record a macro
Go to the View tab and look for the “Macros” button. In Desktop Excel, you will see options to “View Macros” and “Record Macro.” In Excel for Web, the Macros button is completely absent, confirming you cannot use VBA automation. - Test advanced chart types
Try to insert a chart. In Excel for Web, you will find basic charts like column, line, and pie. Advanced charts like Waterfall, Funnel, Map, or 3D Surface charts are not available. The formatting options for charts are also more limited online.
Common Workflow Blockers and Things to Avoid
Excel for Web Cannot Open Files With Macros
If you try to open a workbook with a .xlsm extension or containing VBA code in Excel for Web, it will open in Protected View. You can see the data, but all macros are disabled and cannot be run. The VBA code editor is not accessible. To edit or run the macros, you must open the file in Desktop Excel. Avoid trying to develop or debug macros in the browser.
Limited PivotTable Data Source Options
In Excel for Web, you can create a PivotTable only from data within the current workbook. You cannot connect a PivotTable to an external data connection, an OLAP cube, or the Data Model. If your analysis relies on live connections to SQL Server or a complex data model built in Power Pivot, you must use Desktop Excel. Do not attempt to rebuild these connections in the web version.
No Support for ActiveX Controls or Form Controls
Workbooks that use interactive buttons, checkboxes, or other form controls inserted from the Developer tab will not function in Excel for Web. The controls may appear as static images, but you cannot click them. Any dashboard or form built with these elements will be broken. For interactive spreadsheets, use Desktop Excel or redesign the interface using standard cell formulas and hyperlinks for the web.
Excel for Web vs Desktop Excel: Feature Comparison
| Item | Excel for Web (Free) | Desktop Excel (Paid) |
|---|---|---|
| Cost | Free with Microsoft account | Requires Microsoft 365 subscription or one-time purchase |
| Offline Access | Requires internet connection to edit | Full functionality without internet |
| File Size Limit | Smaller files only, limited by browser memory | Supports much larger files and complex calculations |
| Power Query & Get Data | Not available | Full Power Query for data import and transformation |
| VBA & Macros | Cannot create or run macros | Full VBA editor and macro support |
| Advanced Charts | Basic chart types only | All chart types including Waterfall, Map, and 3D |
| Collaboration | Real-time co-authoring is primary strength | Co-authoring via OneDrive/SharePoint |
| Add-ins | Very limited support | Supports COM and Office add-ins |
You can now decide if the free Excel for Web meets your needs or if you require the paid Desktop Excel. For basic editing, sharing, and real-time collaboration, the web version is often sufficient. If you work with large datasets, need automation with macros, or use advanced data analysis tools, the desktop application is necessary. A useful advanced tip is to use Excel for Web’s co-authoring to brainstorm with colleagues, then switch to Desktop Excel for final analysis using Power Pivot.