content/documentation/faqs/spreadsheet/029.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="028.html" accesskey="p">Previous</a>-<a href="030.html"
 accesskey="n">Next</a></p>
<h3>Is there any way to merge a text file with separated fields (*.txt,
*.csv) into a Calc file?</h3>
<p>Text files cannot be inserted into a Calc spreadsheet, because a
table or range must be specified in this OOo feature. For text files,
use the <b>Import</b> feature instead. Reference <a href="001.html">How
do I open a tab-delimited text file in a Calc spreadsheet?</a> for more
information.</p>
<p>External data in formats that include tables or ranges, such as web
pages and spreadsheets, <i>can</i> be inserted into a Calc worksheet.
It looks like a cool feature. I'm just learning about it too!
</p>
<ol>
  <li>Open a new calc sheet, and choose <b>Insert &gt; External Data...</b>
from the Menu Bar.</li>
  <li>In the <b>External Data</b> pop-up window that appears, click
the <b>[...]</b> radio button. This pulls up yet another pop-up box,
entitled <b>Insert</b>.
  <ul>
    <li>Browse to the file, and click on it so that its name appears in
the <b>File name</b> field.</li>
    <li>In the <b>File type</b> field, select the file format that
matches that of the file with the table in it. </li>
    <li>Click <b>Insert</b>. This brings back the <b>External Data</b>
pop-up box.</li>
  </ul>
</li>
  <li>Now in the <b>Available Tables/Ranges</b> section of the <b>External
Data</b> pop-up box, a list of tables and ranges appears. Click on a
range to select it.</li>
  <li>Once a table or range is selected, you can click <b>OK</b> to
import the data to the Calc sheet.</li>

</ol>
<p>There is an update control option available too. Click on the <b>Help</b>
button to see a blurb about it, and play with it to learn more. If you
can add more details to this FAQ about it, please do! </p>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="028.html" accesskey="p">Previous</a>-<a href="030.html"
 accesskey="n">Next</a></p>