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")
- Downloading a PDF version of the open spreadsheet in Google Drive via scripts
- exporting spreadsheet to pdf then saving the file in google drive
- How to get last number in a row on Google Spreadsheets
- A Script to Simplify Creating a SO Table
- Archive a row after a dropdown status is selected on multiple sheets
- How to extract URL from Link in Google Sheets using a formula?
- Create list of dates in Google Sheets based on day-of-month schedule
- Get Google Sheet by ID?
- Return Column Based on Column Headers
- Add title row with ARRAYFORMULA in Google Sheets
- Why does my Google Service Account not see files shared with it, but can see files created with it?
- Google Sheets macro to copy a line of data to next empty row on another sheet
- Google Sheets - Auto border to a Dynamic Data
- Fix Google Sheets formula so it will append the header title of each column it is pulling data from, instead of just the first column's title
- VLOOKUP IMPORTRANGE to select the column number in another file also
- Split cell with dates and find matching dates on headers
- How to get the next Bi-weekly date based on a given start date and today's date in Google Sheets
- How can I determine if a respondent's email address is unique in a list?
- ARRAYFORMULA in GOOGLE SHEETS
- Can a google-apps-script be written to download a csv file from spreadsheet directly to a local hard drive with an onEdit trigger?
- API call to directory.members.insert failed with error: Resource Not Found: groupKey
- How to find common words in two columns in Google Sheets
- Get list of unique words without numbers and symbols from paragraph range in Google Sheet?
- Apps Script Delete Image
- App Script to download specific cells in Google Sheet to PDF
- Export Google Docs comments into Google Sheets, along with highlighted text?
- INDIRECT function in an INDEX-MATCH-MATCH
- How to write to a "Google Spreadsheet" from Excel 2003 VBA
- How to use date with LIKE inside query?
- Know if the cell is being used in any formula