I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...

Instead of manually copying and pasting data from each file, Power Query enables you to extract, transform, and combine information from multiple Excel files into a single, unified dataset.

I've got a huge list of folders on an archival drive I need to get into a spreadsheet in OS X, along with the info about their dates and sizes. I know the folder names are a simple copy/paste, but ...

Learn how to import or export data from a Text file to convert a Text (.txt or .csv) file into an Excel (.xlsx) spreadsheet easily using this procedure.