Faq/Calc/001

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.
 * 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:
 * 6) * if there is a separator, choose Separated by and then enter the appropriate separator(s).
 * 7) * if the columns are fixed width, choose this option and position the column dividers in the preview.
 * 8) 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.
 * 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.