The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

This page is outdated. You will be redirected to /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

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

Follow these steps:

  1. From the pull down menus, select: File > Save As...
  2. In the Save as dialog that appears, select File type Text CSV (.csv; .txt) from the list of spreadsheet file types.
  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 default Field delimiter is [Tab]. 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.

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.