Select the file/folder in which to place the converted files. For a single file click the File.. button, for a folder click the Folder.. button.
You must also choose between creating Excel (XLS/XLSX) or CSV files. To do this simply use the appropriate extension (*.CSV, *.XLS or *.XLSX) in the Output File text box.
The CSV files generated can be opened directly within Excel without any issues provided you used the default delimitation character, the comma. Also, and perhaps most importantly, creating a CSV file can be done much faster than creating an Excel file.
There are options specific to both the input and output file(s). Click on the Options (ALT-O) button to modify their settings.
You can optionally specify the following in the program and command line and user interface:
Path |
Typical Interpretation |
%USERPROFILE% or %HOMEPATH% |
C:\Users\UserName |
%APPDATA% | C:\Users\UserName\AppData\Roaming |
%LOCALAPPDATA% | C:\Users\UserName\AppData\Local |
%MYDOCUMENTS% | C:\Users\UserName\Documents |
You'll notice that all the provided examples use %appdata%. This is how we were able to install examples that were ready to run out of the box in a folder known to have full read/write privileges.
See also:
STEP 2