Overclock.net › Forums › Software, Programming and Coding › Operating Systems › Windows › Way to export filenames to excel?
New Posts  All Forums:Forum Nav:

Way to export filenames to excel?

post #1 of 11
Thread Starter 
I have a folder with a bunch of files in them and I want to be able to put the filenames into excel. Is there anyway to do this?

Thanks
    
CPUMotherboardGraphicsRAM
X2 5000+ BE Gigabyte GA-MA78GM-S2H AM2+ Integrated HD3200 2x2GB OCZ DDR2 
Hard DriveMonitorPowerCase
Maxtor 40GB Samsung 2220WM 22" Antec Neo HE 550W Ultra Wizard 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
X2 5000+ BE Gigabyte GA-MA78GM-S2H AM2+ Integrated HD3200 2x2GB OCZ DDR2 
Hard DriveMonitorPowerCase
Maxtor 40GB Samsung 2220WM 22" Antec Neo HE 550W Ultra Wizard 
  hide details  
Reply
post #2 of 11
open command prompt
cd to directory containing files
dir /B > file.csv
open csv file in excel

add a /S after the /B if you want to recurse subdirectories
Edited by cgd - 5/28/08 at 12:14pm
My new system
(13 items)
 
  
CPUMotherboardGraphicsRAM
3930K Asus P9X79 HD 7850 Samsung 
Hard DriveHard DriveHard DriveOptical Drive
Vertex 4  Samsung 830 Spinpoint F3 Some DVD I had laying around. 
CoolingOSMonitorPower
XSPC Raystorm EX240 w/ D5 W7 Pro 64 Samsung 23" Seasonic 650x 
Case
Fractal Design Arc Midi 
  hide details  
Reply
My new system
(13 items)
 
  
CPUMotherboardGraphicsRAM
3930K Asus P9X79 HD 7850 Samsung 
Hard DriveHard DriveHard DriveOptical Drive
Vertex 4  Samsung 830 Spinpoint F3 Some DVD I had laying around. 
CoolingOSMonitorPower
XSPC Raystorm EX240 w/ D5 W7 Pro 64 Samsung 23" Seasonic 650x 
Case
Fractal Design Arc Midi 
  hide details  
Reply
post #3 of 11
Thread Starter 
Wow that's exactly what I was looking for, execpt didn't think the resolution would come from the command prompt! How do you know that?!?!?!

rep+!!!!
    
CPUMotherboardGraphicsRAM
X2 5000+ BE Gigabyte GA-MA78GM-S2H AM2+ Integrated HD3200 2x2GB OCZ DDR2 
Hard DriveMonitorPowerCase
Maxtor 40GB Samsung 2220WM 22" Antec Neo HE 550W Ultra Wizard 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
X2 5000+ BE Gigabyte GA-MA78GM-S2H AM2+ Integrated HD3200 2x2GB OCZ DDR2 
Hard DriveMonitorPowerCase
Maxtor 40GB Samsung 2220WM 22" Antec Neo HE 550W Ultra Wizard 
  hide details  
Reply
post #4 of 11
"How do you know that?"

I'm older than dirt and the command line was the only way things used to get done

Glad it worked for you....
Edited by cgd - 5/28/08 at 12:59pm
My new system
(13 items)
 
  
CPUMotherboardGraphicsRAM
3930K Asus P9X79 HD 7850 Samsung 
Hard DriveHard DriveHard DriveOptical Drive
Vertex 4  Samsung 830 Spinpoint F3 Some DVD I had laying around. 
CoolingOSMonitorPower
XSPC Raystorm EX240 w/ D5 W7 Pro 64 Samsung 23" Seasonic 650x 
Case
Fractal Design Arc Midi 
  hide details  
Reply
My new system
(13 items)
 
  
CPUMotherboardGraphicsRAM
3930K Asus P9X79 HD 7850 Samsung 
Hard DriveHard DriveHard DriveOptical Drive
Vertex 4  Samsung 830 Spinpoint F3 Some DVD I had laying around. 
CoolingOSMonitorPower
XSPC Raystorm EX240 w/ D5 W7 Pro 64 Samsung 23" Seasonic 650x 
Case
Fractal Design Arc Midi 
  hide details  
Reply
post #5 of 11
Hi, I'm older than dirt too! Except I have pedestrian pc skills.

So my boss wants me to export the folder names off of one of our drives into an Excel spreadsheet.

It's our public N drive, so everyone and anyone has stored goo on there and you can't understand what half of the file names mean, much less determine what they might contain.

So my boss just walked up and he says he wants the folder names, not the file names! eventually he wants the file names...

I would need step by step instructions on how to do this, where I access the directory to enter the command prompts and so on. I'm not sure what your motivation would be to help, but I would really appreciate any assistance.

Thank you in advance.
post #6 of 11
Quote:
Originally Posted by pedestrian View Post

Hi, I'm older than dirt too! Except I have pedestrian pc skills.

So my boss wants me to export the folder names off of one of our drives into an Excel spreadsheet.

It's our public N drive, so everyone and anyone has stored goo on there and you can't understand what half of the file names mean, much less determine what they might contain.

So my boss just walked up and he says he wants the folder names, not the file names! eventually he wants the file names...

I would need step by step instructions on how to do this, where I access the directory to enter the command prompts and so on. I'm not sure what your motivation would be to help, but I would really appreciate any assistance.

Thank you in advance.

So you know, you are attempting to resurrect a thread 4 years old. I would advise you to start a new thread in same section and please pay attention to time stamp on posts from now on.
Windfall
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q9550 Asus P5E3 Premium Wifi XFX HD Radeon 6950 SuperTalent 
Hard DriveOptical DriveOSMonitor
WADFALS1001 WD Black Edition 1TB x 2 Raid 0 DVD-RW DIE VISTA, Using W7 24Inch 1920x1200 
PowerCase
Corsair 750TX Corsair 800D 
  hide details  
Reply
Windfall
(13 items)
 
  
CPUMotherboardGraphicsRAM
Q9550 Asus P5E3 Premium Wifi XFX HD Radeon 6950 SuperTalent 
Hard DriveOptical DriveOSMonitor
WADFALS1001 WD Black Edition 1TB x 2 Raid 0 DVD-RW DIE VISTA, Using W7 24Inch 1920x1200 
PowerCase
Corsair 750TX Corsair 800D 
  hide details  
Reply
post #7 of 11
Quote:
Originally Posted by Cheetos316 View Post

Wow that's exactly what I was looking for, execpt didn't think the resolution would come from the command prompt! How do you know that?!?!?!


rep+!!!!

After reading his post i knew that is how to do it from my Linux class, but had he not said that I probably would have forgotten to mention it.
post #8 of 11
I use that all the time for generating spreadsheets of my movie folder.

It's then easy to break them down into letter categories, add tags, links to relevant IMDB pages, etc.
Someone's Trash
(12 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core2Quad QX9650 Foxconn Blackops x48 Zotac Amp! GTX 580 1.5GB G.Skill 8GB DDR3-1600 
Hard DriveCoolingOSMonitor
Sandisk Extreme 120GB SSD Cooler Master Hyper 212 Plus Windows 7 x64 Professional Hanns-G 27" 1920x1200 
KeyboardPowerCaseMouse
Logitech K800 Rosewill Tachyon 750W 80+ Plat Rosewill Thor Logitech Wireless Trackball M570 
  hide details  
Reply
Someone's Trash
(12 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core2Quad QX9650 Foxconn Blackops x48 Zotac Amp! GTX 580 1.5GB G.Skill 8GB DDR3-1600 
Hard DriveCoolingOSMonitor
Sandisk Extreme 120GB SSD Cooler Master Hyper 212 Plus Windows 7 x64 Professional Hanns-G 27" 1920x1200 
KeyboardPowerCaseMouse
Logitech K800 Rosewill Tachyon 750W 80+ Plat Rosewill Thor Logitech Wireless Trackball M570 
  hide details  
Reply
post #9 of 11
Quote:
Originally Posted by pedestrian View Post

Hi, I'm older than dirt too! Except I have pedestrian pc skills.

So my boss wants me to export the folder names off of one of our drives into an Excel spreadsheet.

It's our public N drive, so everyone and anyone has stored goo on there and you can't understand what half of the file names mean, much less determine what they might contain.

So my boss just walked up and he says he wants the folder names, not the file names! eventually he wants the file names...

I would need step by step instructions on how to do this, where I access the directory to enter the command prompts and so on. I'm not sure what your motivation would be to help, but I would really appreciate any assistance.

Thank you in advance.

^ what he said about old threads.

 

BUT:

 

open a command prompt (click Start button, select Run, type cmd (lower case, no punctuation) in the box that appears.

 

in the new window that appears, type "cd N:"

then type "dir /B /S /A:D > file.csv"

 

file.csv will appear in the root of the drive, open it in excel and you're all done.

post #10 of 11
You can do it with that windows utility
File Names Export
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Windows
Overclock.net › Forums › Software, Programming and Coding › Operating Systems › Windows › Way to export filenames to excel?