How to get data from a website into Google Sheets

Updated

To get data from a website into Google Sheets, paste a small table, use IMPORTHTML or IMPORTXML for a public page whose data is in its HTML, or write an Apps Script. When the data loads with scripts, needs your login or spans many pages, describe the rows to BrowseWiz, and it fills a new sheet from your own Chrome.

Add to Chrome – it's free

Five ways, from the simplest to the most capable

Use the first one that reaches your data. Each way below says what it reads and where it stops.

  • 1. Copy and paste. Select a table in your browser, copy it and paste it into a sheet. A pasted table usually keeps its rows and columns. It's the fastest way for one small table you need once. It gets slow when the data spans several pages or sits in cards, and you do it again by hand whenever the site changes.
  • 2. IMPORTHTML and IMPORTXML. IMPORTHTML imports a table or a list from a page Source 1: =IMPORTHTML("https://example.com/prices", "table", 1) returns the first table. IMPORTXML reaches other values in the page's HTML with an XPath query you write Source 2. Both check for new data every hour while the document is open Source 3. Both read the HTML that Google's servers download, without the page's scripts or your login Source 4, so a page that loads its data with JavaScript, or shows it only after sign-in, comes back empty. The IMPORTXML troubleshooting guide shows how to tell which case you have.
  • 3. Apps Script. Google's scripting tool for Sheets can fetch a URL with UrlFetchApp Source 5 and run on a timer with a time-driven trigger Source 6. It fits a site that offers its data as JSON at a public URL. You write and maintain JavaScript. The script fetches pages from Google's servers, not from your browser Source 5, so it works with your computer off, but pages you sign into are hard to reach.
  • 4. A scraper extension. Instant Data Scraper is one example. It detects a table or list on the page you have open and saves it as a CSV or Excel file Source 7, which you then import into Sheets. It runs in your browser Source 7, so it works on pages you're signed into, and it can click a Next link to combine several pages into one file Source 7. You get a file, not a sheet that stays current, and the page from Web Robots, which built it, doesn't describe opening each item's own page Source 7. The Instant Data Scraper comparison looks at it in detail, next to a scraper that connects to Google Sheets.
  • 5. BrowseWiz. A Chrome extension with an AI agent. You describe the rows and columns in plain words. It opens the pages in your own Chrome, reads them after their scripts have run and with the logins you already have, and writes the rows into a new Google Sheet in your Drive. It can go through numbered pages, open each item's page and repeat the job on a schedule. It costs credits and is slower than a formula, so use it when the ways above can't reach your data.

Which way fits your page

Use copy and paste or a formula if…

  • The data is one table or list on a public page, and you can find it in View page source.
  • A sheet that refreshes only while the document is open is fine for you.

Use Apps Script if…

  • You or a teammate can write and maintain JavaScript.
  • The site offers the data as JSON at a public URL.
  • You need it to run while your computer is off.

Use a scraper extension if…

  • You need the rows once, as a file.
  • Everything you need is on the list page that's open in your browser.

Use BrowseWiz if…

  • The page loads its data with scripts, or shows it only after you sign in.
  • The details are spread over many pages: numbered pages, or a page per item.
  • You want the rows in Google Sheets, refreshed on a schedule, without writing XPath or code.

Describe the rows instead of building a scraper

Say you plan your company's trade-show year. The convention center near you lists its events ten to a page, and each event's organizer is on the event's own page. There is no one table for a formula to import, and copying it by hand means opening every event.

What you type

Open the events calendar at harborconvention.example/events and go through every page. For each event from March to June 2027, open its page and get the event name, start date, end date, hall and organizer. Create a Google Sheet called "Harbor events 2027" with the columns Event, Starts, Ends, Hall, Organizer and Link, one row per event. Put the link to the event's page in Link.

Swap in your page's link and your columns. Ask only for what the pages show: BrowseWiz writes what it reads and adds nothing from other sources.

The sheet you get

BrowseWiz creates the sheet in your Google Drive and writes one row per event. The Link column takes you back to the page each row came from, so you can check any value.

Example: Harbor events 2027: 4 of 23 rows (fictional events)
EventStartsEndsHallOrganizerLink
Northern Packaging Expo2027-03-092027-03-11Hall APackline Media…/events/packaging-expo
Cold Chain Forum2027-03-232027-03-24Hall CFrostway Events…/events/cold-chain-forum
Harbor Craft Beer Fair2027-04-172027-04-18Hall BTidewater Brewers Guild…/events/craft-beer-fair
Regional Robotics Open2027-05-082027-05-09Hall ALakeshore STEM League…/events/robotics-open

From install to a filled sheet

  1. Add BrowseWiz to Chrome

    Install the extension, open its side panel and sign in when asked.

  2. Describe the data

    Name the page, the columns and the sheet, like the request above, and send it.

  3. Check and approve the plan

    BrowseWiz replies with a plan: which pages it opens and which columns it writes. Nothing runs until you approve. Then grant tab access and sign in to Google once when asked.

  4. Watch the rows arrive

    It opens the pages in the BrowseWiz Tabs group in your own Chrome, using the sessions you already have, and never asks for your passwords. See how the browser agent works.

Keep the sheet current, or go behind a login

A sheet filled once goes stale. Ask BrowseWiz to repeat the request on a schedule, up to once a day, and each run updates the same sheet while Chrome is open. Updating a Google Sheet from a website automatically covers schedules, logs and updates in place.

The same kind of request works on pages you sign into, such as a supplier portal or an admin panel, because the pages open in your own Chrome. Scraping a website behind a login shows what your account's view adds and what stays on your computer.

For prices, add an alert. The Google Sheets price tracker pairs a price sheet with a monitor that tells you when a price crosses your limit.

What to know before you start

  • A formula is free, and BrowseWiz isn't. If IMPORTHTML or IMPORTXML returns your data, keep the formula. It runs on Google's servers and costs nothing.
  • Chrome has to be open. BrowseWiz works in your browser, so a scheduled run happens only while your computer is on and Chrome is open. This isn't a 24/7 service.
  • Only what the pages show. It writes what the pages display. It doesn't guess missing values or add data from other sources.
  • It reads pages the way you would. It opens them one by one in your Chrome, so it fits a list you'd otherwise copy by hand. For a whole site with thousands of pages, use a cloud scraping service.
  • Results can vary. An AI model reads each page, so check the first run against the site. The Link column makes that quick.
  • A sheet BrowseWiz creates. It writes the rows into a new sheet in your Google Drive, and later runs update that one.
  • The site's terms apply. Some sites limit copying or automated visits. Read the terms before you collect or schedule anything: you're responsible for following them.
  • Chrome's warnings. BrowseWiz asks for access to all websites so it can open and read whichever page you name, and for the page debugger to keep a background tab it opened drawing while you use another tab. Chrome warns about both at install, and shows a debugging bar across the browser whenever BrowseWiz works in such a tab, including during scheduled tasks and monitors. See what Chrome's warnings mean.

What BrowseWiz costs

Start on Free: it includes 10M credits a month, 1 scheduled task that runs up to once a day and 1 monitor. Credit use depends on how much page text a run reads, so opening every item's page uses more than reading one list. At about 2M credits a run, a daily task needs Pro.

  • Free

    $0 / month

    • 1 scheduled task, up to once a day
    • 1 page monitor
    • 10M credits a month
  • Pro

    Regular price $35 $17.50 / month

    • Up to 10 scheduled tasks, up to once a day
    • Up to 30 page monitors
    • 250M credits a month
  • Max

    Regular price $95 $47.50 / month

    • Up to 10 scheduled tasks, up to once a day
    • Up to 30 page monitors
    • 1B credits a month

Early adopter price: 50% off for as long as you stay subscribed. Offer terms. Lowest price in the 30 days before the discount: Pro $35, Max $95. Prices include VAT. See how credits are counted.

Questions

Get your first sheet from a website

Add BrowseWiz to Chrome, describe the rows you need and get a Google Sheet back. Free includes 10M credits a month, 1 scheduled task and 1 monitor.

Add to Chrome – it's free