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. Keep the File Type as CSV and click on “Browse…” button to select the 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.
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”.
Click on “Field Properties…” button to configure the fields on the file. You can define the format of number and date fields and give then a Label to be used 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 2016). Select the desired format and click on “Browse…” button to define folder location and file name. You can use an existing file or create a new 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.
Then 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. A preview grid shows how the 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 do 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 the parameters to create a scheduled task or run from command prompt.
 |
 |