Excel; exporting/importing different columns to different csv files
- by Sisyphus
Is there a way to batch export different columns to different csv files in excel on an OSX, I'm thinking something along the lines of possibly automator, applescript or bash. I've had a look play around with automator and so far no look.
The best I have accomplished export the whole sheet, then use sed to strip out what I don't need, however this is terribly inefficient.
Also, is there a method, to batch import multiple csv files into columns.
Thanks in advance
&& sorry I didn't tag excel correctly it wouldn't allow me to create the excel:mac tag