From The Document Foundation Wiki
Jump to: navigation, search

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

  1. Open an empty spreadsheet.
  2. Go to Sheet ▸ 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.