Automatic table detection from Excel files

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Sep 20, 2020 -

Feature details

When using the Excel connector, this new feature will automatically identify sections of each Excel spreadsheet to extract into a table and show them under a Suggested Tables group in the Navigator, as shown in the first screenshot below. Previously, unless data was formatted as Tables or Named Ranges in Excel, users had to scrape the relevant rows or columns with specific transforms (such as skip rows and remove columns) from worksheet objects, as shown in the second screenshot below.

Smart suggestions are offered to users with automatically detected tables.

Excel connector results before this feature.

See also

Power Query Excel connector (docs)