Import text files into excel spreadsheet using automator
Hello,
I am trying to import a number of different text files into a single spreadsheet. The content of each of the text files is the same (i.e. Same number of columns to be made) and each item is spac delimited. I am trying to make it so that each of these text files will be entered into a single spreadsheet. That is, one text file corresponds to one row of data and the second text file would correspond to the second row of data in the excel sheet. Any ideas on how to do this? I imagine this will require some sort of applescript but I'm not familiar with applescript at all!
Thanks for your help!