Google Sheets: Resource at url not found
Last verified
Resource at url not found: https://example.com/data.csvWhat it means
This #N/A error from IMPORTDATA, IMPORTHTML, IMPORTXML or IMPORTFEED means the server answered, but said there is nothing at that address. It is the spreadsheet's way of reporting a not-found response for the exact URL in the formula.
Because Google fetches the URL itself, without your cookies or session, a URL that works for you while signed in can be not-found for Google. Some sites return a not-found response to unrecognized clients on purpose instead of a clear access-denied status. Redirects to a login page that then fail are another frequent source.
What is not wrong: the function choice or the XPath. Sheets never received a document to query.
What it looks like
=IMPORTDATA("https://reports.example.com/export?id=42&token=abc")
#N/A
Resource at url not found: https://reports.example.com/export?id=42&token=abcWhy it happens
- The URL has a typo, a stale path, or an expired query string such as a signed or time-limited link.
- The resource only exists for signed-in users and returns not found to anonymous requests.
- A shared file link points to a viewer page rather than the raw file (common with cloud storage and BI tools).
- The site deliberately answers automated clients with a not-found response.
- The URL in a referenced cell has leading or trailing spaces.
How to fix it
- Open the URL in an incognito window with no session. If you get a 404 or a login page, that is what Sheets sees.
- Wrap a referenced URL in TRIM() to remove stray spaces.
- For files, use the direct download or published-to-web link, not the preview page URL.
- If the link is time-limited or signed, generate a stable public export URL from the source system instead.
- Retest after a few minutes; if the URL works in incognito but Sheets keeps reporting not found, the site is treating Google's fetcher differently and the import will not be reliable.
How to stop it recurring
Use permanent, public, unauthenticated URLs for every import. When a reporting or storage tool offers a "publish to web" or public CSV link, use that rather than a link copied from your browser address bar. Keep source URLs in one config tab so a moved endpoint is fixed in one place.
Official documentation: support.google.com/docs/answer/3093335. See all Google Sheets error messages or the Google Sheets limits and quotas.
Related errors
Definitions
Quick answers
What does "Resource at url not found" mean in Google Sheets?
This #N/A error from IMPORTDATA, IMPORTHTML, IMPORTXML or IMPORTFEED means the server answered, but said there is nothing at that address. It is the spreadsheet's way of reporting a not-found response for the exact URL in the formula. Because Google fetches the URL itself, without your cookies or session, a URL that works for you while signed in can be not-found for Google.
How do I fix "Resource at url not found"?
1. Open the URL in an incognito window with no session. If you get a 404 or a login page, that is what Sheets sees. 2. Wrap a referenced URL in TRIM() to remove stray spaces. 3. For files, use the direct download or published-to-web link, not the preview page URL. 4. If the link is time-limited or signed, generate a stable public export URL from the source system instead. 5. Retest after a few minutes; if the URL works in incognito but Sheets keeps reporting not found, the site is treating Google's fetcher differently and the import will not be reliable.
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.