Exclude certain class of table data from XMLIMPORT

Question

I'm trying to retrieve the data from the table on this website, in Sheets:

https://www.basketball-reference.com/leagues/NBA_2021_totals.html

When I use this simple formula: =IMPORTXML(A1,"//tr"), I am able to get the whole table BUT it is including the table headers that show up every 20 rows: RK, Player, Pos, Age, Team, etc...

Is there a way to only fetch the table rows with player data?

score 1 · Accepted Answer · answered Jan 05 '21 at 19:24

1

use:

=QUERY(IMPORTXML(A1, "//tr"), "where Col2 <> 'Player'", 1)

answered Jan 05 '21 at 19:24

player0

124,011
12
67
124

Exclude certain class of table data from XMLIMPORT

1 Answers1