Share via

Opening an .html file with columnar data in Excel

Paul Kraemer 276 Reputation points
2024-04-23T18:44:36.4233333+00:00

Hi,

I have an .html document that is generated by another application that I would like to import into Excel. I couldn't figure out how to paste .html into this post without having it interpreted, so I have attached it as an image below. I have also included an image of how it opens in Excel, and how I would like it to open in Excel. If anyone here can tell me if there is a way within Excel that I can get this to import the way I'd like, I would greatly appreciate it. If it turns out to be impossible, my next step will be to figure out if I can change settings in the application this is exported from that will make it more favorable for importing into Excel.

Any suggestions will be greatly appreciated. Thanks in advance.

Paulhtml_to_excel

Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 85 Reputation points Volunteer Moderator
    2024-04-24T03:57:54.9433333+00:00

    Import the HTML file using Power Query.

    If you need further help share your file.

    Andreas.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.