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.

Tip To bypass the Text Import Wizard, press Shift when you click OK in the Open dialog box.

Table 4-3 lists the text file types supported by Excel 2007. All text file formats are limited to a single worksheet.

Table 4-3: TEXT FILE TYPES

^ Open table as spreadsheet

Table 4-3: TEXT FILE TYPES

^ Open table as spreadsheet

File Type

Extension

Read/Write

Notes

CSV (comma separated variable)

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.

0 0

Post a comment