How to Copy News to Google Sheets to Make It More Simple – Student Zone

Student Room

ipadguides.id – Hello, Friend Zona. Who often gets the task of copying or inputting news and articles into Google Sheets for easy reading?

Instead of inputting one by one, Mimin has a quick way of copying news to Google Sheets like the following. Come on, take a look at the reviews.

Also Read: Easy Ways to Fill Blank Cells According to the Cells Above in Microsoft Excel

Steps

  • Open Google SpreadSheets and enter the formula =IMPORTHTML(“URL”, “QUERY”, Index). Here, the number 10 is the number of links you want to attach in Google SpreadSheets. Meanwhile, Quiery can play with a table.
Google SpreadSheet Image (Photo: Student Zone Team)
  • For example, Mimin wants to copy an article entitled “The COVID-19 Pandemic in Indonesia”, then the formula is =IMPORTHTML(“https://id.wikipedia.org/wiki/Pandemi_COVID-19_di_Indonesia”, “Table”, 10).
Google SpreadSheets Image (Photo: Liputan6)

How to Copy News to Google Sheets To Make It More Simple

That’s Mimin’s review of how to copy news to Google SpreadSheets to make it easier and easier to read. Come on.

Hopefully this review is useful for Friend Zone. Don’t forget to keep abreast of information about students and the world of lectures and turn on notifications. See you later.

Also Read: How To Quickly Organize Excel Tables, Just One Click Done!

Create by ipadguides in category of > Student Room

Related Posts