Although Microsoft Excel can open CSV files, there are a few reason to use special tools to convert the data.
Special converters allows you to automatize this operation and provide more flexibility.
There are two programs to convert CSV files to Excel (xls, xlsx).
Both converters can work:
- as a wizard, using graphic interface
- as a command line tool
In the first case you select one or more CSV files, choose the output file or folder, and set different options to customise the output files.
for example, you can define a field delimiter: comma, semicilon or TAB.
In the second case you use command line interface:
it allows you to run converters with predefined parameters manually or using scheduler to automatise routine work.
For example (Windows and OSX):