|Product||File Format||Last Excel Version that opens the File format|
|Lotus 1-2-3 v1||.wks||Excel 2003|
|Lotus 1-2-3 v2||.wk1 or .fmt||Excel 2003|
|Lotus 1-2-3 v3||.wk3 or .fm3||Excel 2003|
|Lotus 1-2-3 v4||.wk4||Excel 2003|
|Dbase II||.dbf||Excel 2003|
|Dbase III||.dbf||Excel 2010|
|Dbase IV||.dbf||Excel 2010|
|Quattro Pro for DOS||.wq1||Excel 2003|
|Quattro Pro 5.0 for Windows||.wb1||Excel 2003 with converter|
|Quattro Pro 7.0 for Windows||.wb3||Excel 2003 with converter|
|Microsoft Works 2.0||.wks||Excel 2003|
Note: Excel cannot open password protected workbooks created in the older formats.
While there are file converters out there, the most common way to get an unsupported file format into Excel is:
- Open the unsupported data file with the software used to create it.
- Use the Save As or Export functions to save the file in either Comma-Separated Values (CSV) or XLS(If Supported) file format.
- Once that is done you can Open it into Excel 2010.
Note: XLS will retain formulas, CSV will not.
Get help from the Microsoft Community online community or visit contact Microsoft Support to learn more about your support options
Article ID: 2671933 - Last Review: Oct 5, 2012 - Revision: 1