Convert saved html webpage to Excel/CSV

Welcome Forums General PowerShell Q&A Convert saved html webpage to Excel/CSV

This topic contains 4 replies, has 3 voices, and was last updated by

 
Keymaster
1 year ago.

  • Author
    Posts
  • #84619

    Participant
    Points: 0
    Rank: Member

    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

    Participant
    Points: 268
    Helping Hand
    Rank: Contributor

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

    • #84631

      Participant
      Points: 0
      Rank: Member

      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

    Participant
    Points: 268
    Helping Hand
    Rank: Contributor

    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

    Keymaster
    Points: 1,704
    Helping HandTeam Member
    Rank: Community Hero

    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.

The topic ‘Convert saved html webpage to Excel/CSV’ is closed to new replies.