Must convert 500+ xls files to txt (tsv)

K

KKramsch

I need to convert 500+ xls spreadsheet files to tab-separated text
files. How can I automate this process? I am VB illiterate, though
I'm handy with Perl, so if there's a way to convert an xls file to
tsv on the command line I could use Perl to automate this. Anyway,
any advice appreciated.

Karl
 
H

Harald Staff

Hi Karl

AFAIK you need Excel (or an Excel compatible application) to actually open
and read each file. So you should use Excel for it. Excel with VBA macros is
a very powerful tool, so this ought to be pretty easy.

HTH. Best wishes Harald
 
Top