If you find interesting or important data in a table on a website it might be helpful to import it into Excel. Today we will look at how to import data from a table on a website into Excel which will allow you to organize and add to reports.
如果您在网站上的表格中发现有趣或重要的数据,将其导入Excel可能会有所帮助。 今天,我们将研究如何将网站上的表格中的数据导入Excel,这将使您能够组织和添加报表。
Open Excel 2007 and under the Data tab select Get External Data and From Web.
打开Excel 2007,然后在“数据”选项卡下,选择“获取外部数据”和“从Web”。
![Data From Web](https://i-blog.csdnimg.cn/blog_migrate/ad6613290dabf306b0c206e7b8919563.png)
This will open up the New Query window where you enter in the URL of the site you want to get data from. There will be yellow arrow icons next to the table data that can be imported, click the areas of the data you want to import which turns the box to a green checkmark. After you have what you want selected click on the Import button.
这将打开“新建查询”窗口,您可以在其中输入要从中获取数据的站点的URL。 可以导入的表格数据旁边将有黄色箭头图标,单击要导入的数据区域,这会将框变成绿色的选中标记。 选定所需内容后,单击“导入”按钮。
![Select Table](https://i-blog.csdnimg.cn/blog_migrate/c131cbaaebdcf0b5eb25caa508d49877.png)
Next choose the cell where you want the data to appear in the spreadsheet and click OK.
接下来,选择要在电子表格中显示数据的单元格,然后单击“确定”。
![select Cell](https://i-blog.csdnimg.cn/blog_migrate/c0f78fec7a06345ad034209c99566048.png)
The data will begin to be retrieved from the site, the amount of time it takes will depend on the amount of data you selected. Now you can organize the data how you like for presentation.
数据将开始从站点中检索,花费的时间将取决于您选择的数据量。 现在,您可以按照自己的喜好组织数据。
![data](https://i-blog.csdnimg.cn/blog_migrate/a3944d927f91727aa80dc5d73f961c47.png)
This tip comes in very handy when doing research or for easily adding website table data to reports.
在进行研究或轻松将网站表数据添加到报告时,此技巧非常方便。
翻译自: https://www.howtogeek.com/80142/copy-website-tables-into-excel-2007-spreadsheets-2/