Scrape the Web to Google Sheets in 2 Minutes
Learn how to quickly scrape a list of Time Magazine's 100 all-time novels into Google Sheets using the IMPORTHTML function in just two minutes.
So I want to scrape this entire list of Time Magazine's 100 all time novels. I'll do that with a sheet. We'll do sheet. new. And we'll go to a sheet and we're going to use import HTML. So we're going to call this Times 100 Books. And all we need to do is get the URL. Let's go back, get the URL. We're going to do equals import HTML. And this gets a list or a table from a URL. So, we'll put the URL in here. And then the second thing, the query , will be table . Simply table . The index will be 1, I think it's only going to be the first table on that page. Locale, we can put English, US. Zunaid Asks: How to get Get Meta from URLS? Answer: Use ImportXML()
And what we get out of this is, uh, Question asking to allow access . We'll click allow access , give it a moment, and it will be adding permissions. And now we have this list, but check this out. We have these books here, um, and we have some, other stuff, right? Uh, so we just want the list of books. So we go here to, uh, E1 and we're going to split C1. We're going to split it. It looks like there is a delimiter or the thing between each one is a new line. So we'll do command enter for new line and split by each share true, remove empty text, share true, and we'll get something. Well, we'll get all of the contents of C's. We actually have the author as well, um, but all we want is How Does Split Work? How to Get Every Editor on Every Google File I Own
the name of the book right now. So we'll use index and we'll use this reference to the bottom. We'll add the first row. It's all we need. Uh, we first row, first column, and there we go. We now have a list of every single book on this page. We also can get the author if we just change this second index to, I think, three. Or, this one, yeah, the column to three. And there we go, we have the author and the book. We can take this, make a new sheet, command paste, and we have a list of the times 100 books. We have the author here, and the, uh, sorry, the author here, and the title here, every single book. Basics - Structure of a Sheet: Index() Row() and Column()