|
CSV to XLS
Comma Separated Values (or CSV) is a simple file format for storing spreadsheet and database information. Using a CSV file allows for fast and secure storage of large spreadsheets for importation into another application. CSV Converter provides for very simple and fast conversion from CSV files into XLS files (.xls is the file format actually used by Microsoft Excel – the market leading spreadsheet tool on the market today). Advanced CSV Converter is the fast and simple way to manage your CSV files within a Microsoft Office environment.
Advanced CSV Converter allows you convert csv to xls format (excel tables) from GUI or command line. Advanced CSV Converter does not require Microsoft Excel.
1. Select the csv file (or select folder with csv files for batch conversion).
2. Select the output xls file (or select folder for xls files).
3. Preview, select options for sorting, filtering data (if necessary)
You can also select/unselect columns, set order for columns.
Convert CSV to XLS via command line
"c:\Program Files\CSV Converter\csvcnv.exe" file.csv outfile.xls [/FILTER|/COLUMNS|/NOWRITEHDR|/SRCSEP|/STARTFROM|/SORTBY]
simple csv to xls conversion
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls
convert csv to xls with columns selection
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /COLUMNS:NAME,STREET
convert csv to xls with filter
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /FILTER:myfilter.txt
convert csv to xls with custom delimiter in source file
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /SRCSEP:
convert csv to xls with pipe as delimiter in source file
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /SRCSEPPIPE
convert csv to xls without header
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /NOWRITEHDR
convert csv to xls with sorting order
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /sortby:DATE
convert csv to xls from line 10
"c:\Program Files\CSV Converter\csvcnv.exe" sample.csv sample.xls /STARTFROM:10
csv to xls batch conversion
"c:\Program Files\CSV Converter\csvcnv.exe" c:\base\*.csv c:\out /TOXLS
Download Advanced CSV Converter
|