MyOffice Spreadsheet allows you to import data from text files in .csv, .scsv, .tsv, .tab, and .txt formats and display it in a spreadsheet:
1.Open the file you want to import.
2.In the pop-up window that appears, specify the following parameters:
• A text encoding format.
• Characters separating the values. Each value is then placed in a separate cell. For example, if you choose to use the semicolon () as the delimiter, the values in the string "" will be placed into 3 separate cells. You can use the preset delimiter type from the list or specify it manually in the box. You can select multiple delimiters to use from the list.
• A character that frames individual values so that they are placed in separate cells even if they contain a delimiter. For example, if a dot is specified as a delimiter and double quotes as a string qualifier, the fractional number "" is placed into a single cell.
• An option to adjust the width of each column to automatically fit the widest entry in a column. If selected, the width of each column is automatically selected based on the content of the cell that contains the most data.
The delimiter-separated data contained in the file will be displayed in a new spreadsheet in tabular form.
If you didn't select the option during the file import, the "" pop-up message will appear briefly on the screen once the new file is open. Click to fit the width to the content or to keep the default column width.
You can save the resulting file in .xlsx, .xods, or .ods formats in a usual manner.