If you need to automatically convert the Excel spreadsheet formats XLS (Excel versions 97-2003) or XLSX (Excel versions 2007-2016) to CSV files, FileSculptor is the tool for the job. With FileSculptor you can convert files even if the machine doesn’t have Excel installed, because it does not use Excel to do the conversion.
FileSculptor comes with a visual interface to create and run conversion projects. After the project is created, you can use the command line executable FSRUN to run the conversion from a batch file or to create a scheduled task.
Import one or more source files in the formats CSV, XLS or XLSX. Preview the content of the data to be converted on a grid
Create calculated fields based on fields from the source files
Configure calculated fields using Excel-like functions like Upper and Concatenate
Export the converted data creating or appending to the destination file in CSV, XLS or XLSX formats
The FSRUN utility brings support for command-line operations, using the same conversion projects created by FileSculptor. You can use it in BATCH files or schedule jobs in Windows to convert files frequently.
Below is a sample batch file using FSRUN to convert all CSV files in INPUT folder, appending data to a spreadsheet in OUTPUT folder, and moving the processed files to PROCESSED folder if the conversion succeeded or ERROR folder if the conversion failed.