How to Convert CSV to Excel Using FileSculptor

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.

filesculptor_screenshot_select_source_csv

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.

filesculptor_screenshot_source_csv_delimiters

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

filesculptor_screenshot_source_csv_file_properties

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.

filesculptor_screenshot_source_csv_field_properties

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.

filesculptor_screenshot_create_destination_xlsx

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.

filesculptor_screenshot_destination_xlsx_properties

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.

filesculptor_screenshot_destination_xlsx_preview

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.

filesculptor_screenshot_run_csv_xlsx

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.

Download Online Store