Member Avatar for Russ_1

Hi,

So, I'm trying to do what's presented in this Quora thread:

http://www.quora.com/How-can-I-export-YouTube-comments-into-a-spreadsheet

I want to know how to frame the parameters for a YouTube video's comment feed, the comment author, and the comment text itself, using =ImportXML for Google Docs. My Xpath is weak -- can't figure out the right <div> containers for the elements I need.

Any help would be appreciated.

  • 2 Contributors
  • 3 Replies
  • 207 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by DaveAmour
Member Avatar for DaveAmour

If you have a look at Altova xml spy, with that you can point and click at items and it will tell you what the xpath is. Its free for a 1 month trial.

Member Avatar for Russ_1

Any hints on how to do this using Altove xml spy? It's not exactly self-explanatory.

Member Avatar for DaveAmour

This is off the top of my head but open the xml in design view and the maybe just right click on the node you want and it should be there - if not I shall have to download it and have a look.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.