XLS2CSV: Excel to CSV Converter on UNIX Systems

XLS2CSV: Excel to CSV Converter on UNIX Systems

Posted by: Viral Raichura

Convert your Excel (*.xls) files to CSV formats on Unix / Linux platforms.

Overview

While Unix and Linux servers provide extensive features that meet the requirement of Enterprises, working with Microsoft proprietary files on Unix platforms had always been a challenge. Data available in Excel files is one of the most popular sources. The Perl script provided here allows you to convert your excel files into csv files which an easy to read format across all the platforms.The documentation provided in the download file provides detailed steps of implementing this script. Note:
  • This library will fail to read data from a row if the first column is empty.
  • This library works only with *.xls formats (Office 97-2000 formats). I will try to publish a library to read from *.xlsx soon.
  • This script may not work with Excel files that use formulas.
  • This script may not work properly if Excel files are being used by any other applications.

Features

  • One of the recent versions of Perl.
  • Various Perl modules (listed below. You can download them from http://search.cpan.org/).
  • Locale::Recode
  • Unicode::Map
  • Spreadsheet::ParseExcel
  • Spreadsheet::ParseExcel::FmtUnicode
  • Text::CSV_XS
For more information on installing above-mentioned Perl modules, please refer to Perl documentation.

Support