How do I return data from website using ImportXML into separate columns Google Spreadsheets?-CodePudding

I'm using ImportXML in a Google Spreadsheet to input the population demographics from the website

for a single N value you can also use:

=QUERY(IMPORTXML("https://www.socialexplorer.com/profiles/essential-report/zcta5-48105.html", "//div[contains(@class,'c-num')]"),"Select Col1 Where Col2='Population'")

**the formula is hardcoded to Population here; you may change it to Square Miles OR People Per Square Mile

CodePudding user response：

use:

=TRANSPOSE(QUERY(IMPORTXML(
 "https://www.socialexplorer.com/profiles/essential-report/zcta5-48105.html", 
 "//div[contains(@class,'c-num')]"),
 "select Col1 limit 4",-1))