Resources

How to get a list of file names in Excel

How to get a list of file names in Excel

Tracking and managing data across multiple files can be challenging. With Power Query, you can get the file names from a specific folder and all its sub-folders. In this article, we are going to show you how to get a list of file names in Excel. [button...

How to import XML files into Excel

How to import XML files into Excel

XML is a common file type for storing and transferring data. In this article, we are going to show you how to import XML files into Excel using two methods: First is a more "direct method" and the other is the Power Query approach. [button...

Converter Template

Converter Template

Unit conversion can be tricky, especially when dealing with some scientific units such as velocity, or energy. This Excel template was built to make conversions simple and easy to understand. One of the biggest advantages of using an Excel tool for unit conversion is...