Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.6 released

This page is outdated. You will be redirected to http://wiki.services.openoffice.org /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 and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.