Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How do I open a text file containing separate fields in a spreadsheet? What if there are different field separators?

If your ASCII file is not already named with a .csv or .txt extension, rename it (preferably as .csv).

  1. Go to File ▸ Open.
  2. In the File Type box, select: Text CSV ( *.csv; *.txt). (Note : This choice is near the bottom of the list).
  3. Navigate to your ASCII file and select it.
  4. Click on Open.
  5. In the Text import dialog that opens, select the correct Separator options for the columns:
    • if there is a separator, choose Separated by and then enter the appropriate separator(s).
    • if the columns are fixed width, choose this option and position the column dividers in the preview.
  6. If you are importing a data file from a stock control system, it is highly probable that the decimal separator will be a dot. In this case set the language to English (US).

If you want to combine several ASCII files into a single sheet, follow this procedure:

  1. Open an empty spreadsheet.
  2. Go to Insert ▸ Sheet from file.
  3. Select the File Type that you want (Text CSV .txt, dbase, etc.)
  4. Search for the file you wish to open.
  5. Click on the Insert button to close the window.
  6. Set the parameter in the Text import window as shown above.
  7. Click OK.
  8. Repeat the procedure from 2) for the other files.

Note: If you check the Link box, the sheet will be linked when you open your spreadsheet, and you will be asked if you wish to update the link. Just click OK.