使用 IMPORTHTML 导入 Web 数据 （19/20）

没有多少人知道 Google 表格提供了从 HTML 页面或站点上的表格或列表导入数据的特殊功能。此函数称为 IMPORTHTML。它会自动将数据从网站提取到 Google 表格中。

First, copy the URL of the website you want to extract data from. Next, go to Insert tab → Function→ Web →IMPORTHTML. This will open a pop-up window. Next to IMPORTHTML, you will see brackets. Put inverted commas inside the brackets and paste the URL you copied earlier between them. Type another set of inverted commas and specify the query. Hit ENTER, and the entire table from the website will be imported to the sheet within seconds.