TechSpot

Export Directory Listing to Excel

By tuant
Jan 18, 2010
  1. 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
     
  2. Archean

    Archean TechSpot Paladin Posts: 5,682   +86

    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 !!
     
  3. tuant

    tuant TS Booster Topic Starter Posts: 201

    I was able to achieve what I needed by using Excel's Text Import Wizard.

    Thank you for responding... enjoy watching Top Gear!!!
     
  4. Archean

    Archean TechSpot Paladin Posts: 5,682   +86

    Glad you were able to :) have fun & thanks
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...