Smart data extraction from text and CSV files in Power Query Desktop

  • 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. Aug 12, 2020 -

Feature details

Text/CSV by example will become available within Power Query Desktop. This feature allows users to extract data from semi-structured text and CSV files by providing sample output values based on file contents from which Power Query will infer the extraction rules. The overall user paradigm for this feature is similar to Web by example. You can read more about Web by example here.

See also

Smart data extraction from text and CSV files in Power Query Desktop (blog)

Text/CSV by Example preview (docs)