Import Wizard - Excel file

Use this sheet to specify the range where to import and language(s) of each column in the selected range.

Sheet

Some Excel files contains several sheets. Select a sheet where you want to import from.

Range

Select the range where the import from. The range is a string that contains the upper left and bottom right corners of tge selected area coded in the same way as Excel codes range. The format is ad:ad where a is column code that is any combibination of alphabets (e.g. A or AB) and d is a row number starting from 1.

The following image has string data in B3:D:6 range.

By default the range cover the complete data area of the selected sheet. If you want to change it type the new value and press Update button or Tab to move focus from the range edit.

First rows of the selected range

This grid shows the first two lines of the selected range.

Columns

Specifies the column structure of the data. It can contain any number of following kinds of columns:

Click Add language to add a language column. Click Add to add another column. Click Import to read the column structure from a file. Click Export to write column structure to a file.

How new line and other special characters are escaped

Specifies the escape method how line feed, carriage return and other special characters are encoded.

Sample

Shows a sample row based on current settings.