Article ID: 2671933 - View products that this article applies to.
Expand all | Collapse all

Summary

Convert and Open unsupported file formats into Excel 2010.
Collapse this tableExpand this table
ProductFile FormatLast Excel Version that opens the File format
Lotus 1-2-3 v1.wksExcel 2003
Lotus 1-2-3 v2.wk1 or .fmtExcel 2003
Lotus 1-2-3 v3.wk3 or .fm3Excel 2003
Lotus 1-2-3 v4.wk4Excel 2003
Dbase II.dbfExcel 2003
Dbase III.dbfExcel 2010
Dbase IV.dbfExcel 2010
Quattro Pro for DOS.wq1Excel 2003
Quattro Pro 5.0 for Windows.wb1Excel 2003 with converter
Quattro Pro 7.0 for Windows.wb3Excel 2003 with converter
Microsoft Works 2.0.wksExcel 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.

Need more help?

Get help from the Microsoft Community online community or visit contact Microsoft Support to learn more about your support options


Properties

Article ID: 2671933 - Last Review: October 25, 2012 - Revision: 8.0
Applies to
  • Microsoft Excel 2010
Keywords: 
KB2671933

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com