Batch convert xls-Files to csv

Question

I need to convert over 100 Excel files to CSV. Worse these files consist of multiple sheets and I only need one of them.

At first I stumbled upon the Perl program xls2csv. Luckily I even found on XLS file conversion at the bottom a convenient script that converts all sheets into seperate csv files. But unluckily this converter is broken and skips lines.

I also tried pyodconverter but that only converts the first sheet.

Any suggestions? It would be ok if that conversion had to be done on Windows though I would really prefer Linux. And if it has to be Windows it would be nice if it wouldn't need an Excel installation.

http://stackoverflow.com/questions/15178218/r-linux-shell-convert-multi-sheet-xls-to-csv-in-batch — Henk, Mar 24 '13 at 04:41

score 1 · Answer 1 · answered Jul 14 '11 at 17:14

1

There's a very useful java library called Apache POI at http://poi.apache.org/

The following link provides an example application that converts xls to csv.

http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java

If you know java you can adjust it to your needs. Since it's java it runs also on linux.

answered Jul 14 '11 at 17:14

phlogratos

13,234
1
32
37

Looks as the way to go on Linux. Though this smells like I need Maven for this ;) – user694971 Jul 15 '11 at 13:35

score 0 · Answer 2 · answered Oct 02 '13 at 06:54

0

I know this is late but there is actually an HTA (HTML Application) which can do this. The details and download link can be found here.

answered Oct 02 '13 at 06:54

Chris West

885
8
17

score 0 · Answer 3 · answered Jul 29 '11 at 22:30

0

you could also have a look at StatTransfer... (Win only, I'm afraid)

answered Jul 29 '11 at 22:30

Mamamia

1

Batch convert xls-Files to csv

3 Answers3

Linked