How do I output my spreadsheet data as an ASCII, delimited text file?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Files
Jump to: navigation, search


How do I output my spreadsheet data as an ASCII, delimited text file?


  1. Select: File → Save As… from the main menu
  2. In the Save as dialog that appears, select File type Text CSV (.csv; .txt) from the list of spreadsheet file types.
    Press T several times in the list to quickly jump to that entry.
  3. Click to enable the box next to Edit filter settings.
  4. Click  Save .
  5. In the Export of text files dialog box that pops up, enter the field and text delimiters of your choice.
    The Text delimiter is the character that will surround any text entries in your spreadsheet, to keep each phrase together as an entity, when the file is exported into ASCII format.


Personal tools