About opening and saving files from other programs

If you work with others who use earlier versions of Excel or other spreadsheet programs, you can change the default file format used to save workbooks you create in Excel 2002 or later.

Excel can directly open files from Lotus 1-2-3 versions up through 4.0 (*.wk?) and Quattro Pro for Windows versions 5.0 and 7.0 by using the Quattro Pro converter. To open a file from a later Quattro Pro version in Excel, either save the file in an earlier Quattro Pro format, or save the file in another format, such as Lotus 1-2-3 (*.wk?). Although you can open Quattro Pro for MS-DOS and Quattro Pro for Windows files, there are some limitations to opening the worksheets.

If you didn't install the converter for Quattro Pro files when you installed Excel, you must install it before you can open files in that format. You can't use the Quattro Pro file converter to save files. You will need to install the Quattro Pro converters from the Microsoft Office Web site.

Excel 2000 and later versions can open password protected WKS and WK1 files and files that are protected at the worksheet level. Excel 2000 and later versions cannot open WK3 or WK4 files that are protected with a file-level password. Excel 2000 and later versions cannot open Quattro Pro files that are password protected. Before you open the file in Excel, make sure you have removed any password from the file.

If the data you want to use in Excel is in a text file with data delimited (separated) by tab characters, commas, spaces, or similar characters, you can just open the file in Excel. Excel uses the Text Import Wizard to interpret the text according to your instructions and divides the data into rows and columns on a worksheet. You can also copy delimited text data from a word-processing document or other document into a workbook and then divide the text into columns.

If you want to use only some of the text from a text file, you can copy that data into Excel and then separate the copied text data into columns.