Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

When you import a .csv event log file into Excel 2007 on a Windows Server 2008-based computer, the event log is not readable


View products that this article applies to.

Symptoms

You can save an event log as a .csv file on a Windows Server 2008-based computer. However, when you import the event log into Microsoft Office Excel 2007, it is not readable.

↑ Back to the top


Workaround

To work around this problem, follow these steps:
  1. Save the event logs in Event Viewer in .csv format. To do this, follow these steps:
    1. Start Event Viewer. To do this, click Start, click Run, type eventvwr, and then click eventvwr in the Programs list.
    2. Click to select the event log that you want to save.
    3. On the Action menu, click Save Events As.
    4. Type a name for the log file in the File name box.
    5. In the Save as type field, click to select CSV (Comma Separated) (*.csv), and then click Save.
  2. Open the file that you saved in step 1e in a text editor, such as Notepad.
  3. Save the file. Click Yes if you are prompted to replace the file.
  4. Double-click the .csv file that you saved in step 3, and then open the file in Excel 2007.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: KB949390, kbprb, kbexpertiseinter, kbtshoot

↑ Back to the top

Article Info
Article ID : 949390
Revision : 2
Created on : 3/26/2008
Published on : 3/26/2008
Exists online : False
Views : 318