From The Document Foundation Wiki
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).