Skip to main content
Skip to main content
Microsoft 365

May 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce three new data transformation and connectivity features that have been requested by many customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.

These updates include the following new or improved data connectivity and transformation features:

  • Split Column by Delimiter—automatic detection of delimiter character
  • Combine Files—ability to select sample file to use
  • DB2 Connector—option to specify Package Collection

Split Column by Delimiter—automatic detection of delimiter character

When splitting column by delimiter inside Query Editor via Home > Split Column, Excel will automatically detect and populate the Delimiter field in this dialog, based on text pattern detection in the data preview rows. Note that you can still change the delimiter if needed, but this automatic detection saves a few clicks in many cases.

Combine Files—ability to select sample file to use

This month, we continue making incremental enhancements to the Combine Files experience. One of the common areas of recent feedback has been to add the ability to select a file from a folder to use as the sample file to select objects and specify any custom transformation steps (if needed).

With this release, we added a new control in the file preview dialog to allow you to choose a file available in the selected folder. The default selection is the first file found—however, this can now be easily customized by users.

DB2 connector—option to specify Package Collection

The DB2 connector window now includes an option to specify the package collection to connect to within a given DB2 server. This new option, available under the Advanced Options section in the DB2 connector dialog, can only be used with the Microsoft IBM DB2 driver.

Learn more

—The Excel team

You may also like these articles

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…