Office Online Service Description

Office Online (formerly Office Web Apps) opens Word, Excel, OneNote, and PowerPoint documents in your web browser. Office Online makes it easier to work and share Office files from anywhere with an Internet connection, from almost any device. Microsoft Office 365 customers with Word, Excel, OneNote, or PowerPoint can view, create, and edit files on the go.

To compare features across plans, see Compare Office 365 for Business plans.

Feature availability across Office Online plans

Need help figuring out which Office solution best fits your organization? The following tables compare Office Online feature capabilities to feature-rich Microsoft Office desktop apps. Use the tables to discover what features are available in Office Online and then click on the feature name to read a brief description about how that feature works. You might discover that some people in your organization need the advanced charting capability of the Excel desktop app while others only need to view and lightly edit Word documents and PowerPoint presentations with Office Online.

Note

A limited selection of Office features has been chosen to represent the advanced capabilities of the Office desktop suite. The tables are not a comprehensive list of Microsoft Office features. > Microsoft Office 365 ProPlus is a monthly subscription offer of the latest Office desktop suite. > Microsoft Office Online Server on-premises customers get an Office Online editing license if they have purchased an Office desktop suite license (such as an Office Professional Plus, Office Standard, or Office 365 ProPlus license).

Note

When you open an Office document, either as an Outlook email attachment or from a SharePoint document library, the document will launch in Office Online and will be read-only. To edit a document in Office Online (edit mode), you need an Office 365 suite license, such as Office 365 Enterprise E1. To edit a document in the desktop app, you need an Office desktop suite license, such as an Office 365 ProPlus subscription or an installed version of Office Professional Plus 2010.

Word

Application features
Word Online
Word desktop app
Alignment guides and live layout
No
Yes
Apply styles
Yes
Yes
Autosave
No
Yes
Autotext
Yes
Yes
Browse and start from professionally designed templates
Yes
Yes
Bullets and numbering
Yes
Yes
Captions
No
Yes
Citations and bibliography
No
Yes
Clipboard
Yes
Yes
Collaboration- advanced
No
Yes
Content controls
Yes
Yes
Cover pages
No1
Yes
Creation of advanced document elements
No
Yes
Document parts and themes
No
Yes
Dropbox
Yes
Yes
Equations
No1
Yes
Find and Replace
Yes
Yes
Font formatting
Yes
Yes
Footnotes and endnotes
Yes
Yes
Full fidelity reading view
Yes
Yes
Graphic effect presets
Yes
Yes
Headers and footers
Yes
Yes
Hyperlinks
Yes
Yes
Index
No1
Yes
Ink Editor
No
Yes
Insert online pictures
Yes
Yes
IRM and password-protection
No
Yes
Learning Tools
No
Yes
Lists
Yes
Yes
Mail merge
No
Yes
Office Add-ins
Yes2
Yes
Offline viewing and authoring
No
Yes
Page breaks
Yes
Yes
Page layout tools
Yes
Yes
Page layout tools- advanced
No
Yes
Page numbers
Yes
Yes
Paragraph formatting
Yes
Yes
Picture tools
Yes
Yes
Preformatted font and color schemes
Yes
Yes
Present online
No
Yes
Print to PDF
Yes
Yes
Printing- advanced
No
Yes
Proofing tools
Yes
Yes
Proofing tools- advanced
No
Yes
Real-time co-authoring
Yes
Yes
Reference tools
No
Yes
Rendering of text boxes/shapes
Yes
Yes
Researcher
No
Yes
Rich media
No
Yes
Rich table formatting
Yes
Yes
Save As and Download a copy
Yes
Yes
Save as PDF
Yes
Yes
Share
Yes
Yes
Simple table creation
Yes
Yes
SmartArt
No1
Yes
Table of Authority
No1
Yes
Table of Contents
No1
Yes
Tap
No
Yes
Tell Me
Yes
Yes
Translation service
Yes
Yes
Undo and Redo
Yes
Yes
VBA and Forms scripts
No
Yes
View and add comments
Yes
Yes
Watermarks
No1
Yes
Word count
Yes
Yes
Zoom
Yes
Yes

Note

1 These render in the viewer, but you cannot create or edit them in Office Online. > 2 Some, but not all, Office add-ins are available.

Excel

Application features
Excel Online
Excel desktop app
Accessibility Checker
Yes
Yes
Add hyperlinks
Yes
Yes
Advanced time filtering (Timeline slicer)
No
Yes
Alignment
Yes
Yes
Apply conditional formatting
Yes
Yes
Apply smart/recommended formatting
No
Yes
Audio notes recording
No
Yes
Autocomplete
Yes
Yes
AutoSum
Yes
Yes
Calculations
Yes
Yes
Comment creation
Yes
Yes
Copy and paste
Yes
Yes
Create external data connections2
No3
Yes
Create tables
Yes
Yes
Creation of advanced analysis views (Power View, Power Pivot, Slicers)
No
Yes
Data validation
Yes
Yes
Drag and drop cells
Yes
Yes
Dropbox
Yes
Yes
Embed Workbook on Web or Blog Page (OneDrive)
Yes
No
External references
No5
Yes
Fill Handle
Yes
Yes
Find
Yes
Yes
Font and cell formatting
Yes
Yes
Formula bar
Yes
Yes
Formula tools- advanced
No
Yes
Freeze panes
Yes
Yes
Full fidelity reading view
Yes
Yes
Functions
Yes
Yes
GoTo
Yes
Yes
Hide/unhide rows, columns, and sheets
Yes
Yes
Insert shape/picture
Yes
Yes
Insert charts
Yes
Yes
Insert/delete rows and columns
Yes
Yes
Merge cells
Yes
Yes
Number formatting
Yes
Yes
Office Add-ins
Yes
Yes
Offline viewing and authoring
No
Yes
Pivot Charts
Yes1
Yes
Pivot Tables
Yes
Yes
Post to Social network and present online
No
Yes
Power Pivot viewing
Yes
Yes
Power View viewing
Yes
Yes
Print
Yes
Yes
Real-time co-authoring
Yes
Yes
Recommended chart creation and editing with formatting controls
No
Yes
Refresh existing data connections
Yes
Yes
Rename and add sheets
Yes
Yes
Rename file while workbook is open
Yes
No
Replace
Yes
Yes
Rights Management: IRM and password security
No
Yes
Save or Download a copy
Yes
Yes
Share
Yes
Yes
Sheet protection
Yes
Yes
Slicer viewing
Yes
Yes
Sort and filter data
Yes
Yes
Spreadsheet audit and compliance
No
Yes
Status bar aggregates
Yes
Yes
Surveys
Yes
No
Tell Me
Yes
Yes
Undo and redo
Yes
Yes
VBA and macro scripting
Yes3
Yes
View 3D charts
Yes
Yes
What if analysis tools
No
Yes

1 Cannot create PivotCharts, view only.
2 Depending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in Excel Online. For more information, see Refreshing data in a workbook in a browser window.
3 You cannot create macros with VBA in Excel Online, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file.
4 Workbooks that use data validation can be edited in Excel Online, but data validation cannot be set up in Excel Online.
5 In Excel Online, the last known reference value displays in the browser window; however, it must be updated using Excel desktop.
6 You can view freeze panes created using Excel desktop app, but you cannot create freeze panes in Excel Online.
7 Some, but not all, Office add-ins are available.

OneNote

Application features
OneNote Online
OneNote desktop app
Advanced collaboration: New content shows as unread, presence
No
Yes
Apply tags
Yes
Yes
Bullets and numbering
Yes
Yes
Clipboard
Yes
Yes
Clipping experiences
No
Yes
Co-authoring
Yes
Yes
Create and manage pages and sections
Yes
Yes
Download copy of embedded Office files
Yes
Yes4
Dropbox
Yes
Yes
Edit embedded files
No
Yes
Equations
Yes
Yes
Hyperlinks
Yes
Yes
Image optical character recognition (OCR)
No
Yes
Inking: ink-to-text and math, customizable pens, drawing tools
No
Yes
Ink viewing
Yes
Yes
Navigation
Yes
Yes
Notebook management: Cross section/notebook page filing, section re-order, create/delete section groups
Yes1
Yes
Office Add-ins
Yes2
Yes
Outlook integration (tasks)
No
Yes
Paragraph formatting
Yes
Yes
Pictures
Yes
Yes
Print
Yes
Yes
Proofing tools
Yes
Yes
Rights Management: IRM and password security
No
Yes
Search by: tag, title, author/date, audio notes
Yes3
Yes
Search (on page, within sections)
Yes
Yes
Share
Yes
Yes
Show or hide authors
Yes
Yes
Styles
Yes
Yes
Tables
Yes
Yes
Template support
No
Yes
Undo and Redo
Yes
Yes
Video playback
No
Yes
View previous page versions
Yes
Yes

Note

1 In OneNote Online, you can move sections within a notebook, and copy and paste pages from one section to another.
2 Some, but not all, Office add-ins are available.
3 You can search on Page or Section, but not entire notebook or across notebooks (as you can in the desktop version).
4 In the desktop version, there is not a "download" option, but you can Save As to another location.

PowerPoint

Application features
PowerPoint Online
PowerPoint desktop app
Alignment, bullets, numbers
Yes
Yes
Apply basic transitions and animations
Yes1
Yes
Apply rich formatting to text, shapes, and pictures
No
Yes
Apply themes and theme variants
Yes
Yes
Arrange objects
Yes
Yes
Broadcast slide show
No
Yes
Clipboard
Yes
Yes
Create and manage slides
Yes
Yes
Create custom animation
No1
Yes
Design tools- advanced
No
Yes
Embed presentation on web or blog page
Yes
No
Font formatting
Yes
Yes
Full fidelity reading view
Yes
Yes
Full ink support
No
Yes2
Full selection of animations and transitions
No1
Yes
Headers and footers
No
Yes
Hyperlinks
Yes
Yes
Insert online video
Yes
Yes
Integration with Excel for charts
No
Yes
Navigation— slide sorter
Yes
Yes
Office Add-ins
Yes3
Yes
Offline viewing and authoring
No
Yes
Picture cropping
Yes
Yes
Pictures
Yes
Yes
Presenter view
No
Yes
Present online through Skype for Business or the Office Presentation Service
Yes
Yes
Print to PDF
Yes
Yes
Proofing tools
Yes
Yes
Real-time co-authoring
Yes
Yes4
Reviewer tools - advanced
No
Yes
Rights Management: IRM and password security
No
Yes
Run slide show
Yes
Yes
Save As or Download a copy
Yes
Yes
Shapes
Yes
Yes
Share
Yes
Yes
Slide show
Yes
Yes
SmartArt
Yes
Yes
Table creation/editing and formatting
Yes
Yes
Tell Me
Yes
Yes
Undo and redo
Yes
Yes
View and add comments
Yes
Yes
View and edit slide notes
Yes
Yes
WYSIWYG viewing
Yes
Yes

1 PowerPoint Online supports a gallery of eight transitions and 37 animations. For a larger selection or to create custom animations, use the PowerPoint desktop app.
2 The device you're working on needs to support ink.
3 Some, but not all, Office add-ins are available.
4 You cannot create PivotCharts or PivotTables, but you can see them in the viewer.

Supported file types for Office Online

Word documents created in Word 2.0 or later
View mode
Edit mode
Open XML (.docx)
Yes
Yes
Binary (.doc)
Yes
Converted to .docx
Macro (.docm)
Yes1
Yes1
Other (.dotm, .dotx)
Yes
No
OpenDocument (.odt)
Yes
Yes
Portable Document Format (.pdf)
No
No
Excel workbooks created in Excel 97 or later
View mode
Edit mode
Open XML (.xlsx, .xlsb)
Yes
Yes
Binary (.xls)
Yes
Converted to .xlsx
Template (.xlt, .xltx)
No
No
Macro (.xlsm)
Yes1
Yes2
OpenDocument (.ods)
Yes
Yes
OneNote notebooks created in OneNote 2010 or later
View mode
Edit mode
Open XML (.one)
Yes
Yes
PowerPoint presentations created in PowerPoint 97 or later
View mode
Edit mode
Open XML (.pptx, .ppsx)
Yes
Yes
Binary (.ppt, .pps)
Yes
Converted to .pptx or .ppsx
Template (.pot, .potx)
Yes
No
Macro (.pptm, .potm, .ppam, .potx, .ppsm)
Yes1
No
Add-ins (.ppa, .ppam)
No
No
OpenDocument (.odp)
Yes
Yes

Note

1 Macros can't be run or changed. > 2 If macros exist, users are prompted to have a copy of the file with the macros removed.

Note

Newer file formats (such as .docx, .xlsl, and .pptx) can be created in Office 2016, 2013, 2010, or 2007, or in Office 2000 and later with the compatibility pack.