Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Separate XML data with Import XML on Google Sheets

I am using IMPORTXML in Google Sheets to data pictured from https://www.sherdog.com/fighter/Kelvin-Gastelum-74700

The data output is contained in cell A1. What custom function would I need to separate the data into fields and records as it is displayed on the website?!

Kelvin Gastelum Sherdog
Output

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

I tried using a custom function without success.

>Solution :

Try

=importhtml(url,"table",2)

you have 9 tables, so you can try =importhtml(url,"table",1) to =importhtml(url,"table",9)

enter image description here

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading