# Website to google sheet

**URL:** <https://community.glideapps.com/t/website-to-google-sheet/50920>\
**Category:** Ask for Help\
**Created:** [October 5, 2022, 12:13pm UTC](https://community.glideapps.com/t/website-to-google-sheet/50920 "2022-10-05T12:13:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\
**Post date:** [October 5, 2022, 12:13pm UTC](https://community.glideapps.com/t/website-to-google-sheet/50920/1 "2022-10-05T12:13:58Z")

</div>

I want to import some data from a website to my google sheet. I’m most interested in the first section “Totals”.  
I have tried typing this in my google sheet: =IMPORTHTML(“[BC Copenhagen-Teamstats - Basketligaen](https://basketligaen.dk/bc-copenhagen-teamstats/)”,2)  
But the number 2, seems to be a problem, Idk why thought.

Website: [BC Copenhagen-Teamstats - Basketligaen](https://basketligaen.dk/bc-copenhagen-teamstats/)

---

<div class="post-metadata">

**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\
**Post date:** [October 5, 2022, 7:02pm UTC](https://community.glideapps.com/t/website-to-google-sheet/50920/2 "2022-10-05T19:02:02Z")

</div>

Maybe this website is better: [theView Copenhagen basketball, News, Roster, Rumors, Stats, Awards, Transactions, Details-eurobasket](https://basketball.eurobasket.com/team/Denmark/theView-Copenhagen/1159?Page=3)

---

<div class="post-metadata">

**Author:** ![Alexander\_Rubino](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alexander_rubino/32/48638_2.png) [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)\
**Post date:** [October 5, 2022, 7:33pm UTC](https://community.glideapps.com/t/website-to-google-sheet/50920/3 "2022-10-05T19:33:03Z")

</div>

I have experimented with this:  
=IMPORTXML(“[https://basketligaen.dk/bc-copenhagen-teamstats/“,”//\*[@id=‘hs-container’]/div/div/div/div/div[2]](https://basketligaen.dk/bc-copenhagen-teamstats/%22,%22//*%5B@id='hs-container'%5D/div/div/div/div/div%5B2%5D)”)

However, it can’t find the data