Hi there!
I made a spreadsheet of books that I want to read, and now I want to update it with live info from goodreads.com. The essential 2 fields I want to get are the number of votes and book score (with only the decimals, omitting number 4 & that dot in the end result). If possible, I want to get the book name and author into the sheet too, with links embedded to click from excel.
I've tried to follow instructions on the net about Data => Get external data => From web... but excel can't load goodreads page without failing many scripts, and I can't select the values I want. So, is it possible? Are there any ways to do it kinda automatically? Like, when I want to add a new book to my list, I'll just press some button, paste the book link and it'll retrieve all the above info & paste them neatly into a new row?
Thank you!
I made a spreadsheet of books that I want to read, and now I want to update it with live info from goodreads.com. The essential 2 fields I want to get are the number of votes and book score (with only the decimals, omitting number 4 & that dot in the end result). If possible, I want to get the book name and author into the sheet too, with links embedded to click from excel.
I've tried to follow instructions on the net about Data => Get external data => From web... but excel can't load goodreads page without failing many scripts, and I can't select the values I want. So, is it possible? Are there any ways to do it kinda automatically? Like, when I want to add a new book to my list, I'll just press some button, paste the book link and it'll retrieve all the above info & paste them neatly into a new row?
Thank you!