Q: Dropping csv file into a cell?

Thanks for that, Badunit. Interesting what Automator can do to make life more convenient. I suppose one could do something that would allow dropping a CSV file onto an app as well (droplet?) but that would only make sense for processing of multiple files at once. Your right-click and contextual menu pick is more convenient.

Since you are not (yet) an "identified developer" I was blocked from opening the workflow until I went to System Preferences > Security & Privacy and clicked 'Open Anyway'.

I see some of the key modifications to make it a service include choosing receives 'files or folders' in 'Finder.app' and wrapping the script an on run() handler with the file parameter. Nice.

Would love it to be able to recognize the separator (, ; | etc) automatically but that's beyond my abilities. It's working well here as is.

SG

I had never made a service that required an AppleScript script to receive an input. I took my best guess and gave it a shot and it worked.

I am surprised the security won't let you open a workflow in Automator without expressly choosing "open anyway". I can understand it not letting you run the workflow but I'd have thought it would let you edit it.  Better safe than sorry I suppose.

surprised the security won't let you open a workflow in Automator without expressly choosing "open anyway".

That's because being a nervous Nelly (or perhaps that's the default, I can't remember) my Security & Privacy preferences were set to allow apps downloaded from 'Mac App Store and identified developers.'  If they had been set to 'Anywhere' I don't think there would have been a warning. No problem reading, and editing, after choosing 'Open Anyway.'

SG

Wow thanks SGIII and Badunit!

That's a perfect solution for me

And we all owe a debt of gratitude to Nigel Garvey, who wrote and posted the CSV converter handler (subroutine) here on macscripter.net.  If you want to explore the inner workings, his version there has abundant explanatory comments in the code.

I've fossicked through forums on the web from time to time trying to find solutions to perennial csv headaches. Initial hope has inevitably turned into eventual disappointment. But this one is good. I don't fully understand how it does its magic, but like the results.

SG