Export Directory Listing to Excel

Status
Not open for further replies.

tuant

Posts: 197   +0
Hello

I'm wondering if anyone out here knows how to export a directory into a spreadsheet which are separated by columns. I need to be able to have the filename in one column and file size in another column. I'm familiar with dir /s > c:\sample.xls (and other extensions) however this put everything into one single column. Is there a switch that will separate the fields into different columns?

thank you
 
As far as i Know you can't do that, and even the dir /s > sample.xls actually results in a txt file with xls extension ... nothing more. However, you can import a text file in excel and if i remember correctly there was way a to import text file in such a way that you could place data in separate columns according to your needs .... I will look into it (once i finish watching Top Gear Series 14 ;)), and see how i did, but please remember I never did this in last what 12-13 years !!
 
I was able to achieve what I needed by using Excel's Text Import Wizard.

Thank you for responding... enjoy watching Top Gear!!!
 
Status
Not open for further replies.
Back