How to export event viewer errors to Excel in Windows Server 2012

eventviewerwindows-server-2012-r2

How would I export errors of event viewer from Application and Security section to excel, it has any way to export in event viewer or I must use windows powershell?

Best Answer

Powershell can export to csv, you could import it in Excel after.

Get-EventLog -LogName Security -ErrorAction SilentlyContinue | Export-Csv output.csv

Or use Export-XLSX PowerShell generate real Excel XLSX files without Excel and COM The rating seem good on it, thus look like correct.

Export-XLSX Export PowerShell Objects to Excel .xlsx file without Excel! These script cmdlet creates a Excel XLSX workbook file and stores the data of the objects that you submit in a worksheet within the workbook. You can use this script like the Export-CSV cmdlet.

Related Topic