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.