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.
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.
IMPORTHTMLimports a table or a list from a page Source 1:=IMPORTHTML(returns the first table."https:// example.com/ prices", "table", 1) IMPORTXMLreaches 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
UrlFetchAppSource 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.
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.
| Event | Starts | Ends | Hall | Organizer | Link |
|---|---|---|---|---|---|
| Northern Packaging Expo | 2027-03-09 | 2027-03-11 | Hall A | Packline Media | …/events/packaging-expo |
| Cold Chain Forum | 2027-03-23 | 2027-03-24 | Hall C | Frostway Events | …/events/cold-chain-forum |
| Harbor Craft Beer Fair | 2027-04-17 | 2027-04-18 | Hall B | Tidewater Brewers Guild | …/events/craft-beer-fair |
| Regional Robotics Open | 2027-05-08 | 2027-05-09 | Hall A | Lakeshore STEM League | …/events/robotics-open |
From install to a filled sheet
Add BrowseWiz to Chrome
Install the extension, open its side panel and sign in when asked.
Describe the data
Name the page, the columns and the sheet, like the request above, and send it.
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.
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
IMPORTHTMLorIMPORTXMLreturns 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
For a table on a public page, type =IMPORTHTML( in a cell Source 1. For other values in the page's HTML, use IMPORTXML with an XPath query Source 2. When the data loads with scripts, needs your login or spans many pages, describe it to BrowseWiz, and it fills a new Google Sheet from your own Chrome.
Yes, within limits. IMPORTHTML, IMPORTXML and IMPORTDATA check for updates every hour while the document is open Source 3. They read the HTML Google's servers download, so they miss data that scripts load and pages behind a login Source 4. For those pages, a BrowseWiz scheduled task refreshes a sheet up to once a day while Chrome is open.
Copy and paste works for one small table, and IMPORTHTML needs a URL, the word "table" or "list" and its number on the page Source 1. For anything harder, BrowseWiz takes a request in plain words: name the page, the columns and the sheet. It opens the pages in your own Chrome and writes the rows, with no XPath, selectors or scripts to maintain.
Not with a formula. Import functions fetch the page from Google's servers, without your browser session Source 4, so they get what a signed-out visitor gets. A tool that works in your own browser can. BrowseWiz opens the page in your Chrome, where you're already signed in, and never asks for your password. Scraping a website behind a login has the details.
Yes, if you can write JavaScript. UrlFetchApp fetches a URL Source 5, and a time-driven trigger runs your script on a schedule Source 6. It suits data a site offers as JSON at a public URL. The script fetches from Google's servers Source 5, without your browser session, so data the page's scripts add is missing, and pages behind your login are hard to reach.
There is a free plan with 10M credits a month, 1 scheduled task and 1 monitor. Pro costs Regular price $35 $17.50 a month with 250M credits, and Max costs Regular price $95 $47.50 a month with 1B credits. Prices include VAT. How far the credits go depends on how much page text each run reads.
Related pages
- Use caseAutomatically update Google Sheets from a websiteDescribe the data once and BrowseWiz updates a Google Sheet on a schedule, even from pages behind your login. Up to once a day, at the time you set.
- Use caseScrape a website that requires a login into Google Sheets, from your own ChromeScrape data behind a login with no code, no shared password and no cookie export. BrowseWiz reads sites you're signed into in Chrome and fills a Google Sheet.
- IMPORTXML troubleshootingIMPORTXML not working? How to fix it, and an alternative when you can'tWhy IMPORTXML and IMPORTHTML return empty or #N/A, how to fix the XPath, and what to use when the page needs JavaScript or a login.
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 freeSources
- Google Docs Editors Help: IMPORTHTML (opens in a new tab)support.google.com, checked
- Google Docs Editors Help: IMPORTXML (opens in a new tab)support.google.com, checked
- Google Docs Editors Help: Learn more about Import functions (opens in a new tab)support.google.com, checked
- Stack Overflow: Scraping data to Google Sheets from a website that uses JavaScript (opens in a new tab)stackoverflow.com, checked
- Google Apps Script reference: Class UrlFetchApp (opens in a new tab)developers.google.com, checked
- Google Apps Script: Installable triggers (opens in a new tab)developers.google.com, checked
- Web Robots: Instant Data Scraper (opens in a new tab)webrobots.io, checked