content/documentation/faqs/spreadsheet/012.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="011.html" accesskey="p">Previous</a>-<a href="013.html"
 accesskey="n">Next</a></p>
<h3>How do I output my spreadsheet data as an ASCII,
delimited text file?</h3>
<p>Follow these steps:
</p>
<ol>
  <li>From the pull down menus, select: <b>File &gt; Save As...</b></li>
  <li>In the <b>Save as</b> dialog that appears, select File type <b>Text
CSV (.csv; .txt)</b> from the list of spreadsheet file types.</li>
  <li>Click to enable the box next to <b>Edit filter settings</b>.</li>
  <li>Click <b>Save</b>.</li>
  <li>In the <b>Export of text files</b> dialog box that pops up,
enter the field and text delimiters of your choice. The default <b>Field
delimiter</b> is <b>[Tab]</b>. The <b>Text delimiter</b> 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.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="011.html" accesskey="p">Previous</a>-<a href="013.html"
 accesskey="n">Next</a></p>