I am trying to import table data into a Google spreadsheet using the below function:

=ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 )

Following is the result I get out of it.

Screenshot of table result

But I didn’t want the content in row 1,2,3 & 4 to be displayed so I tried the query as following and got the below result:

=QUERY(ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 ), "SELECT * OFFSET 0")

Screenshot 2

But I’m still getting the NCT of Delhi content in row 1. How can I get rid of that and show only row 2 and onwards that contains the area name and subsequent data?

1 Answer 1


I got it to work with this:

=QUERY(ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 ), "SELECT * where Col2>0",0)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.