Hi Insiders and greetings from the Excel team!

Excel 2016 includes a powerful set of tools called Get & Transform. These tools, which are based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources. We introduced these tools in the initial release of Excel 2016. If you are new to Get & Transform, see this tutorial which will guide you through the basics.

Today we are glad to launch the early preview of the new data import and shaping functionality in Excel – the unified Get & Transform experience. In this release, we enhanced the data import experience and rearranged the ribbon so that it’s easier than ever to take a full advantage of the powerful Get & Transform capabilities.

Watch Doug from Office and Guy who is a Program Manager in the Excel team for a sneak preview of the new experience:

We are looking for Excel users to check out the new functionality and share the feedback with us! For more details, refer to this support article which will introduce you to the full scope of changes in this release.

How does the preview work?

The preview is open for Fast Insiders only starting from Office build 16.0.7914.1000 and later. If you’re not a Fast Insider and want to become one, we’d love to have you!

  • If you’re on the Office Insider Slow level, click File > Account > Office Insider > Change Level to switch to Fast.
  • If you’re not yet an Insider, click File > Account > Office Insider > Join Office Insider.

We'd love your feedback on a couple scenarios

We encourage you to prepare your regular business reports and data analysis using the new data import, shape and combine capabilities.

  • Import data from your favorite sources using one of the many modern connectors available under the Get & Transform Data section on the Data tab of the ribbon.

  • Manage your existing workbook queries and legacy connections via the dedicated side pane opened by clicking onData > Queries & Connections button.

  • Load data to Query Tables, PivotTables, PivotCharts or just create a connection via the new Import Data dialog for queries. Invoke one of the Get & Transform connectors, select the data that you want to import, observe the data preview in the Navigator dialog, click on the arrow next to the Load button and choose Load To.

  • Share queries between your workbooks and with others in your organization by exporting/importing the query to/from the Office Database Connection (ODC) files.

How do I send feedback?

You can send in your feedback in the following ways:

  • Post your questions under this announcement, where the Excel team will review it and respond to your inquiries.
  • Send us a Smile, a Frown or just a suggestion via File > Feedback option and specify Get & Transform keyword in the first line.

We look forward to your feedback!

Excel Product Team
February 2017

Source: https://answers.microsoft.com/en-us/...5-ffdf8bd117af