Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Convert and open unsupported file formats to Excel 2010


View products that this article applies to.

Summary

Convert and Open into Excel 2010.
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.


↑ Back to the top


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


↑ Back to the top


Keywords: consumeroff2010track, consumertargetofficefy12, kb

↑ Back to the top

Article Info
Article ID : 2671933
Revision : 1
Created on : 1/7/2017
Published on : 10/5/2012
Exists online : False
Views : 317