50+ ready-to-use Power Query (M language) templates for data transformation, API connections, file consolidation, and automated reporting workflows. Each template includes the complete M code plus usa
Browse the actual product documentation and code examples included in this toolkit.
Key features of Excel Power Query M Code Templates
• Data Transformation (10 templates) — Unpivot, pivot, split, merge, conditional columns • API & Web Connections (8 templates) — REST APIs, pagination, OAuth, web scraping • File Consolidation (7 templates) — Combine CSVs, Excel files, folder contents • Pivot & Unpivot (6 templates) — Reshape data between wide and long formats • Date Tables (5 templates) — Calendar generation, fiscal years, holidays • Fuzzy Matching (4 templates) — Approximate joins, deduplication
Data Transformation (10 templates) — Unpivot, pivot, split, merge, conditional columns
API & Web Connections (8 templates) — REST APIs, pagination, OAuth, web scraping
File Consolidation (7 templates) — Combine CSVs, Excel files, folder contents
Pivot & Unpivot (6 templates) — Reshape data between wide and long formats
Date Tables (5 templates) — Calendar generation, fiscal years, holidays
Fuzzy Matching (4 templates) — Approximate joins, deduplication
Configure Excel Power Query M Code Templates parameters to see how the product works.