To convert a CSV file to Excel format, run FileSculptor. The first screen shown is the Import screen, where you can select the file to import. Click on Open File button, keep the file type filter as CSV Files and select a CSV file on your computer.
The first 100 lines of the file are shown on the preview grid. If data is not shown correctly in columns, you might have to change delimiters analyzing the delimiter used on the file and configuring a respective delimiter in the program. FileSculptor can read other Text files like TSV (Tab Separated Values) by configuring the right delimiter. Click on Edit Properties button to configure delimiters and properties of fields.
If the file has a header with field names, the preview grid will show the names of each field. If the file doesn’t have a header, uncheck the box “File contains fields on first line”.
If the file has empty lines and you want to ignore then, check the box “Ignore lines in which the first field is empty”.
You can define the type of fields to number and date, and specify the format of the data stored on the CSV. You can also give fields a label to be used on the column header when exporting data.
Click on Export tab to show the configure the file to export. FileSculptor supports Excel spreadsheets in XLS format (used in Excel 97 to Excel 2003) and XLSX format (used in Excel 2007 to Excel 2019). Click on Browse button, select the desired format and folder location and file name. You can use an existing file or create a new file by typing its name.
Click on Edit Properties button to configure the destination file. If the export file already exists and you want to add data from the CSV to it, click on option “Append content to the end”. Select the location of the sheet, by name and position and first line and column to write data to.
Select fields from the source, you can also reorder fields. If you simply want a copy of data in the source file, click on “Add All” button to add all fields from source to destination. You can also specify the type of each field and the format to display data on the spreadsheet.
A preview grid shows how data will be written on destination.
Click on Run tab to do the conversion. Click on Run Now button and FileSculptor will process the source file and write data to the destination file, creating a new file if it does not exist.
Save the project to repeat the same file conversion again when needed. You can also use the Automation tabs to create an icon shortcut on the desktop to do the conversion with one click or copy parameters to create a scheduled task or run from command prompt.