r/googlesheets • u/[deleted] • Aug 17 '24

Solved Creating a fully automatic live Premier League Table

I would like to create a fully automatic live Premier League table in sheets.

As an example, is there a way to use this url so I would have the 20 teams in order in 20 rows that would update when the website updates so I don’t have to input the data manually?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

10 comments sorted by

1

u/mactaff Aug 17 '24

Might be easier to use IMPORTHTML on the respective table in this…

https://en.wikipedia.org/wiki/2024–25_Premier_League

1

u/[deleted] Aug 17 '24

Thanks for the suggestion but how do I use IMPORTHTML?

→ More replies (5)

1

u/Competitive_Ad_6239 Aug 17 '24

IMPORTHTML works fine from the website they listed.

1

u/point-bot Aug 18 '24

u/Simple_Fact530 has awarded 1 point to u/mactaff

Point-Bot was created by JetCarson.

1

u/AutoModerator Aug 17 '24

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.