• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Export Windows Event Logs to Excel

How to Export Windows Event Logs to Excel

By: Laurie Bryan
  • Share
  • Share on Facebook

Microsoft Windows Event Viewer logs events that occur on a computer running Microsoft Windows. The logs record a variety of events, including information about account logon and logoff activity, system information, warnings and errors. The event log is an invaluable tool for troubleshooting failed applications or other system-related errors. In native format, the event log files are viewable only in the Event Viewer Console. However, event logs can be exported from Event Viewer and imported into an Excel document. Once saved to Excel, the list of Event IDs can be sorted and analyzed as needed.

...
Store your computer's valuable system information by exporting event logs to Excel.

Open Event Viewer and Export logs to CSV file

Step

Right-click the "Computer" icon on the desktop. If the "Computer" icon is not on the desktop, click the "Start" button to locate the "Computer" icon from within the Start Menu programs.

Step

Click "Manage" from the options box to open the Computer Management Tools console.

Video of the Day

Step

Click the right-facing arrow in front of the group "Event Viewer" to open the available Event Viewer logs.

Step

Right-click the log to be exported, such as the "Security event log." From the available options, click "Save all Events as… ."

Step

Click the down arrow in the "Save as type:" box and select "CSV (Comma Separated Value) (*CSV)."

Step

Click in the "File name:" box and type a file name and save location for the file. For example: "c:\SecurityEventLog" will save the file called SecurityEventLog and place it on the C: drive.

Step

Click "Save" to save the CSV file to the C: drive.

Step

Close the Computer Management Console by clicking the "X" in the upper right-hand corner of the console box.

Open CSV File in Excel and Sort by Event ID

Step

Open Microsoft Excel by clicking "Start," "All Programs," "Microsoft Office" and "Microsoft Office Excel."

Step

Click the "Office" button in the upper left-hand corner of the Excel application and click "Open."

Step

Type "C:\SecurityEventLog.cvs" in the "file name:" box and click "Open" to start the Text Import Wizard.

Step

Select "Delimited" on the first page of the Text Import Wizard and click "Next."

Step

Select "Comma" and deselect "Tab" under the Delimiters options and click "Next."

Step

Select "General" under the Column data format box and click "Finish" to open the Event Viewer log in Excel.

Step

Click on the "Event ID" column heading to highlight the entire column of Event IDs.

Step

Click "Data" from the menu options at the top of the Excel application.

Step

Click "Sort" from the Data menu tab, select "Expand the selection" when the Sort Warning box appears and click "Sort."

Step

Click "Event ID" in the "Sort by" drop-down box, specify the sort order by selecting from the available options under the "Order" drop-down box and click "OK."

Step

Review the list of Windows event IDs in Excel and save the file for future use.

Show Comments

Related Articles

How Do I Read a VCF File?

How Do I Read a VCF File?

Around The Home
Productivity
By: Nick Peers
The 22 Coolest Gadgets We Saw at CES 2016

The 22 Coolest Gadgets We Saw at CES 2016

Around The Home
Productivity
By: Techwalla Editor
How to Export a Global Address List to a CSV

How to Export a Global Address List to a CSV

Around The Home
Productivity
By: Bill Richards
How Do I Import a VCard Into Excel?

How Do I Import a VCard Into Excel?

Around The Home
Productivity
By: Shelley Hoose
How to Read an ETL File

How to Read an ETL File

Around The Home
Productivity
By: Kammy Pow
The Location of the Windows Backup Log

The Location of the Windows Backup Log

Around The Home
Productivity
By: Lisa M. McMahon
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.