Google Spreadsheet - How to import specific table from Wikipedia?
I'm currently using this to import a table from Wikipedia:
=IMPORTHTML("https://en.wikipedia.org/wiki/2020%E2%80%9321_Premier_League";"table";6)
It takes the 6th table from that Wikipedia page, which is the "results table" for the Premier League (football). It nicely imports the data in a 21 row x 21 column matrix.
But from time to time, people add new tables to that Wikipedia page, changing the order of the tables. The target table no longer becomes the "6th table".
Question: Is there a different way to directly import the "results table" instead of the taking the table number? (I tried fooling around with the function importxml but I don't know how to use XPath.)
Solution
try:
=IMPORTXML("https://en.wikipedia.org/wiki/2020%E2%80%9321_Premier_League",
"//table[@class='wikitable plainrowheaders']/tbody/tr")
- How can I save the URL(s), after making a copy (event) of a Google Sheets spreadsheet?
- How to make previous dates data from one tab appear in another tab
- Is it possible to generate a summary table of another table?
- Delete last row with value then find
- Replace form response email address with name from master list
- How do I show data from a spreadsheet? it shows "undefined"
- Extract multiple sparsely packed responses to yes/no identifiers while preserving row information
- getLastRow() in Apps Script returns error: "This operation is not allowed on cells in typed columns."
- I can't convert 46809654.36 into a date and time value in Google Sheets
- Google Spreadsheet Last X Rows
- Select rows that contain a specific dropdown value
- How to negate 'isblank' function
- Is it possible get Image from Google Sheets to Google Docs Template when creating
- Byrow formula with reference to last row and last column
- Dynamically update variable in Spreadsheet popup UI element from google Apps Script
- find a column where specific rows contain specific values
- Inserting images into a Sheet as BlobSource using Google Apps Script
- Slack to Google Sheets integration "dispatch failed" error from slash command
- How to make an auto-timestamped row in Google Sheets
- Get the list of all spreadsheets associated with Google account using Sheets API v4
- Conditional criteria in a query formula
- How to Append an Executable SUM Formula to Google Sheets Using Python?
- Using IF and ignoring blanks
- Spreadsheet database with html
- How to select subset of a range in Google Spreadsheet?
- Google Sheets - Index, Match, & Importrange - What is wrong with my formula?
- Vlookup function for criteria contained in a multiple selection drop down list
- How to send pdf email attachment by an Event trigger in Google Apps Script?
- Allow script to edit locked cells
- How to join unique strings in their own column with QUERY?