Question: how to convert text file to excel in open office?
Answer: Select File > Open from the main menu and browse to find and select the file. Select File type: Text CSV (.csv; .txt) ...  Click Open. In the dialog that appears next, select the Separator options. ...  When the data lines up, click OK.