Text/CSV data extraction using examples

Important

This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, marketers, or analysts, automatically Sep 20, 2021 -

Business value

Users can seamlessly extract sample values for data from text and CSV files with the new option to Extract Table Using Examples.

Feature details

When using the Text/CSV connector in Power Query Online, you'll see a new option to Extract Table Using Examples in the lower-left corner of the file preview dialog. Upon selecting this option, you'll be taken to the Extract Table Using Examples experience, where you can specify sample output values for the data you'd like to extract from your text or CSV file.

For more information about this capability in Power Query Desktop, go to Text/CSV by Example.

See also

Text/CSV by Example (docs)