How to Pull Live Data From a Website Into Google Sheets

You’re manually copying data from a website into a spreadsheet — prices, stats, rankings, scores — and by the time you’ve finished, half of it has already changed. There’s a much better way. Google Sheets has built-in functions that pull live data from websites automatically and refresh on their own, no copy-pasting required.

Here’s how to pull live data from a website into Google Sheets using three methods — from a one-line formula to a custom script — so you can pick whichever fits your situation.

Before You Start

One important thing to understand upfront: these methods only work on publicly accessible pages. If a site requires a login, blocks bots in its robots.txt, or loads its content dynamically via JavaScript, these formulas will either return an error or fetch incomplete data. For JavaScript-heavy sites, Apps Script is your best option — more on that shortly.

Method 1
IMPORTHTML — Pull Tables and Lists Instantly

IMPORTHTML is the easiest starting point. It’s a built-in Google Sheets function that grabs an HTML table or list from any public webpage and drops the data directly into your cells. I use this constantly for pulling things like Wikipedia tables, sports standings, and financial data tables.

The syntax is:

=IMPORTHTML("URL", "table" or "list", index)

The three arguments: the URL of the page in quotes, the query type — either "table" or "list" — and an index number telling Sheets which table or list on the page to grab (1 = first, 2 = second, and so on).

Real example — Wikipedia table

To pull the first table from Wikipedia’s list of largest companies by revenue:

=IMPORTHTML("https://en.wikipedia.org/wiki/List_of_largest_companies_by_revenue","table",1)

Click an empty cell, paste that formula, and hit Enter. Sheets fetches the data and populates the cells automatically. It refreshes every time the sheet recalculates — typically every hour, or when you force a refresh by pressing Ctrl+Shift+F9.

Method 2
IMPORTXML — Target Any Specific Element on the Page

When you need something more precise than a whole table — a single price, a headline, a product name, or a specific data point — IMPORTXML is the tool. It uses XPath to pinpoint any element on a webpage and pull just that value into your sheet.

The syntax:

=IMPORTXML("URL", "xpath_query")

XPath sounds intimidating but you only need a few patterns in practice. Here are the most useful ones:

Finding the right XPath for any element

In Chrome, right-click the element on the page you want to target and choose Inspect. In the DevTools panel, right-click the highlighted HTML element → Copy → Copy XPath. Paste that directly as your second argument in IMPORTXML. This step trips up a lot of people — they try to guess the XPath manually when the browser will just give it to you.

Method 3
Google Apps Script — Full Control, Any Site

When IMPORTHTML and IMPORTXML aren’t enough — because the data is buried behind an API, a form, or dynamic JavaScript — Apps Script gives you a full scripting environment inside Google Sheets. You write a short JavaScript function, and it fetches, parses, and writes data exactly where you want it. It’s also the only method that lets you schedule automatic refreshes at a specific time interval.

function fetchWebData() {
  var url = "https://example.com/data-page";
  var response = UrlFetchApp.fetch(url);
  var html = response.getContentText();

  // Example: extract text between two markers
  var start = html.indexOf('<span class="price">') + 22;
  var end = html.indexOf('</span>', start);
  var price = html.substring(start, end);

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.getRange("A1").setValue(price);
  sheet.getRange("B1").setValue(new Date()); // timestamp
}

Pro Tips & Common Mistakes