1.8

4.
Click the Browse button and open the file you want to work with.
5.
Click Next.
l
From the File menu
1.
In the menu, click File > New.
2.
Click the Data mapping Wizards drop-down and select From CSV/XLSX/XLS
File.
3.
Click Next.
4.
Click the Browse button and open the file you want to work with.
5.
Click Next.
After selecting the file, take a look at the preview to ensure that the file is the right one and the
encoding correctly reads the data. Click Next.
For an Excel file you can indicate whether or not the first row contains field names, and from
which sheet the data should be extracted.
Note
Excel files saved in "Strict Open XML" format are not supported yet.
For a CSV file the will display the different settings it has detected, allowing you to change
them:
l
Encoding: Defines which encoding is used to read the file.
l
Separator: Defines which character separates each field in the file.
l
Comment Delimiter: Defines which character starts a comment line.
l
Text Delimiter: Defines which character surrounds text fields in the file. Separators and
comment delimiters within text are not interpreted as separator or delimiter; they are seen
as text.
l
Ignore unparseable lines: Ignores any line that does not correspond to the settings
above.
Page 107