From The Document Foundation Wiki
    < Faq‎ | Calc

    How do I export data from my spreadsheet into an ASCII text file with field delimiters?

    Follow these steps:

    1. Go to File ▸ Save as
    2. In the dialog that appears, select the file type Text CSV.
    3. Check Automatic file name extension.
    4. If the file has not been saved before, give it a name.
    5. Click on Save.
    6. Confirm that you really want to use this format (you will lose formulas, formatting, graphics...).
    7. In the next dialog Export text enter the Field delimiter that you want. The default is a comma. The Text delimiter is the character that separates each data entry in your spreadsheet when it is converted to ASCII format.
    8. Click on OK.