Skip to content
Home Pricing Docs Sign In

Your first scrape

The sidebar writes your =SCRAPE() formulas for you. In this guide, we'll scrape an Amazon product together, one step at a time.

The whole flow from start to finish: pick a platform, fill in the details, tick the fields you want, then insert.

1. Open the sidebar

First, open Extensions → WebToSheets → Open Sidebar in your spreadsheet, then click Sign in to link your account. If you are new to WebToSheets, you will first need to install the add-on.

2. Choosing a page

Next, the New tab offers two convenient ways to begin:

  • Pick a featured platform (Amazon, eBay, Walmart, Google Search, Yahoo Finance), then fill in the specifics, such as a ticker symbol or your search terms. WebToSheets builds the URL for you.
  • Paste a link to any web page, and WebToSheets will automatically work out what kind of page it is.

3. Picking what to extract

Now, tick the fields you want using plain language, such as Price, Rating, or Product name. Nothing is ticked to begin with, so you choose exactly the columns you need.

4. Inserting the formula

Then, select the cell where you would like the data and click Insert in cell. WebToSheets writes the formula into that cell, and the data automatically fills the cells around it.

lightbulb

That's it

Would you like to go further with guided URLs, custom fields, or XPath? Check out The Formula Builder. If you prefer to write formulas by hand, see The =SCRAPE() formula.

Still stuck?

We usually reply within 24 hours on business days.

Contact support arrow_forward