▦ Sheetly

Sheetly · hands-on reference

Power Query Workbench

Find a transformation, inspect a small worked example, and copy the M code into Excel Power Query. Every recipe includes sample CSV data you can download.

11 practical recipesCopyable M codeInput and expected output CSVs

Browse and build

Worked transformations

M language reference ↗
About these examples

The displayed output is the expected result for the downloadable sample data. The code runs in Excel Power Query; this page does not execute M in your browser. Check field names and data types before applying a recipe to your own data.