content/documentation/faqs/spreadsheet/036.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="035.html" accesskey="p">Previous</a>-<a href="037.html"
 accesskey="n">Next</a></p>
<h3>Why does Calc refuse to open my text file?
</h3>
<p>A text file must be imported into Calc using <b>.csv</b> or <b>.txt</b>
format. Otherwise, the file will automatically open in Writer.</p>
<ol>
  <li>Rename the file so that it uses the .csv file extension. </li>
  <li>In the <b>File &gt; Open</b> dialog, set the <b>File type</b>
field
to <b>Text CSV</b>. This is quite a way down in the list so it is easy
to miss. It is grouped with the spreadsheet file types. </li>
</ol>
<p><b>For more information:</b></p>
<ul>
  <li>In the pull-down menus, go to <b>Help &gt; Contents &gt; Index</b>
and type <b>csv files;spreadsheets</b> in the <b>Search term</b>
input bar.</li>
  <li><a href="001.html">How
do I open a tab-delimited file in a Calc spreadsheet?</a></li>
</ul>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="035.html" accesskey="p">Previous</a>-<a href="037.html"
 accesskey="n">Next</a></p>