convert Html files to Excel

If the files you want to 'covert' are stored on your hard drive and not on a web page that you're looking at on the internet, you can import them.

Open a new worksheet in Excel. Then click Data -> Import. In the lookin box, navigate to where you HTM or HTML files are located. Change the file type to 'Web Page' and you'll see the files you're looking for.

If the data you want to import is located on a web page on the internet and not on your computer, you can copy and paste from the web page to a new Excel worksheet.

you need to know how the columns are separated, such as comma or tab.

Unless your html page has code that outputs to a delimited file.