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 / Next

How do I open a tab-delimited file in OpenOffice.org Spreadsheet? What if I have a different type of delimiter?

First, if your ASCII file is not already named with a .txt extension, rename it that way.

  1. Open Calc. In the pull-down menus, go to File > Open.
  2. Browse to find and select the ASCII file.
  3. Select File type: Text CSV (.csv; .txt). Note: This choice is near the bottom in the spreadsheet file types section of the list.
  4. Now click Open.
  5. In the dialog that appears next, select the Separator options. These are the characters or methods used in the file to separate the fields of data. The same methods must be specified in this box as those used in the file to import the data into a spreadsheet. After selecting the separator type, a preview of the data will be displayed in the Fields section. If the data visually lines up in columns, then the correct separator has been selected. If not, a different separator type may be used in the file. The goal is to match the correct character used as a separator in the file, so that the data will line up nicely in the visible cells. When the data lines up, click OK.

Hints:

Documentation / User FAQ / Calc / 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.