To convert an Excel spreadsheet to CSV format, run FileSculptor. The first screen shown is the Import screen, where you can select the file to import. Change File Type to Excel Workbook and click on “Browse…” button to select the Excel 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, configure the right sheet by name or position.
Adjust the position of the first column and line of data in the sheet, including header. If the sheet 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 sheet 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 sheet. 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 CSV files and other text file formats like TSV (Tab Separated Values) by configuring the delimiter. Select the CSV 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 sheet to it, click on option “Append content to the end”. Select if the file has a header, if empty lines should be ignored, the delimiter and if values should be enclosed on text qualifiers in case they contain the delimiter or special characters like line breaks.
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.