How can you list ALL the files on your computer in a single list that you can sort and or edit using Excel and that includes file size and location etc?

Answer 1

To list all files on your computer for use in Excel, you can use the Command Prompt (Windows) or Terminal (Mac). For Windows, open Command Prompt and navigate to the desired directory, then run the command dir /s /b > file_list.txt, which generates a text file with all file paths. For Mac, you can use find /path/to/directory -type f > file_list.txt. After generating the text file, you can open it in Excel, where you can sort, edit, and include additional details like file size and location by using formulas or additional commands to extract that information.