Excel batch to html,html convert to Excel

In the work often encounter the problem of conversion, such as the author today on the site to see a good table, but this table is the top of the page, the site does not provide downloads, this time how to download this form, and complete the conversion to Excel?

　Turn HTML on the Web into Excel

If you see a good table on a Web site now and want to download and import it into Excel, the method is simple.

① first click Save as in file on the browser, and then select the Save type as HTM or HTML format.

② then open Excel, create a new blank table, click Data on the menu--> import external Data--> import data;

③ Find the Html you just saved, click Open, click Import, and in the pop-up Import data window you can select existing sheet, new worksheet, and click OK.

OK, now look at the HTML so the table has been fully imported into Excel? Do it yourself, I believe, and you make the form is no different.

Tip: Some friends will open HTML directly in Excel when you convert HTML to Excel, which may cause the grid in Excel to not display correctly.

Excel to HTML format

The word federation above explains the way to turn HTML into Excel, and here's how to turn Excel into HTML!

Click File--> on the menu bar in Excel to save as, and then in the Save As window that pops up, select Web page (*htm;*html) format.

If you have a large number of tables, now want to convert all to HTML format, I recommend a software here, you can batch conversion, very good.

　　Click to download : Excel bulk turn HTML software