How to extract many file names in various folders into excel

[benben007]

Hello,

I have many PDF files which i would like to build a list of into excel...

Or in otherwords

I want to make a list in excel of all the file names i have in certain folders, which sometimes is several hundred.

Please advise how to do this....

Thank You

[zer0]

I'm not 100% it is what you want, but you can search for "*.pdf", which will give you a list of PDFs you have, select all of them and apply the line of code below to have list of those filenames copied to clipboard, which then you can import into Excel.

Code: Select all

copytext report("{Name}<crlf>", 1);

[serendipity]

Hi and Welcome to XYplorer;
If I understood correctly, you want to write a list of PDF files in the current folder to an excel file, right? If so this should work:

Code: Select all

//Filter PDF files
     filter *.pdf; 
//Select all files
     sel a;
//Copy all selected files' names to clipboard
     #102;
//Write clipboard to a file called PDFs.csv
     writefile ("PDFs.csv", <clipboard>, o);
//Remove filter
     filter;
//Goto the new file
     goto "PDFs.csv";

If you want to create more complex lists use report command to do so. Read about it.

[admin]

You don't need a script to do this. Use the Report tab on the Info Panel, Current Folder / Extended INfo to CSV / To Clipboard (or To File). You will get a list like this (below are 4 long lines, wrapped by the forum software):

Code: Select all

Name;DOS Name;Type;Location;Size;Space Used;Clusters;Created;Modified;Accessed;Attributes;File Version;Description;Copyright;Character Set;Comments;Company Name;Internal Name;Language;Legal Trademarks;OLESelfRegister;Original Filename;Product Name;Product Version;Extra Info;Fixed Type;Fixed File Version;Fixed Product Version;Fixed File Flags;Fixed Target OS
affiliate.htm;AFFILI~1.HTM;Firefox Document;D:\www\xyplorer.com\code\;7251;8192;2;23.02.2006 13:55:03;03.01.2009 17:05:18;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;
contact.htm;CONTACT.HTM;Firefox Document;D:\www\xyplorer.com\code\;4829;8192;2;25.11.2005 19:51:15;25.03.2009 14:08:24;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;
donation.htm;DONATION.HTM;Firefox Document;D:\www\xyplorer.com\code\;7458;8192;2;25.11.2005 19:51:15;03.02.2009 15:18:45;30.04.2009 08:43:29;----A----I-;;;;;;;;;;;;;;;;;;;