Importing tables into google spreadsheet with xml

bruirCucH

New Member
http://www.baseball-reference.com/players/p/pujolal01-bat.shtmlOn that website I want to import the standard batting 2013 PA (Plate appearances) box into a google spreadsheet. I have managed to get the entire standard batting table along with some other stuff using the function \[code\]=importxml(A1,"//div[@class='stw div_batting_type']|//tr[@class='full']")\[/code\]In A1 is the URL. I have tried to get more specific by adding id and data row parts to the function but it either doesn't change or doesn't work. If anyone could help me get the function to only import that box it would be greatly appreciated. I am new to this so forgive me if the answer is obvious. Thank you.
 
Top