Everything done through the online version of Office is performed through a web browser and saved online, so you can access the files from anywhere.
Using Office Online
When you visit Office.com and log in with your Microsoft account, there’s a menu, like you see above, that provides access to all the apps you’re offered. This is how you access Excel online, or Word, or Outlook, etc. When you select an app, you’ll be taken to it immediately, where you can then create and edit files already in your account, and upload new ones. For example, Excel Online has an Upload and open button where you can select an XLS, XLSX, XLB, CSV, or other supported file from your computer. Office Online also makes it really easy to share files and work on documents with other people in real time. Links can be shared that anyone with a Microsoft account can open, so that you can collaborate on files.
Microsoft Office Online File Formats
Microsoft Office Online fully supports the following file types, meaning that you can open and save back to these formats: Other files are supported, too, such as CSV, but after editing it, if you want to save it back to your computer, you need to pick XLSX or XLSM. You can, however, take advantage of an export tool that permits the saving of formats like ODT and PDF as a downloaded document. Otherwise, Office saves to OneDrive by default, and it links with your desktop version of Office such that your most-recent-files list is synced between the two.
Microsoft Office Online vs. Microsoft Office
The desktop version of is similar to the online one. While some features may not be present in the online tool, the overall look and feel are nearly identical. They both contain Word, Excel, PowerPoint, Outlook, and OneNote. The major limitation relates to the fullness of the feature set. The desktop apps, by virtue of residing on a hard drive with access to the operating system, contain richer tools for things like inserting complex objects. Although Office Online is certainly a full-featured online productivity suite, no online-only platform generally offers the same capability as a locally installed program.
Thoughts on Microsoft Office Online
If you’re familiar with Office on your desktop, using the online version is a breeze, as the menus and functions are similar, if not the exact same. Common file formats are allowed and every single format that Office supports is supported in the online version. However, there is a major difference in the way Office Online uses these files compared to the desktop version. Say you’re working with someone else on a DOC file that was created in a program like SSuite Office. If you load this DOC file into Office Online and attempt to make any edits, the file is automatically converted to DOCX. This means when you save it and return it to the SSuite user, edits can’t be made because that office suite doesn’t allow DOCX files to be opened.