FileSculptor is a file conversion tool to convert files between the formats CSV (Text), XLS (Excel 97-2003) and XLSX (Excel 2007-2016). FileSculptor will save you time if you have to convert files and transform data frequently. Does not require Microsoft Excel.
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. Configure search masks to process all files in a folder and then move the files to another folder
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
Configure conversions to run from a desktop icon, scheduled task or from command prompt
The FSRUN utility brings support for command-line operations, using the same conversion projects created by FileSculptor. You can use it in BATCH files.
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.