This post is a menu-by-menu comparison of Excel Online, available through an Office 365 subscription, compared to features available in Google Sheets online. Any discrepancies are documented here, and features available in both Apps are not called out. On the following screens, the first image or image group listed will always be a screen shot of Excel Online, the second image will be Google Sheets. This blog shows and explains the differences in the two applications through the browser, and does not cover desktop features. Excel screenshots were captured using Internet Explorer 11, and Google Sheets screenshots were captured using Google Chrome. Included with Office 365 subscriptions is a desktop version of Office, these features that are not in Excel Online but are available in Excel on the desktop are listed at the end of this document. Google Sheets is online only, with limited offline availability through the Chrome browser.

This post is a snapshot of available features as of July 29, 2015. Features and options can change in the future.

Microsoft Office 365: https://products.office.com/en-us/products
Google Sheets: https://sheets.google.com/

Initial screens for Excel and Sheets

Excel Online has official templates built-in and available to download directly from Microsoft. Sheets doesn’t have templates built-in, they have a location to download from google.com, which include many templates that are created by others outside of Google. Sheets templates are found from the File menu > New > From template option, which opens another browser window to browse the directory. Excel’s official templates are built-into the initial screen.

Excel Online

Google Sheets

New Workbook screen comparison

Excel Online

Google Sheets

Formatting Options

Excel Online has one additional number formatting option not found in Google Sheets, Fraction. Google Sheets has Date time and Duration options not found in Excel Online. Excel Online has a Double Underline option, not available in Google Sheets. Google Sheets only has 6 font options available for formatting. Word Online has about 50 different fonts to choose from. Word Online also has an option to Format as a Table.

Excel Online

Google Sheets

Survey & Forms

Excel has a Survey feature to add a survey to a worksheet. Surveys let other people fill out your list—like a sign-up sheet or questionnaire—where you can see it all in one place online. In OneDrive and OneDrive for Business, you can create a survey that others fill out just by opening the link you provide. You’ll see everyone’s response compiled in one online spreadsheet. Sheets has a Form feature to add a form to the worksheet. The Form in Google Sheets can be embedded into a webpage. The Word Online Survey can be shared via a link.

 Excel Online

 

Google Sheets

Notes

Google Sheets has an option to add a Note in addition to a Comment. Excel Online has a Comment feature, but the Note feature is not available.

Google Sheets

Viewing Modes & Sharing

Sheets has one viewing mode. Excel has Editing View and Reading View. Google Sheets has a feature to email the worksheet or a link to collaborators to edit, comment, or view. Excel also has a feature to share via link or email, with the options for others to edit or view the workbook.

Excel Online

Google Sheets

Charts

Excel offers a standard collection of charts to use. Sheets offers similar variety with the basic types represented in both Apps. Excel Online has 2 additional Radar charts not found in Sheets, and Sheets has a few additional charts such as Maps, Timeline, Gauge, Motion, Candlestick, Organizational, and Tree.

Excel Online

Google Sheets

Pivot Table

Sheets has the option to add a Pivot Table. Excel Online does not have the capability to do this, however, Excel Online can open a worksheet with a Pivot Table and view the Pivot Table.

Google Sheets

 

Refresh Connections & Calculations

Excel Online has an option to refresh external connections on the DATA tab of the ribbon. Refresh Selected Connection and Refresh All Connections are the two available options. Also available on this tab is the option to Calculate Workbook.

Excel Online

Protect the Workbook

Sheets has the option to protect sheets and ranges in the workbook. This is currently not possible in Excel Online.

Google Sheets

Additional Tools

Sheets has external links to their Script gallery and Script editor. These are add-ons are found in the add-on store and are not available by default, however they have links on the Tools menu built-in. Google Sheets also has a Personal dictionary feature.

Google Sheets

Insert Drawing

Google Sheets incorporates their Drawing feature in Sheets. A similar feature is not currently available from Excel Online.

Google Sheets

Add-ins & Add-ons

Both Sheets and Excel have Add-ons and Add-ins to extend the functionality of their Apps. As of the time of writing, it appears Office Add-ins is down for maintenance. This is an available feature. Sheets Add-ons are more frequently used than compared to Excel and have a much larger library of available downloads. Sheets Add-ons are developed externally, by sources outside of Google.

Excel Online

Google Sheets

Differences between using a workbook in the browser and in Excel

Office Web Apps enables you to use a workbook in a browser window.

When you are viewing a workbook in a browser window, can typically use certain features, such as the ability to print and interact with items, similar to how you would use those features in Excel. However, there are some differences between using a workbook in a browser window and in Excel.

Workbook file formats that are supported in a browser window

Workbooks in any of the following file formats can be viewed in a browser window:

  • Excel workbook (.xlsx)
  • Excel binary workbook file (xlsb)
  • OpenDocument Spreadsheet file (.ods)
  • Excel macro-enabled workbook (.xlsm)
    A workbook in this format can be opened but macros do not run in a browser window.
  • Excel 97- Excel 2003 Workbook (.xls) or Excel 97- Excel 2003 Template (.xlt)
    If a workbook is in .xls or .xlt format, you can typically view but not edit a workbook in a browser window. When the file is edited, it is saved in .xlsx or .xltx format.

Workbooks in other formats, such as .csv format, are generally not supported for viewing in a browser window.

Workbook features that are supported for viewing in a browser window

When you view or print a workbook in a browser window, some features might work differently, as summarized in the following table.

This feature Works like this in a browser window
Calculations Calculations and calculation settings, including automatic, manual, and iterative calculation settings for ranges or worksheets work in a browser window similar to how they do in Excel.
Cells Cells, including cell values, merged cells, and cell content overview, are displayed in a browser window similar to how they are displayed in Excel.
Charts and tables, including PivotChart reports and PivotTable reports In general, charts, tables, PivotChart reports, and PivotTable reports are displayed in a browser window similar to how they are displayed in Excel. Exceptions include

  • Charts that are part of a group of charts
  • Charts that rely on external references
  • Charts that use certain kinds of data sources that are not supported for workbooks viewed in a browser window

If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint to Excel Web App.

Data connections Depending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in a browser window, which enables you to refresh data. For more information, see Refreshing data in a workbook in a browser window.
Dates Dates are displayed in a browser window similar to how they are displayed in Excel.
External references The last known value for an external reference is displayed in a browser window. External references must be updated using Excel.
Fields list for a PivotChart report or a PivotTable report In general, the Fields List for a PivotChart report or a PivotTable report works in a browser window similar to how it works in Excel. This means that people can use the Fields List to explore information and change the data that is displayed in a PivotChart report or PivotTable report.
Filters, slicers, and timeline controls Filters and slicers generally work in a browser window similar to how they work in Excel. In general, timeline controls work in a browser window similar to how they work in Excel.If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint to Excel Web App.
Formatting Cell and cell-range formatting and number formats display in a browser window similar to how they are displayed in Excel.
Functions Most Excel functions work in a browser window as they do in Excel. Exceptions are listed in the Workbook functions section of this article.
Line borders Most, but not all, line borders are displayed in a browser window as they are displayed in Excel. Line colors, continuous- and double-line styles, solid and dashed lines, and lines using thin, medium, and thick line weights are supported.
Named items Named items, such as ranges, tables, charts, PivotChart reports, PivotTable reports, slicers, and timeline controls are generally displayed in a browser window similar to how they are displayed in Excel.If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. For more information, see Comparing Excel Services in SharePoint to Excel Web App.
Sparklines Sparklines display in a browser window similar to how they are displayed in Excel.
Tables Excel tables, including data, column headers, and total rows are displayed in a browser window similar to how they are displayed in Excel.

 

Workbook features that can differ between the browser and the desktop

Some features work differently in a browser window than they do in Excel. In addition, some workbook features can prevent a workbook from being viewed in a browser window.

Tip    If you cannot view a workbook in a browser window because it contains unsupported features, try opening the workbook in Excel.

This feature Works like this in a browser window
Controls Controls, such as ActiveX controls and form toolbar controls, prevent a workbook from being viewed in a browser window.
Data connections Depending on how your environment is configured, some kinds of data connections can prevent a workbook from being displayed in a browser window. For more information, see Refreshing data in a workbook in a browser window.
Data validation Workbooks that use data validation can be edited in a browser window, but data validation cannot be set up in the browser.
Digital signatures Workbooks that use visible or invisible digital signatures cannot be viewed in a browser window.
Fonts Fonts are usually displayed using the same style and size in a browser as they are displayed in Excel. If a workbook uses a specific font that is not available on your device, then another font might be substituted when a workbook is displayed in a browser window.
Functions Some kinds of functions can behave differently in a browser window than they do in Excel. For more information, see the Functions section later in this article.
Legacy macro languages Workbooks that contain legacy macro features, such as Microsoft Excel 4.0 Macro Functions and Microsoft 5.0 dialog sheets cannot be displayed in a browser window.
Save When you or other people edit a workbook in a browser window, changes are saved automatically.
Security and privacy Workbooks that have Information Rights Management (IRM) settings applied at the workbook level cannot be viewed in a browser window.If your organization is using Excel Web App (on premises) or Excel Online (in the cloud) to display workbooks, then workbooks that are saved in IRM-protected document libraries are supported and can be displayed in a browser window.Workbooks that are sent as IRM-protected attachments in Outlook Web App are also supported and can be displayed in a browser window.

However, if your organization is using Excel Services in SharePoint Server (on premises) to display workbooks, workbooks in IRM-protected libraries are not supported, and must be opened in Excel.

IRM cannot be applied in the browser.

Shapes Workbooks that contain shapes cannot be edited in a browser window.
Undo and Redo When a workbook is edited by more than one person at a time, the Undo and Redo commands are not available in a browser window as soon as another user makes a change.
Worksheet protection or workbook protection Workbooks that are protected (encrypted with password protection) cannot be viewed in a browser window.Protected worksheets (not entire workbooks) can be viewed in a browser window in Excel Online.In an on-premises environment where you’re using Excel Services or Excel Web App, protected worksheets cannot be viewed in a browser window.

To remove protection, open the workbook in the Excel.

XML XML maps, XML embedded smart tags, and XML expansion packs prevent a workbook from being viewed in a browser window.

 

Workbook functions in Excel and in a browser window

Some workbook functions behave differently in a browser window than they do in Excel. The following table summarizes how some functions work in Excel and in a workbook viewed in a browser window.

This function Works like this in Excel Works like this in a browser window
CHAR Returns a character specified by a number. For non-printing characters, returns a block character. Returns a character specified by a number. For non-printing characters, returns blank values.
HYPERLINK Returns an active link that you can click and follow Depending on the Workbook Interactivity and Workbook Navigation settings that are specified for a workbook, the HYPERLINK function can return an active link or an inactive link text string.
INFO Returns the path of the current directory or folder on the computer. Returns a #VALUE! error.
NOW Returns the date and time on your computer Returns the date and time on the server
RAND, RANDBETWEEN Returns a random number each time it is used Returns a random number each time it is used
RTD (real-time data) Returns real-time data from a program that supports COM automation. If values that have been returned by an RTD function are stored in a workbook, those values are displayed. If no values are stored in the workbook, a #N/A error is returned.
TODAY Returns the date on your computer Returns the date on the server

Let's talk.