Google-sheets – Import table using IMPORTXML

google sheetsimportxml

I am trying to import a table from the lower part of following website to Google Sheets:

I used the formula:


but the output is messy and contains many other data outside the table.

Anyone help?

Best Answer

You seem to have forgotten to mention what you would consider tidy, but it should be easier to handle your data (assumed to be starting in A1) with a formula such as:


in B1 and the same again in C1 with an extra +1 immediately before the ,0 - both copied down to suit.