it365 Toolbox Home Page

it365 Web Table to Excel Tool

Instructions for use: If you need to import the table in a web page into Excel, first copy the entire web page content and paste it into the input box of the program. The program will automatically recognize all the tables from the input content and download the table file with one click.
You only need to copy the webpage and paste it to save the webpage table as an Excel file.
Importing an Excel spreadsheet into a web table is as simple and fast! There is no need to cumbersome operations such as "importing external data" and "new WEB query" in Excel.
Paste some web tables into Excel and display them incorrectly. You can also use this program to solve them. It is recommended to use Chrome Google Chrome to access this program, browsers such as IE may not be normal.
If you want to convert the table in a web page to Excel, first select all the pages (Ctrl+A), then copy and paste them here. The program will automatically detect the table and download the Excel file converted from the web table.

Detected Table

No table has been detected yet, you can try copying a page containing the table and pasting it into the input box. You can also experience using sample data.
it365 Web Table to Excel Tool | table export excel | web table export to excel | table exporter | table export tool | html web table export excel .xlsx file | data table export tool | table export excel chrome extensions program | web table exports excel Firefox extensions | Export multiple web table to excel .xlsx | Batch export of multiple web table to excel | web table to csv | save table to csv | web table to html | table export CSV browser extensions program | table to CSV browser plugin | web table to html | save web table to html | copy web table to excel | copy table from web | copy web page table to excel | copy paste table web page | copy table from web page | copy web table into excel | copying table from web to excel | vba copy web table to excel | Web table import into Excel | excel data from web table | excel import web page source | excel import web data table | Excel import web data | Excel import web page | Excel import web table form | web table to excel | html table to excel .xlsx | web table to excel browser extensions | data table to excel free chrome extensions | paste table into excel | paste table from html to excel | paste table in google docs | paste table from web table to excel | paste table from pdf to excel | paste web table to excel | Web table is inserted into the Excel table | Batch import of web table into Excel spreadsheets | Excel batch import multiple web table | Solve the problem of the webpage pasting data into the table that cannot be displayed normally. | Paste the table form contents of the page to Excel | Paste the contents of the table on the web page to Excel. What should I do? | Copy the table inside the web page to the Excel table | Quickly copy the table from the web page to the Excel table | How to copy the table from the web page to the Excel/WPS table | Solve copying the contents of the page to the Excel exception. | How to quickly copy a table from a web page to EXCEL | Solution After the contents of the table on the web page are pasted into the Excel table, the content is in the first line | Resolve the contents of similar table on the web page to copy to Excel display is not normal | div similar web table like copy to excel | Web page table export Excel browser plugin | Web table Export Excel Chrome Extension Program | Web page table export CSV comma separated value file Chrome extension program | Web page table bulk export xlsx table | Save the page as an Excel spreadsheet file | Save the web table as an Excel spreadsheet file | How to quickly import web table into Excel | How to import web table data with Excel | Paste the table content of the web page | How to copy the web table? | Copy data from web page to excel | Paste the web table to excel | Web page data copy to WPS table | How to directly import a table on a web page in Excel | Web Table Export Excel Firefox Firefox Plugin | Web page table converted to Excel table file | html page table converted to xlsx table | The paste of the web table into Excel is very messy, why is it solved? | Save webpage data | Save the web page as an HTML file |
Instructions for use: If you need to import the table in a web page into Excel, first copy the entire web page content and paste it into the input box of the program. The program will automatically recognize all the tables from the input content and download the table file with one click. <br><strong>You only need to copy the webpage and paste it to save the webpage table as an Excel file. </strong> <br>Importing an Excel spreadsheet into a web table is as simple and fast! There is no need to cumbersome operations such as "importing external data" and "new WEB query" in Excel. <br><strong>Paste some web tables into Excel and display them incorrectly. You can also use this program to solve them. </strong> It is recommended to use Chrome Google Chrome to access this program, browsers such as IE may not be normal.

Sample data

You can copy these sample data, paste it into Excel for testing, or paste it into the input box test of this program to experience the effect of quickly converting the table table to Excel.

Example 1 Pasteing this web page into Excel is not normal, but using this program can solve this problem. Paste this table into this program input box and export the Excel spreadsheet file directly
黑龙江哈尔滨[联通]
天津市 联通
16ms
55
福建泉州[电信]
上海市 电信
21ms
54
广东佛山[电信]
上海市 电信
26ms
52
江苏宿迁[电信]
广东省深圳市
27ms
52
山东枣庄[电信]
天津市 联通
24ms
47
Example 2 Normal web table, can be pasted into Excel after manual copying
List of countries by Human Development Index(2018) wiki
1  挪威 0.953 ▲ 0.002
2  瑞士 0.944 ▲ 0.001
3  澳大利亚 0.939 ▲ 0.001
4  爱尔兰 0.938 ▲ 0.004
5 ▼ (1)  德国 0.936 ▲ 0.002
6  冰岛 0.935 ▲ 0.002
7 ▲ (1)  香港 0.933 ▲ 0.003
8  瑞典 0.933 ▲ 0.001
9 ▼ (1)  新加坡 0.932 ▲ 0.002
10  荷兰 0.931 ▲ 0.003
11 ▼ (1)  丹麦 0.929 ▲ 0.001
12  加拿大 0.926 ▲ 0.004
13 ▼ (1)  美国 0.924 ▲ 0.002
14  英国 0.922 ▲ 0.002
15  芬兰 0.92 ▲ 0.002

Tip: If you want to copy the table of a web page into Excel: 1. Select the entire web page; 2. Paste it into the input box; 3. Then you can download the Excel file converted from the web table.

Release Notes

  1. 2.0.0

    • New function: For some webpages to be pasted into Excel, it can't be displayed normally. After the webpage table is pasted into Excel, a table becomes a column, all of which are confused and typeset together, and special processing is done to ensure that the webpage table is displayed after exporting to Excel. .
    • This is a difficult point of this program and has been solved. This issue has been fixed by testing multiple pages at this time.
    • Why is the page table pasted into Excel messy? How to solve it? The reason is that most of the tables are done using HTML <table> tags, but some pages are not made with table tags, which causes the copying of the web page to be pasted into Excel. This program currently resolves this issue.
    • The program automatically detects the contents of a table like a table, converts it to a table, and supports fast export of Excel xlsx files.
    • New feature: The web table converts CSV, and the table of the web page can be saved as a CSV (comma separated value) file.
    • New function: The web table converts HTML, the table of the web page can be saved as an HTML file, and the complete data can be viewed by opening.
    • New feature: After pasting the content of the webpage in the input box, you can save the input content as an html webpage file. For some webpages, Ctrl+S can't be viewed normally after saving. The webpage saved by this method can solve the problem of saving such webpages.
  2. 1.0.0

    • it365 Web Table to Excel Tool is officially online.
    • Specially solve the problem of importing Excel tables into web tables (in other words: Excel to import web tables).
    • If you need to import the table in a web page into Excel, first copy the entire web page content and paste it into the input box of the program. The program will automatically recognize all the tables from the input content and download the table file with one click.
    • The copied web page contains multiple tables, and can also download Excel files of all tables in batches.
    • Compared to Excel operation: "Import external data", "New WEB query", etc., can import web tables into Excel, this program is much simpler.
View all version update records

Thank You

Thank You
This program is developed from the beginning to the end, from scratch, and can not be separated from everyone who is enthusiastic.
This program uses some open source software in addition to the code written by the team. Thanks to the programmers who contributed to open source, thanks to the selfless dedication programmers who open their own code and contribute to the whole society and become all human beings. Common resources that can be used.
Sincerely thank you.