Solutions & Archives

Home > Trainings & Communities > Solutions & Archives > Using Google Sheets

Using Google Sheets - follow the "IMPORTHTML" with query function by modifying the formula bar

Using the sample1 worksheet, the formula was written in Cell "A2" example: =query(IMPORTHTML("https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)","table",1),"Select Col1,Col2,Col3")

Using the sample2 worksheet, the formula was written in Cell "A2" example:

=query(IMPORTHTML("https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)","table",1),"Select * where Col2='Europe'")

Using Google Sheets - follow the "IMPORTRANGE" function by modifying the formula bar

Using the Sheet1 worksheet, the formula was written in Cell "A1" example: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/127Mw_lITAxjct8bFX9mSga3Y77UhBerpmWO9q0LLX2Q/", "Sample1!A1:E50")

Using the Sheet2 worksheet, the formula was written in Cell "A1" example:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/127Mw_lITAxjct8bFX9mSga3Y77UhBerpmWO9q0LLX2Q/", "Sample2!A1:E50")

Inquire about more issues that we may able to solve and provide guides.

Note: We accept Cash payment after the Service, Electronic or Gcash payment.