Tuesday, January 3, 2023

Convert and open unsupported file formats to Excel 2010 - Microsoft Support [MS]

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


No comments:

Post a Comment

Search This Blog

About data segments that use Mobile Device IDs - Google Ads Help [gg-google-ads-en]

About data segments that use Mobile Device IDs To provide a comprehensive and consolidated view of your Audiences and make audien...