To import a text file:
Open Calc…
From the File, Open dialog, select File type TEXT CSV (*.csv *.txt)
TEXT CSV (*.csv *.txt)
Select the CSV (or text) file to import…