Automatically Convert CSV to Excel

If you need to automatically convert CSV files to the Excel spreadsheet formats XLS (Excel versions 97-2003) or XLSX (Excel versions 2007-2016), FileSculptor is the right 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 run it throught a desktop icon, scheduled tasks or even use the command line executable FSRUN to run the conversion from batch files (.BAT).

Main Benefits

  • Convert files between the formats CSV, XLS and XLSX
  • Select and reorder fields
  • Create calculated fields using Excel-like functions like UPPER, CONCATENATE and LEFT
  • Save the process and repeat it anytime
bt_download bt_buynow

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.FileSculptor_Screenshot_03_Transform

Configure calculated fields using Excel-like functions like Upper and ConcatenateFileSculptor_Screenshot_02_CalcFields

Export the converted data creating or appending to the destination file in CSV, XLS or XLSX formats.FileSculptor_Screenshot_04_Export

Save the Project and the automation information will have the information needed to run the conversion project from an icon shortcut on the desktop, from command prompt or from task scheduler.

To run the conversion automatically, access the Task Scheduler application and create a new task to run FileSculptor with the parameters the task scheduler informed for on Automation tab.

The FSRUN utility brings support for command-line operations, using the same conversion projects created by FileSculptor. You can use it in BATCH files to run from command prompt.Command-line support

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.

@echo off
rem call subroutine "onefile" for each file to be processed
for %%f in (.\input\*.csv) do call :onefile "%%f"
rem main program must end with exit /b or goto :EOF
exit /b
rem SUBROUTINE "ONEFILE" ---------------------------
echo Processing file %1...
rem convert file, moving it to processed folder if conversion succeeded
rem or to error folder if conversion failed
fsrun -r convert.fsc -src:source1 %1 > nul 2>&1
if not errorlevel 1 (
echo Processing of file %1 succeeded!
move %1 .\processed\
) else (
echo Processing of file %1 failed!
move %1 .\error\
exit /b
bt_download bt_buynow