Export (0) Print
Expand All

Excel Online

Office 365
 

Applies to: Office 365

Topic Last Modified: 2014-05-15

Excel Online (formerly Excel Web App) extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website where the workbook is stored. All Office 365 customers can view and lightly edit Office files using Office Online.

NoteNote:
Workbooks that exceed 10 megabytes (MB) cannot be viewed in Excel Online from within Microsoft SharePoint Online. To view larger files, you’ll need the Excel desktop app installed on your computer.

To quickly see which features are only applicable to Excel Online, see Compare feature availability across Excel Online and Excel 2013 desktop app .

NoteNote:
To help you compare offers, advanced features listed in this article include Excel desktop app capabilities that are only available in the Office suite (such as Office Professional Plus, Office Standard, or Office 365 ProPlus). For a list of all Office Online features, such as Word Online and PowerPoint Online, see Feature availability across Office 365 plans

Link to web pages or open files on the web by adding a hyperlink in a cell. You can type the web address directly in the cell or use the Insert Hyperlink command.

The Timeline control lets you filter modeled data. It’s a visual way to view and change a continuous range of dates and filter pivot-based objects, such as PivotTables and PivotCharts. Excel Online does not support this feature.

Use the Alignment buttons on the Home tab to change the alignment of text.

Not available in Excel Online. Advanced features, such as conditional formatting, are only available in the Excel desktop app. Learn more about how to use conditional formatting in Excel 2013.

Not available in Excel Online. Advanced features, such as data validation, are only available in the Excel desktop app. However, you can view and interact with data validation-enabled in Excel Online. Learn more about applying data validation to cells in Excel 2013.

Not available in Excel Online. In the Excel 2013 desktop app, recommended charts let you pick from a variety of charts that are best for presenting your data. Learn more about how to use chart recommendations in Excel 2013.

Excel Online only supports content apps for Office. Content apps integrate web-based features as content that can be shown inline with a document. You can get an app for Excel from the Office Store. Learn more about how to get an Excel app.

Excel Online can complete what you’re typing into a cell and, if there’s more than one possible value, display them all in a list that you can pick from.

Total a column or row of numbers by selecting the cells you want to sum and then double-click AutoSum. The result appears in the next blank cell.

Only Microsoft Excel desktop app supports advanced chart features. Learn more about how to animate a SmartArt graphic.

You can insert, edit, and delete comments in Excel Online. Learn more about adding a comment to Excel.

For best results, use keyboard shortcuts, not the right-click menu or Clipboard commands in Excel Online, to copy items to another worksheet location. Lean more about using copy and paste in Excel Online.

You can use Excel Online to view data connections, but you can’t create external data connections using Excel Online. You’ll need the Excel 2013 desktop app to work with external data. Learn more about working with external data in Excel Services.

Create a table to organize and analyze related data. Tables make it easy to sort, filter, and format your data.

Advanced analysis views, such as Power Pivot and Power View, are only available in Excel desktop app. These features are not supported in Excel Online. Learn more about PowerPivot.

You can move cell value in Excel Online by dragging and dropping cells from one place to another.

If you store an Excel workbook on OneDrive.com, you can embed it directly in a blog or website. Your readers can sort, filter, and calculate data right there, and if you update the workbook in OneDrive, they’ll see the latest changes the next time they refresh the page. Learn more about embedding an Excel workbook on your blog.

Drag the Fill Handle that appears in the lower-right corner of a selected cell or range of cells to fill the data into adjacent cells.

Find cell content in the active worksheet. An easy to use dialog box gives the option to search up or down from the current selection in the worksheet.

Customize your data to give it the exact look you want. Choose from a variety of font styles or colors or change the size and color of text.

See the formulas behind a cell’s results in the formula bar. You can add, change, and delete parts of your formula in the browser just like you would in the Excel desktop app.

Microsoft Excel desktop app supports the most advanced formula tools, such as 3D reference style and array formulas. Excel Online only supports the most basic Excel formulas. Learn more about formulas.

The freeze panes feature is not available in the Excel Online ribbon, but you can view workbooks that contain freeze panes. Learn more about how freeze panes work in the Excel 2013 desktop app.

Anything you can see in a workbook in the browser in Editing View, you can see in Reading View.

You can use most of Excel’s more than 400 worksheet functions in formulas in Excel Online.

Quickly navigate around your spreadsheet using the GoTo feature. Type in a cell reference and jump to that location in the spreadsheet. Learn more about keyboard shortcuts in Excel Online.

You can hide and unhide rows, columns, and sheets in a workbook in Excel Online.

Create a chart to visually represent your data. Choose from a variety of chart types, such as column, line, pie, or bar charts. Learn more about available chart types.

Select one more rows before clicking Insert or Delete on the Home tab to add or remove rows or columns in your worksheet one at a time or several at once.

Use Merge & Center on the Home tab to combine and center the contents of the selected cells in one larger cell. You can change the alignment by clicking the Alignment buttons.

Change the format of numbers. Pick a format such as Currency or Short Date from a list of formats, change the decimal places, or insert a thousands separator.

Excel Online is launched from an Internet browser and relies on an Internet connection. To access spreadsheets offline, Microsoft Excel desktop app must be installed on your computer and used to view and edit Excel worksheets.

Share selected portions of your spreadsheets on the web by embedding them on your social network pages, or Lync conversations, or meetings. Excel Online does not support these features.

Excel Online allows you to view Power Pivot tables and charts, but you need the Excel 2013 desktop app to create Power Pivot data models.

You can view and interact with Power View sheets in a workbook, but you cannot create Power View using Excel Online. Power View creation is only available with the desktop application. Power View allows you to create, share, and explore data in interactive, presentation-ready views. View information in interactive maps, charts, and tables that are linked to each other in a single worksheet. Learn more about Power View.

Use the Print command in Excel Online to send the entire worksheet or the current selection to the printer. Learn more about how to print in Excel Online.

Two or more people can work in the same spreadsheet at the same time by opening it in their web browser instead of in the Excel desktop app. Real-time presence helps you see where your co-authors are working in the document so that you don’t create conflicts as you edit, and you can see changes as they’re being made.

Only Microsoft Excel desktop app supports advanced charts. Excel Online does not support these features. Learn more about available chart types.

If the data in your workbook is connected to external sources, such as databases, web pages, or analysis cubes, you can refresh that data using Excel Online.

Click the New Sheet icon to add a sheet. Right-click any sheet tab to rename it.

In Excel Online, you can rename a workbook file without closing it by clicking the filename in the header and typing in a new name. To rename a file using Excel desktop app, close the file, navigate to its location on your device, and rename the file.

Not available in Excel Online. If you have the Excel desktop app installed on your computer, then you can use Excel to find and replace content in a document. Learn more about using find and replace in Excel 2013.

Protect your workbooks using passwords, permissions, and other restrictions in Excel desktop app. In Excel Online, you can load and interact with workbooks that contain Sheet Protection, which prevents users from selecting or typing in protected cells. Learn more about protecting Excel workbooks.

Want your own copy of the workbook? Use the Save As command on the File tab, or right-click the workbook’s name in its folder and use the Download command to send a copy to your computer.

One-click process for sending a link that others can use to view or edit the document. Learn more about using Office Online to work together in Office 365.

View slicers in your worksheet and filter your data by clicking the slicer buttons. You cannot create or edit slicers in Excel Online.

In Excel Online, you can view and reorder all worksheets, sort and filter data, and drill into the details of PivotTables.

In Microsoft Excel desktop app, you can use the worksheet inquire and compare features to compare versions of a workbook, analyze a workbook for problems or inconsistencies, or see links between workbook and worksheets. Excel Online does not support these features. Learn more about what you can do with Spreadsheet Inquire.

When you select a group of cells in Excel Online, you can see the SUM, AVERAGE, and COUNT in the status bar. You can also customize the status bar by choosing which aggregates you want to see.

Use Survey to send an Excel Online form to users that they can fill out. Responses will be automatically compiled in an online worksheet. Learn more about surveys in Excel.

When you need to accomplish something in Excel Online but don’t know how, you can use the Tell Me search feature to quickly find what you’re looking for. Tell Me understands what you’re trying to accomplish and helps you do it faster by making suggestions.

Excel Online saves your work automatically. If you make a mistake, use Undo or press Ctrl + Z, and Redo or press Ctrl + Y. Learn more about keyboard shortcuts in Excel Online.

Microsoft Excel desktop app is an extremely powerful tool used to manipulate, analyze, and present data. Sometimes, despite the rich set of features, your organization might find it easier to use Visual Basic for Applications (VBA), a programming language, to create a macro that performs mundane, repetitive tasks or to perform some task that the user interface (UI) does not seem to address. 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. Learn more about getting started with macros.

View 3D charts in your worksheet. You cannot create or edit 3D charts in Excel Online.

Not available in Excel Online. You can view “What if” analysis results in Excel Online, as expected. If you want to use analysis tools such as Goal Seek, Data Tables, Solver, and Series, then you’ll need the Excel desktop app. Learn more about differences between using a workbook in the browser and in Excel desktop app.

All workbooks open in Excel Online first—this is View mode. While in View mode, if you click the Edit in Browser button on the Excel Online toolbar, Excel Online will go into Edit mode.

While in View or Edit mode, if you click the Open in Excel button on the Excel Online toolbar, the document opens in the Excel desktop application (if Microsoft Excel 2010 or later is installed on your computer).

Use the following table to determine which service best fits your needs, the viewing and light editing capabilities of Excel Online or the rich Excel 2013 desktop app.

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

 

Excel

Excel Online

Excel 2013

Full fidelity reading view

Yes

Yes

Number formatting

Yes

Yes

Font and cell formatting

Yes

Yes

Copy and paste

Yes

Yes

Drag and drop cells

Yes

Yes

GoTo

Yes

Yes

Undo and redo

Yes

Yes

Merge cells

Yes

Yes

Alignment

Yes

Yes

Create tables

Yes

Yes

Insert charts

Yes

Yes

Fill Handle

Yes

yes

Formula bar

Yes

Yes

Status bar aggregates

Yes

Yes

Functions (approx.400)

Yes

Yes

Hide/unhide rows, columns, and sheets

Yes

Yes

Autocomplete

Yes

Yes

Auto Sum

Yes

Yes

Formula tools- advanced

No

Yes

Insert/delete rows and columns

Yes

Yes

Rename and add sheets

Yes

Yes

Rename file while workbook is open

Yes

No

Add hyperlinks

Yes

Yes

Sort and filter data

Yes

Yes

Refresh existing data connections

Yes

Yes

Print

Yes

Yes

Find

Yes

Yes

Replace

No

Yes

View 3D charts

Yes

Yes

Slicer viewing

Yes

Yes

Save or Download a copy

Yes

Yes

Share

Yes

Yes

Real-time co-authoring

Yes

No

Embed Workbook on Web or Blog Page (OneDrive)

Yes

No

Surveys

Yes

No

Offline viewing and authoring

No

Yes

Freeze panes

No1

Yes

Apply conditional formatting

No

Yes

Comment creation

Yes

Yes

Recommended chart creation and editing with formatting controls

No

Yes

Advanced time filtering (Timeline slicer)

No

Yes

Create external data connections

No

Yes

What if analysis tools

No

Yes

Creation of advanced analysis views (((Power View, PowerPivot, Slicers)

No

Yes

Chart animations adapt to new data

No

Yes

Apply data validation to cells

No

Yes

Rights Management: IRM and password security

Yes

Yes

Apply smart/recommended formatting

No

Yes

PowerPivot viewing

Yes

Yes

Power View viewing

Yes

Yes

Post to Social network and present online

No

Yes

Spreadsheet audit and compliance

No

Yes

Apps for Office

Yes

Yes

VBA and macro scripting

Yes2

Yes

Tell Me

Yes

No

NoteNote:
1   You can view freeze panes created using Excel 2013 desktop app, but you cannot create freeze panes in Excel Online.
2   In Excel Online, you cannot create macros with VBA, but you can open and edit VBA-enabled spreadsheets without removing (or corrupting) the VBA contained in the file.
NoteNote:
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 the document (edit mode), you’ll need to click Edit in browser or Open in <app name>. To edit the document, you’ll need an Office desktop suite license, such as an Office 365 ProPlus subscription license or an Office Professional Plus 2013 license.

 

Excel workbooks created in Excel 97 or later

View mode

Edit mode

Full support (.xlsx, .xlsb)

Yes

Yes

Binary (.xls)

No

No

Macro (.xlsm)

Yes1

Yes2

OpenDocument (.ods)

Yes

Yes

NoteNote:
1 Macros are not run.
2 If macros exist, users are prompted to have a copy of the file with the macros removed.
NoteNote:
Newer file formats (such as .docx, .xlsl, and .pptx) can be created in Office 2013, 2010, or 2007, or in Office 2000 and later with the compatibility pack

If you have comments or questions about this topic, we'd love to hear from you. Just send your feedback to Office 365 Service Description Feedback. Your comments will help us provide the most accurate and concise content.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft