Microsoft Office Tutorials and References
In Depth Information
• Did you check for duplicate or missing rows?
• For text data, are the words consistent in terms of case?
• Does the data include any unprintable characters?
• Did you check for spelling errors?
• Does the data contain any extra spaces?
• Are the columns arranged in the proper (or logical) order?
• Are any cells blank that shouldn't be blank?
• Did you correct any trailing minus signs?
• Are the columns wide enough to display all data?
The chapter begins with a section on importing data, so it's only appropriate to end it with a discussion of ex-
porting data to a file that's not a standard Excel file.
Exporting to a text file
When you choose File ⇒ Save As, the Save As dialog box offers you a choice of a variety of text file formats.
The three types are
• CSV: Comma-separated value files
• TXT: Tab-delimited files
• PRN: Formatted text
I discuss these files types in the sections that follow.
When you export a worksheet to a CSV file, the data is saved as displayed. In other words, if a cell contains
12.8312344 but is formatted to display with two decimal places, the value will be saved as 12.83.
Cells are delimited with a comma character, and rows are delimited with a carriage return and line feed.
If you export a file using the Macintosh variant, rows are delimited with a carriage re-
turn only (no line feed character).
Note that if a cell contains a comma, the cell value is saved within quotation marks. If a cell contains a quota-
tion mark character, that character appears twice.
If your worksheet contains any Unicode characters, you should export the file using the Unicode variant. Other-
wise, Unicode characters will be saved as question mark characters.