Excel for the web

Excel for the web is Excel, but in your web browser. You can access it from any device, anywhere. And better yet, it's free for your personal use! (If you need to use it for a business, you can access it with a Microsoft 365 subscription.)

With new features constantly being released, Excel for the web is quickly becoming as powerful as its desktop equivalent.

  • Create spreadsheets and share them with your peers at work and school. Collaborate with others in real time while communicating via built-in comments and chat.

  • Organize & analyze your data just like you do in the Excel desktop app. Turn columns of numbers into valuable insights by building PivotTables, modern charts and smart tools. 

  • Create surveys and polls , and watch the results fill your Excel workbook automatically. Then, analyze the results in all-familiar Excel ways. All without ever leaving your browser!

Just released

Table Reflow

Tables designed to fit your needs

Excel is now smarter at formatting the size and shape of your tables to make it easier to read without having to reformat them right away.

Data Validation Message

Get improved error messages when an entry falls outside the Data Validation rules for a cell.

Formula Library

Easily choose functions and formulas from the detailed Function library on the Formulas menu.

LEARN MORE

Right Click PivotTable

Sort and filter your PivotTables using the right-click menu

PivotTable Fields

Enjoy a new interface for managing your PivotTables

LEARN MORE

Slicers

Create slicers for PivotTables to filter data the way you want

LEARN MORE

PivotTable Filter Menu

Refining PivotTables is easier with the new filter menu

Phonetic Text

Japanese language customers can see phonetic text.

Upload to Sharepoint

Open and edit files up to 100 MB from SharePoint

Open Password Protected File in XLO

Files that have been password protected on the desktop can now be edited in Excel for the Web

SmartArt

Open and edit files containing SmartArt objects.

Conditional Formatting

Add or edit rules from the new modern Conditional Formatting task pane

Text in Shape

Add text to shapes

Link to comment

Create and share a link directly to a comment

Add Dataset from PowerBI

Find new insights in your data by creating a PivotTable from Power BI Datasets.

Stocks Update

Stocks in your workbook will refresh each time you open the file and again every five minutes

XLO Offline

Continue to read and scroll through your workbook even if your internet connection is down.

Upload to Sharepoint

Open and edit files up to 100 MB from SharePoint

Open Password Protected File in XLO

Files that have been password protected on the desktop can now be edited in Excel for the Web

SmartArt

Open and edit files containing SmartArt objects.

Conditional Formatting

Add or edit rules from the new modern Conditional Formatting task pane

Text in Shape

Add text to shapes

Link to comment

Create and share a link directly to a comment

Add Dataset from PowerBI

Find new insights in your data by creating a PivotTable from Power BI Datasets.

Stocks in your workbook will refresh each time you open the file and again every five minutes

XLO Offline

Continue to read and scroll through your workbook even if your internet connection is down.

We released these Excel for the web features during 2021.

Right to Left

Flip your workbook to work from right to left by clicking on the button on the Page Layout ribbon.

Sensitivity label

Classify and protect your documents with labels that can add watermarks, headers, or footers.

Check Accessibility

Find all of the tools you need to create accessible content with the Accessibility Checker.

Organize Data

Get Organization Data from Power BI using Excel Data Types

Custom Color Picker

Give your workbook even more colors even more colors with the new custom color picker.

Show Changes Menu Option

Excel can now show you the changes made to the cells in your workbook including the previous value of the cells.

Paste Options

Get all the Paste Options right where you paste your content.

Excel Scripting

Automate your repetitive tasks with Office Scripts in Excel for the web

Linked Data Types

New linked data types bring you facts and data on hundreds of subjects.

Search Dropdown

You can now search values within Data Validation dropdown lists.

Workbook Link

Excel for the web now supports refreshable connections to other workbooks.

Show Formula

Switch between the display of formulas and their results.

Resize Table dialog

Resize a table by selecting a new range.

First screen of the Text to Columns Wizard

Split text across columns using the Convert Text to Columns Wizard.

The Slicer Settings pane

Adjust a slicer using the Slicer Settings pane. Select the slicer, then select Slicer > Settings.

          The All Sheets menu, opened

Quickly pick any sheet from the All Sheets menu - no horizontal scrolling.

          LET function

Use the LET function to create named variables in formulas.

Regional Settings button

Adjust the format you see for dates, currency and more using the regional format settings.

We released these Excel for the web features during 2020.

Renaming a table using the ribbon

Rename an Excel table

Easily replace the default names Excel gives your tables with more meaningful names.

          Simplified ribbon

The new look of Office

Excel for the web gets the simplified ribbon.

          Touch-based menu in Excel for the web


Touch-based menu in Excel for the web   

New touch-based menu lets you perform basic Excel tasks with a finger.

Comment thread inline instead of in the Comments Task Pane

Insert comments right in the grid

Comments now work like they do in desktop Excel, except that in Excel for the web, you can also use the Comments Task Pane to review all comments in the workbook.

Using an at-mention in a comment

Use @mention in comments to tag someone for feedback

An @mention alerts the person and gives them an easy way to provide input in the comment thread.

Totals Row drop-down showing aggregate function options

Set the function for a Totals Row cell

Select the aggregate function used by the Totals row.

Discontinuous ranges selected in Excel for the web

Discontinuous selections   

Select discontinuous ranges and apply all kinds of operations on the selection. 

Email sent via @mention from Excel for the web

Read and reply on the fly   

Respond to comments and @mentions made in Excel right from email without opening the workbook.

The Settings button on the PivotTable tab in Excel for the web

PivotTable Settings

Use the PivotTable Settings pane to make changes to your PivotTable's layout and formatting.

Manage Conditional Formatting Rules in Excel for the web

Manage conditional formatting rules

Manage conditional formatting rules in the Conditional Formatting side pane.

Cell Styles button on the ribbon in Excel for the web

Cell Style Gallery

Choose from a wide selection of styles in the Cell Style Gallery.

Version History pane in Excel for the web

View and restore previous versions of a workbook

Now you can view and restore the versions of a workbook stored on OneDrive. You can even review the exact changes made between the various versions.

New Window command on the ribbon in Excel for the web

Open multiple windows for one workbook

Need to compare two worksheets in the same workbook? Open a new window for the workbook and the task becomes easy.

Calculation Mode menu in Excel for the web

Switch between Automatic and Manual calculation modes

How do you want your formulas to behave? Set the calculation mode to take control.

Context menu of PivotTable slicer in Excel for the web

Delete PivotTable Slicers

In addition to using them, you can now delete PivotTable Slicers that were added in a desktop version of Excel.

Workbook Statistics dialog box

Workbook Statistics

The Workbook Statistics feature counts and identifies elements of a workbook, helping you discover all its content. You'll find it on the Review tab of the ribbon.

XLOOKUP example on a worksheet

XLOOKUP function and XMATCH function

New lookup functions let you perform lookups in any direction - left, right, up, or down.

FILTER function spilling on a worksheet

Dynamic array formulas

Dynamic array formulas work like regular formulas, but produce arrays that automatically spill into adjacent cells as needed - no need to select the range the result will occupy, and no need to press CTRL+ALT+Enter to enter the array formula.

Sort by icon set

Sort by color or icon   

Sort conditionally-formatted data that uses icon sets or color scales by using their icons or color values.

View Mode menu on the single-line ribbon

Easier to start editing   

Easily switch between viewing and editing when working in Excel for the web. If you're using the Single-Line ribbon the command is always visible on the top level; otherwise just look on the View tab in the Document Views group for the commands.

The New button in the Sheet Views group

Sheet Views

Create customized views in an Excel worksheet without disrupting others.

XLO Table Style options

Table Style Gallery and Options

Enjoy new table formatting options, including a style gallery.

FILTER function in Excel for the web

New array functions

Excel for the web now includes six new functions to supercharge your spreadsheets: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE and RANDARRAY.

Excel for the web with pasted hyperlink

Paste hyperlinks from outside Excel

Using Edge or Chrome as your browser, you can copy hyperlinks from other apps and paste them into Excel for the web. The pasted hyperlinks will function normally.

  

The following Excel for the web features were released during 2019.

Excel for the web with pasted hyperlink

Paste hyperlinks from outside Excel

Using Edge or Chrome as your browser, you can copy hyperlinks from other apps and paste them into Excel for the web. The pasted hyperlinks will function normally.

Apply document sensitivity labels in Excel from Home > Sensitivity

Classify documents and protect access to sensitive data

With Microsoft 365, users can maintain control of access and sensitivity of their documents by manually applying a label or using the automatically recommended labels from Microsoft.

Keyboard Shortcuts dialog box in Excel for the web

Control keyboard shortcuts in Excel for the web

You can control keyboard shortcuts so they work the same in both versions of Excel by changing the Keyboard Shortcuts settings - you can even override browser shortcuts. Just click Help > Keyboard Shortcuts.

Find dialog box with Find All option

Find All

Find and highlight every instance of your search term. Just press Ctrl+F, enter your search term, then select Find All.

Sort left-to-right command

Sort left-to-right

For data in a range, you can now sort from left-to-right. If your data is in a table, you'll need to convert it to a range first.

Presence indicators in an open workbook with coauthors

Improved Presence information when co-authoring

Improved Presence information makes it easier to see who else is working on a workbook, what they have selected, and whether they are currently editing.

Resolve a comment thread

Resolve comment threads

Resolve a comment thread to show the issue has been addressed but leave the comments in place. You can reopen a resolved thread if needed.

Image of the Spell Check pane in Excel for the web

Spell Check

To check spelling for any text on your worksheet, click Review > Proofing > Spelling.

Image of the Ideas pane in Excel for the web

Ideas in Excel Online

Ideas in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Ideas button on the Home tab. Ideas in Excel will analyze your data, and return interesting visuals about it in a task pane.

Image of Stock and Geography data types in Excel for the Web

New Data Types – Stocks and Geography

You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are new, and they are considered linked data types because they have a connection to an online data source. That connection allows you to bring back rich, interesting information that you can work with and refresh.

Image of a table with Blue, Table Style, Medium 2 converted to a range and maintaining table formatting

Convert an Excel table to a range

After you create an Excel table, you may only want the table style without the table functionality. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet.

Spreadsheet with pivot table and graph

Insert a PivotChart

Now you can insert PivotCharts in addition to PivotTables.

Paste transpose option on Paste menu

Paste Transpose

Switch row-based data to columns and vice versa.

Add Border Colors in Excel for the web

Apply colors & styles to cell borders

Tired of boring, black borders? Now you can make them stand out with colors & styles.

Custom Sort in Excel for the Web from Data > Sort & Filter.

Sort by multiple columns or rows

Sorting by multiple levels just got a whole lot easier.

Remove duplicates in Excel Online from Data > Data Tools > Remove Duplicates.

Remove duplicate values

Quickly and easily remove duplicate values from your data.

Apply row and column Outline levels in Excel for the Web from Data Group/Ungroup.

Outline (Group/Ungroup) rows/columns

Create an outline of up to eight levels, one for each group. 

Mentions and Comments

@Mentions and Comments

Add editable comments to cells, and call out people with @Mentions.

Image of applying an Inside Border to a cell range from Home > Font > Borders.

Draw Inside Borders

Quickly add a border around cells or ranges of cells.

Right-click any cell to display your Cut/Copy/Paste options in Excel for the Web.

Paste options from the context menu

Right-click on any cell to display your Cut/Copy/Paste options.

For a thorough description of the current feature set of Excel for the web, see Excel for the web.

Roadmap of what's to come

The following features are being considered or are currently being developed for Excel for the web. Although we list them here, we can't guarantee when they'll be available.

Search in Filter by value

Get help with your formulas as you write them

Reorder conditional formatting rules with drag & drop

Improved formulas menu with function library

Improved filter menu with item filter list

Auto filter menu improvements

Get more control over the print area and page breaks of your workbooks

Resize the formula bar

Add and edit using rich text formatting

Templates, to get you started

Take a tour

Take a Tour

Template: Family Budget

Family Budget

Template: Task List

Track My Tasks

More Excel templates here

Tutorials

Learning Excel for the web

Learning Excel for the web

Office for the web Essential Training

Office Online essential training

Suggest a Feature

Now you can influence Excel for the web! You can suggest new features for the upcoming versions of Excel for the web by clicking Help > Feedback > I have a suggestion.

Features developed from customer feedback.

More Resources

Report an Issue

Have a problem with Excel for the web? Got an idea about changes you would love to see? Or just want to share what you like? Tell us what you think, and give us your feedback about anything. We're waiting to hear from you and willing to help with any issue.

Click on HELP IMPROVE OFFICE at the bottom left corner and you'll be able to tell us what you think.

Help Improve Office

We do read your feedback, and we'll make every effort to act on it.

For Developers

Please follow this link for an overview of how to get started with Office Development.

If you want to develop add-ins that will work for Excel for the web and other Excel endpoints (cross-platform), please follow Office Add-ins platform overview and Develop Excel add-in.

If you want to create scripts that would operate on Excel workbooks stored in the cloud, please use our Graph Service (REST APIs). Make sure to check out the Excel-specific stuff..

You can also view and influence the extensibility roadmap. We encourage you to review and comment on the new and planned APIs.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×