Google Sheets IMPORT functions · error message

Google Sheets: Could not fetch url

RetryableFetching the URL

Last verified

The exact message
Could not fetch url: https://example.com/page

What it means

This #N/A error comes from IMPORTXML, IMPORTHTML, IMPORTDATA or IMPORTFEED. It means Google's servers tried to download the URL and the request failed before any content could be parsed. The fetch happens from Google's data centers, not from your browser, so the page opening fine on your own machine proves very little.

The function never got as far as reading your XPath, table index or CSV, so nothing about the second argument is being judged yet. The message is about the network request only.

What is usually not wrong: your formula syntax. A malformed formula gives a parse error instead. If the URL loads in an incognito window but Sheets still cannot fetch it, the site is most likely refusing requests from Google's fetcher, timing out, or redirecting to something Sheets cannot follow, such as a login or consent page.

What it looks like

=IMPORTXML("https://www.example-shop.com/product/123", "//span[@class='price']")

#N/A
Could not fetch url: https://www.example-shop.com/product/123

Why it happens

  • The site blocks or rate-limits requests coming from Google's IP ranges or user agent, a common policy on retail, finance and social sites.
  • The URL is missing its protocol, contains a typo, or points to a host that does not resolve.
  • The server took too long to respond, or returned an error status such as 403, 429 or 5xx.
  • The URL redirects to a login, cookie-consent or bot-check page that requires a browser session.
  • Too many import formulas in the same spreadsheet are hitting the same domain at once, so the site throttles the later ones.

How to fix it

  1. Copy the URL into an incognito browser window. If it fails there or asks you to sign in, IMPORT functions cannot reach it either.
  2. Make sure the URL includes https:// and is in quotation marks or in a referenced cell, as Google's documentation requires.
  3. Test the same formula against a simple public page you control, such as =IMPORTXML("https://example.com", "//title"). If that works, the problem is the target site, not Sheets.
  4. Reduce the number of import formulas pointing at the same domain and spread them across time instead of recalculating them all at once.
  5. Check whether the site offers an official API, RSS feed or CSV export; those endpoints are usually reachable from IMPORTDATA or IMPORTFEED when the HTML page is not.
  6. If the site consistently blocks Google's fetcher, move the job to a tool that fetches from a real browser session.

How to stop it recurring

Point import formulas at endpoints that are meant to be machine-read: public APIs, feeds and published CSVs. Keep the number of fetches per domain low, and avoid volatile tricks that force every formula to refetch at once. For sites that actively block automated clients, IMPORT functions are the wrong tool; a longer walkthrough of the options is in the IMPORTXML could-not-fetch guide.

Official documentation: support.google.com/docs/answer/3093342. See all Google Sheets error messages or the Google Sheets limits and quotas.

Related errors

Definitions

Quick answers

What does "Could not fetch url" mean in Google Sheets?

This #N/A error comes from IMPORTXML, IMPORTHTML, IMPORTDATA or IMPORTFEED. It means Google's servers tried to download the URL and the request failed before any content could be parsed. The fetch happens from Google's data centers, not from your browser, so the page opening fine on your own machine proves very little.

How do I fix "Could not fetch url"?

1. Copy the URL into an incognito browser window. If it fails there or asks you to sign in, IMPORT functions cannot reach it either. 2. Make sure the URL includes https:// and is in quotation marks or in a referenced cell, as Google's documentation requires. 3. Test the same formula against a simple public page you control, such as =IMPORTXML("https://example.com", "//title"). If that works, the problem is the target site, not Sheets. 4. Reduce the number of import formulas pointing at the same domain and spread them across time instead of recalculating them all at once. 5. Check whether the…

When an IMPORT formula cannot read the page

IMPORTXML and IMPORTHTML only see the HTML the server sends. An Autonoly extraction step reads the page in a real browser and writes rows to Google Sheets. Sites that block automated visitors can still block it.

Also see Google Sheets integration.