Must convert 500+ xls files to txt (tsv)

  • Thread starter Thread starter KKramsch
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert xls to txt 3
Converting XLS file to QIF or to OFX 2
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
how to convert xls file into delimited txt file 2
Detecting tsv/csv files basing on file content 10
Convert multiple XLS files to TXT 2
Excel (Office 2007) Not Opening .tsv files 0
how can i convert tmp file in to xls file 5

Back
Top