Importing and Exporting Foreign Formats
Prev
Next

Chapter 5. Importing and Exporting Foreign Formats

KSpread has a limited ability to import (read) and export (write) spreadsheet files with foreign formats. KSpread's capabilities at the time of writing are summarized in the table below, for more up to date information visit http://www.koffice.org/filters/status.phtml.

Format Import Export
Applix SpreadsheetBetaNone
Comma Separated Values (CSV )GoodGood
dBaseBetaNone
Excel 97/2000GoodNone
GnumericBetaBeta
HTMLNoneBeta
Quattro ProBetaNone

To import a foreign file just load it as though it were a KSpread native file with File-> Open....

To export a KSpread file in a different format select File->Save As... and select the format from the Filter: drop down box. Although KSpread automatically adds a .ksp extension to the names of files saved in its native format, you should add the correct extension for foreign formats.

CSV Data

Tables of data are often held in text files with the values in a line being separated by a comma, space, tab or other character, for example 123, 456, 789, abcd, efgh. Such files are commonly called “CSV” (Comma Separated Values) files, even though the separating character may not be a comma.

If you ask KSpread to open a text file it assumes that the file is in CSV format and launches a dialog box that allows you to specify the delimiter (separating character) used by the file, and shows how the data items will be placed into different spreadsheet cells.

Other options in this dialog box let you define the Format of the spreadsheet cells, whether text quote characters should be removed, and whether the first line(s) of the file should be ignored.

Prev
Next
Home