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 windows that appears, specify the following parameters:
•. 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 Another 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 .
• 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 "Fit column width to the contents?" Click Fit Width to fit the width to the content or Cancel to keep the default column width.
You can save the resulting file in .xlsx, .xods, or .ods formats in a usual manner.