How to use automator to convert excel cells to text files
I'm trying to convert each row of an excel file to a separate text file. I have two columns. The first column is the file name and the second column is the text. So, if my excel sheet is:
A1 B1
textfile1 Hello world!
textfile2 Goodbye!
How can I get automator or apple script to create two text files one named textfile1.txt (containing the text, "Hello world!") and another file named textfile2.txt (containing the text "Goodbye!")?
Thank you!!!
MacBook Pro with Retina display, OS X Yosemite (10.10.5)