From The Document Foundation Wiki
Jump to: navigation, search

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.