Convert a file

MyOffice Spreadsheet allows you to import data from text files in .csv, .scsv, .tsv, .tab, and .txt formats and display it in tabular form. To do this, follow these steps:

1.Open the file.

2.In the Convert window that appears, specify the following parameters:

•Character set: The text encoding format.

•Separators: Characters separating the values. Each value is then placed in a separate cell. For example, if you choose to use the semicolon (;) as the separator, the values in the string 1;1;1 will be placed into 3 separate cells. You can select the separator from a list of fixed values or specify it manually in the Custom box (only one character can be specified in the Custom box). You can select multiple separators to use from the list.

•String qualifier: A character that frames individual values. If a value is framed by qualifiers, it is placed in a separate cell even if it contains a separator. For example, if a comma is specified as the separator and double quotation marks are specified as the qualifier, the decimal number “3.14” is placed in a separate cell.

•Fit width to content: If this checkbox is selected, the width of each column is automatically adjusted to the content of the cell that contains the most data.

3.Click OK.

The delimiter-separated data contained in the file will be displayed in a new spreadsheet in tabular form.

When switching to data display, you are given another opportunity to configure the automatic column width selection. If you have not selected the corresponding checkbox in the Convert window, a pop-up message appears on the screen with the text: “Fit column width to the contents?”. To automatically select the column widths, click Fit width. Otherwise, to keep the default column widths, click Cancel.