DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2671933 - Last Review: October 25, 2012 - Revision: 8.0

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 (http://answers.microsoft.com/) online community or visit contact Microsoft Support (http://support.microsoft.com/contactus/?ws=support) to learn more about your support options



Applies to
  • Microsoft Excel 2010
Keywords: 
KB2671933
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support