3
votes
4answers
2k views

Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac

I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...
1
vote
2answers
1k views

Automating data from an Excel file and interacting with browser

How can I automate copying records from an Excel file or CSV and interacting with a browser? Example Task: Extract or Copy record(s) from an Excel file row Go to a URL (probably using Google ...
0
votes
1answer
748 views

Excel; exporting/importing different columns to different csv files

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 ...