Convert saved html webpage to Excel/CSV

This topic contains 4 replies, has 3 voices, and was last updated by  Don Jones 2 weeks, 6 days ago.

  • Author
    Posts
  • #84619

    Sethuraman
    Participant

    I have taken health report of multiple servers and saves as webpage, since it has so much information. I want to convert into excel so that i can filter according to server name and check their stats. Can somebody help me how to do in powershell

  • #84626

    Olaf Soyk
    Participant

    I would recommend to get the health report in a format you need instead of converting an existing report.

    • #84631

      Sethuraman
      Participant

      The report has css included which makes it clear to read the data, that is the reason i made the report in html format.

  • #84634

    Olaf Soyk
    Participant

    OK. But I think it will be harder than necessary to convert a html report instead of creating this report in csv and format the report inside Excel.

  • #84635

    Don Jones
    Keymaster

    I'll agree. There's nothing native in PowerShell that will magically do this; you're going to have to hand-code something to parse the HTML and output CSV. And the CSV will, of course, not include any CSS or formatting or anything. And coding for Excel is extremely difficult and tedious.

You must be logged in to reply to this topic.