What’s new in Excel 2016 for Windows

As an Office 365 subscriber, you regularly get new and improved Office 2016 features. Take a look below to see what’s available to you today.
Office 365 subscribers Office Insiders

Latest updates for Excel for Windows Desktop

See what’s new and improved in the May 2017 feature update, Version 1705 (Build 8201.2075).
Find your Office version.

Enhanced data import functionality

Easily import and shape data from various sources. Manage workbook queries and connection with the Queries & Connection side pane, and share queries with others via ODC files.


Get & Transform Queries & Connections pane

New data transformation: Add Column From Examples

Shows Column From Examples button on the Query Editor Add Columms tabIn the Query Editor, create a new column by providing sample values. As you type, Excel detects the required transformations and shows a preview of the new column.


Keep the copy

Small table showing a copied cellWe listened to your feedback! With this update you can copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.

Azure Marketplace icon Important: As of March 31, 2017, data services are no longer available from Azure Marketplace. Please reach out to your service provider for options if you want to continue service.

Want new features first?

Become an Office Insider and you’ll be first in line to see new features and tell us what you think.


Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.