How to Use ImportXML in Google Sheets to Create Data Studies

Published: 05 May 2020
on channel: Siege Media
16,821
274

Learn how to use Google Sheets to collect, organize, and manipulate unique data.

Subscribe today for weekly tips: https://bit.ly/3dBM61f

In this episode of Content & Links Siege Media's very own Content Marketing Lead, Drew Page, walks us through these lessons:

• Use the IMPORTXML function in Google Sheets to quickly and easily scrape web data.
• Organize data with the TRANSPOSE function in Google Sheets.
• Handle paginated data with URL Concatenation.

Blog Post: https://siegemedia.com/creation/impor...

Show Notes:
Craigslist: https://billings.craigslist.org/searc...
Google Sheets Template: https://docs.google.com/spreadsheets/...
ImportXML: https://support.google.com/docs/answe...
Concatenate: https://support.google.com/docs/answe...
Transpose: https://support.google.com/docs/answe...

Listen on iTunes: https://podcasts.apple.com/us/podcast...
Follow Drew on Twitter:   / drewpager  
Follow Siege on Twitter:   / siegemedia  
Follow Ross on Twitter:   / rosshudgens  
Email Us: [email protected] »

#seo | #contentmarketing


Watch video How to Use ImportXML in Google Sheets to Create Data Studies online without registration, duration hours minute second in high quality. This video was added by user Siege Media 05 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16,82 once and liked it 27 people.