Is there a tool to convert a large number of excel files into tab delimted files automatically?
+1
A:
I don't think there are any good free tools to do so right now, but you could look into using the Open Office API to write something,
Or for a quick and dirty solution, you could record and Open Office Calc macro that would do it, and launch that macro from the command line.
PherricOxide
2009-12-04 05:16:40
A:
This might also help http://dag.wieers.com/home-made/unoconv/
convert to csv, and maybe replace , with tabs?
thenoviceoof
2009-12-04 05:23:42
A:
I just through this together, its not pretty but should do what you need. Tested on WindowsXP / Office2007.
download from: http://www.filedropper.com/xl2tab
Extract the xl2tab.vbs file to the directory containing the excel files and double-click to run. It will place the converted files into a new directory called "output." The original directory-structure remains intact within the output folder.
Stephen Brown
2009-12-04 05:54:34
sorry no direct link to the file, my host doesn't allow hotlinking. Can't complain when it's free =)
Stephen Brown
2009-12-04 05:59:06
thank you I will try it! is it possible to loop through all sub directories recursively?
2009-12-09 09:01:00
I just uploaded an updated version that will loop through all sub-directories. It outputs everything to a folder called "output", which keeps the original directory structure intact. The download is in the same place as before.
Stephen Brown
2009-12-10 19:30:18