Microsoft Office Tutorials and References
In Depth Information
Sharing data beyond Excel
word-processing applications can use .csv files to store the information for mail
Text (Macintosh) (*.TXT) This saves the current worksheet as a tab-delimited text
file using the Macintosh character set.
Text (MS-DOS) (*.TXT) This saves the current worksheet as a tab-delimited text file
compatible with the character-based MS-DOS interface.
CSV (Macintosh) (*.CSV) This saves a comma-delimited text file using the
Macintosh character set. The differences between the normal, Macintosh, and MS-DOS
variants of each file type have to do only with characters that lie outside the normal
7-bit ASCII range.
CSV (MS-DOS) (*.CSV) The MS-DOS options use the IBM PC extended character
set. (You might see this referred to also as OEM text .) Select one of these options if
you intend to import your text file into a non-Windows-based application.
Excel 2013, 2010, and 2007 use a file format that is incompatible with previous Excel
versions. Excel versions 97 through 2003 share a file format that is incompatible with
even older versions. However, you can use the Save As command and Save As Type list
to export Excel 2013, 2010, and 2007 workbooks using two formats that play nicely
with older versions of Excel: Excel 97-2003 Workbook and Microsoft Excel 5.0/95
If you regularly share files with colleagues using different vintages of the program, you
might want to read “Ensuring file compatibility with previous versions of Excel” earlier
in this chapter.
Other file formats
You can use a few other file formats, most of which you won’t even need unless you have
a particular program with which you want to share data. Data Interchange Format (DIF) is
a legacy format that allows the specification of data in rows and columns, saves only the
active worksheet, and does not process graphic content. Symbolic Link (SYLK), a format that
dates back to the days of VisiCalc and Multiplan, is a sort of “rich-text format” for
spreadsheets that saves only the active worksheet and does not process graphic content.