Summary

Convert and Open into Excel 2010.

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.


More Information

Converting and Opening Unsupported File Formats

While there are file converters out there, the most common way to get an unsupported file format into Excel is:

  1. Open the unsupported data file with the software used to create it.

  2. Use the Save As or Export functions to save the file in either Comma-Separated Values (CSV) or XLS(If Supported) file format.

  3. 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


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×