Hello. I heard that there is an ability to pull website data into google sheets, specifically using an import function =IMPORTHTML(website addres). However I'm having trouble trying to get it to work. I basically want to pull the data from the following website: The YC Startup Directory | Y Combinator
Essentially, I'm trying to get just the basics on an excel sheet that shows me the Company Name, City Location, State Location, Country, and Description. So using the first few results below, I would like to make it so that the columns and sheets shows the following:
Any advice on how to do this? Thank you!
Essentially, I'm trying to get just the basics on an excel sheet that shows me the Company Name, City Location, State Location, Country, and Description. So using the first few results below, I would like to make it so that the columns and sheets shows the following:
Column A | Column B | Column C | Column D | Column E | |
Row 1 | DoorDash | San Francisco | CA | USA | Restaurant delivery |
Row 2 | Ginkgo Bioworks | Boston | MA | Remote | Our mission is to make biology easier to engineer |
Row 3 | Amplitude | San Francisco | CA | USA | Digital Analytics Platform |
Any advice on how to do this? Thank you!