lotonah Posted July 15, 2008 Share Posted July 15, 2008 Hi there! For years I've been typing into an Excel file the names of my MP3 collection. After 10 years though, I have to admit that I'm really tired of the tedium. Does anyone know of a way to take the list of filenames in a folder and make them into an Excel spreadsheet? I can merge it with my main spreadsheet later... it'd probably save me a few solid days of work per year! Thanks in advance! Link to comment https://www.insanelymac.com/forum/topic/115819-is-this-possible-folder-contents-to-excel-spreadsheet/ Share on other sites More sharing options...
spruce_crc Posted July 23, 2008 Share Posted July 23, 2008 In Terminal type: 1. ls -l > myfile.csv 2. Load myfile in Excel 3. Done See "man ls" for format options of the ouput file. Link to comment https://www.insanelymac.com/forum/topic/115819-is-this-possible-folder-contents-to-excel-spreadsheet/#findComment-830901 Share on other sites More sharing options...
MacUser2525 Posted July 23, 2008 Share Posted July 23, 2008 In Terminal type: 1. ls -l > myfile.csv 2. Load myfile in Excel 3. Done See "man ls" for format options of the ouput file. ls -l | cut -d " " -f13 > myfile.csv if you only want the file name. Link to comment https://www.insanelymac.com/forum/topic/115819-is-this-possible-folder-contents-to-excel-spreadsheet/#findComment-830937 Share on other sites More sharing options...
Recommended Posts