Illustrates the conversion between Excel and HTML format

At work, you often encounter the problem of conversion, such as browsing the site when you 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? The following 8844 explains how to turn HTML to Excel.

Convert HTML format 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.

1, first click on the browser "Save as" in "file", and then select the Save type as "htm or html" format;

Select the save type as "htm or HTML" format

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

Import data

3, find the Saved "Html" click Open, and then click Import, in the pop-up Import Data window, you can select existing sheet, new sheet, and then click OK.

In the Import Data window that pops up, you can select existing sheet, new worksheet

The Import Data window

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.

Excel to HTML format

It describes how to turn HTML into Excel, and then how to turn Excel into HTML! Click the file--> on the menu bar directly in Excel to save as, and then under the Save As window that pops up, select Web page (*htm;*html) Format can be.

Save Type Select Web page (*htm;*html) format

This is the HTML and Excel format conversion between the introduction, it is easy to understand, the next time you see a good table on the site can be easily converted into Excel format saved.