Tuesday 22 November 2011

How to export files from my c drive to csv or excel file ?

Suppose if you would like to make list of all file names into csv file  from your c drive's folder which is stored in c:\images


1) Start a command prompt
Click On start -> after that select RUN tab
give cmd in run ... It will open command prompt.

2)If once we open

You will be able to see C:\>users\your name>

then type as below

C:\>users\your name> dir C:\images /b > c:\filename.csv     and then press enter


It will generate list of file names into .csv file.. You can open your csv file into excel sheet by right clicking on filename.csv file.

Please don't hesitate to ask questions.

No comments:

Post a Comment