Microsoft Office Tutorials and References
In Depth Information
File Types
File Type
Extension Read/Write
Notes
Excel 97–Excel 2003
Add-In
xla
Yes/Yes
The Excel binary format (BIFF8) for add-ins that’s
compatible with Excel 97 through Excel 2003.
Microsoft Excel
5.0/95 Workbook
xls
Yes/Yes
The Excel binary format (BIFF5) that’s compatible
with Excel 5.0 and Excel 95.
XML Spreadsheet
2003
xml
Yes/Yes
Microsoft’s XML Spreadsheet 2003 file format
(XMLSS).
Microsoft Office XP and Office 2003 users can install the Microsoft Office Compatibility
Pack, which allows them to open and save documents in the Office 2010 and Office 2007
file formats. The Compatibility Pack is available at http://office.microsoft.com .
Text file formats
When you attempt to load a text file into Excel, the Text Import Wizard might kick in to help you
specify how you want the file retrieved.
To bypass the Text Import Wizard, press the Shift key when you click Open in the Open
dialog box.
Table 4-3 lists the text file types supported by Excel 2010. All text file formats are limited to a
single worksheet.
Table 4-3: Text File Types
File Type
Extension Read/Write Notes
CSV (comma
separated values)
csv
Yes/Yes
Columns are delimited with a comma, and rows are
delimited with a carriage return. Excel supports
subtypes for Macintosh and MS-DOS.
Formatted Text
prn
Yes/Yes
Columns are delimited with a space character, and
rows are delimited with a carriage return.
Text
txt
Yes/Yes
Columns are delimited with a tab, and rows are
delimited with a carriage return. Excel supports subtypes
for Macintosh, MS-DOS, and Unicode.
Data Interchange
Format (DIF)
dif
Yes/Yes
The file format originally used by VisiCalc.
Symbolic Link (SYLK) slk
Yes/Yes
The file format originally used by Multiplan.
Database file formats
Table 4-4 lists the database file types supported by Excel 2010. All database file formats are
limited to a single worksheet.
 
Search JabSto ::




Custom Search