In this post we’ll take a look at how to import an XML file into Excel and turn it into a more human readable table format. Excel has support for XML files and it’s actually really easy to import and covert them to tables using Power Query

Learn how to add grouped serial numbers to your data using Power Query.

This post will show you how to import the metadata from a CSV file into our report data with power query (also called Get & Transform).

Use power query to transform a single column into a table.

It's a task I've had to do before. Get a list of all the sheet names in a...