Quick Links
I had always been loyal to Excel’s Windows app, but I find I am increasingly using the web-based app to do my home- and work-based number crunching. Not only has Excel for the web adopted many app-based features, but it also has some added benefits that make it stand out from its traditional counterpart.
Excel for the Web’s Standout Benefits
Let’s first look at the features in Excel for the web that really persuade me that it’s the better way to create a spreadsheet.
It’s Free
If you’re looking for a free, web-based spreadsheet program that works like a paid app, you can’t go wrong with Excel for the web. All you need is a Microsoft account—which you can create using a Microsoft, Outlook, Hotmail, Live, Yahoo, or Gmail email address—to access to Microsoft 365 for the web.
Log in on theMicrosoft Office websiteand click “Excel.” From there, you can either open and work on a saved workbook, create a blank workbook, or use one of Excel’s templates—all without spending a penny.
You Can Automatically Sync Forms to Excel
Excel for the web is Microsoft’s answer to Google Sheets, and in no way is that truer than its form-to-spreadsheet integration.
While you may still download Microsoft Form entries to an Excel app spreadsheet, if you want the most up-to-date edition, you’ll have to re-download it again and delete any previous versions. However, if you choose toopen your form’s answers on Excel for the web, your spreadsheet will update with new entries as they come in and save automatically, exactly like when you export a Google Form to Google Sheets.
Once you have started to receive responses to your Microsoft Form, click the “Responses” tab, and you will see the results in more detail in your web browser window. Then, to open the results in table form in Excel for the web, where you can then manipulate your data, click “Open Results In Excel.”
Your Internet browser will then open Excel for the web in a new tab, and your results will appear in a table. If your form is still open for new entries, they’ll appear as additional rows at the bottom of your table as soon as they come in.
Excel Online Is Better for Collaboration
Sharing an Excel workbook through the app or Excel for the web requires very similar steps. Where Excel for the web comes out on top, though, is how it lets two or more people work on a spreadsheet at the same time (and, as I mentioned earlier, using Excel for the web is free).
you’re able to set up co-authoring within your Excel app, but this is a long-winded process and requires a Microsoft 365 subscription. However, once you share a sheet on Excel for the web, the person you’re sending it to can view and—if you let them—edit your workbook. What’s more, they can do this without signing in to a Microsoft account.
First, click “Share” in the top-right corner of your Excel workbook to see your sharing options.
All of these options let you choose who can edit or just view the workbook. After you have shared your sheet through Excel for the web, click “Manage Access” to change these settings.
If you share your workbook with someone who doesn’t have a Microsoft account, they won’t be able to access more advanced features, such as inserting a picture. However, they can do most of the important things that Excel is used for).
You Can Check Your Spreadsheet’s Performance
Sometimes, especially if you have a data-heavy workbook, you might find that Excel lags somewhat. In this situation, you should firsttry some quick fixes to speed up your computer, but if you’ve already done this, it could be that your spreadsheets contain unnecessary formatting or metadata. Rather than having to search for these issues manually—which you would have to do if you were using the Excel 365 PC app—you can force Excel for the web to do it for you.
To activate this, in the Review tab on the ribbon, click “Performance.”
You’ll then see a sidebar open on the right of your window containing any issues with your workbook and the option to address them by optimizing your work.
Get the Latest Updates on Excel for the Web
When Microsoft has a new idea for its apps, it first rolls it out to members of theMicrosoft 365 Insider program. Generally, updates to the web-based version of Excel are available to everyone using the program much more quickly than when Microsoft amends its subscription apps. As a result, you’re more likely to access Excel’s latest features by using Excel for the web. As well as the features mentioned above, keep an eye on theMicrosoft 365 Insider blogfor more info on what’s in the pipeline.
Excel for the Web Has Many Traditional App-Based Features
Over the years, people have complained that Excel for the web is less functional than its app-based counterpart. While this might have been correct when Microsoft launched the Office Web Apps in 2010, nowadays, Excel for the web has adopted many features from its app-based cousin:
There’s Room for Improvement
While Excel for the web does, indeed, have some minor sticking points, they’re not difficult to overcome. Here are some examples:
While you may find other ways that Excel’s desktop app is still preferable for certain uses, it’s likely that Microsoft will continue to add features to Excel online as time passes. There’s no sign of Office going away entirely, though the fact Microsoft has changed its package name from Office 365 to Microsoft 365 in favor of the cloud-based platform suggests that the company is planning to continue pushing its online programs.
